Unit 6 True

Topics: SQL, Database, Data Manipulation Language Pages: 1 (287 words) Published: August 1, 2015
Unit 6 True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.

1)SQL is the programming language used to manipulate data and data objects in a relational database management system. TRUE 2)SQL is a procedural language. FALSE
3)A declarative language is a language in which you tell the computer what to do not how. TRUE 4)DML, or Data Manipulation Language, contains all the commands for selecting and modifying data. TRUE 5)DDL, or Data Definition Language, contains all the commands for selecting and modifying data. FALSE 6)The * in SELECT * clause of an SQL statement is a wildcard for returning all columns in a table. TRUE 7)The DISTINCT keyword in a SELECT statement returns only unique rows. TRUE 8)The FROM keyword is used in a SELECT clause to determine which columns are included in the query. FALSE 9)An alias in SQL is a substitute name for a column or table. TRUE 10)When using an alias in SQL, the AS keyword is required. FALSE 11)By default, ORDER BY sorts a column in an ascending order. TRUE 12)DESC reverses the sort order of ORDER BY. TRUE

13)The WHERE clause is used to set criteria by which to filter which rows are returned or affected. TRUE 14)The LIKE keyword can be used with the '%' to search for patterns in character data. TRUE 15)The LIKE keyword can be used to search data with any kind of data type. TRUE 16)The BETWEEN keyword used in a criteria is inclusive of its boundary values. FALSE 17)When NULL is used as a criteria it can be accessed using operators such as = < >. TRUE
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about unit 6
  • Essay about unit 6 p2 helpsheet
  • Unit 6 Essay
  • unit 6 Essay
  • Sc300-Unit 6 Assignment Essay
  • unit 6 study guide Essay
  • AdamsTina Unit 6 Assignment Essay
  • Essay on memo for unit 6 assignment

Become a StudyMode Member

Sign Up - It's Free