Correct answer is  (a)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 5. 
 Which of the following SQL statements can be used to remove a row from a table?  
 

  (a) DESTROY
 (b) DELETE
 (c) REMOVE
 (d) ERASE  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 6. 
 A deletion operation will _____ if the deletion leads to the violation of a referential integrity constraint.  
 

  (a) succeed without warning
 (b) crash the system
 (c) fail
 (d) succeed with warning  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 7. 
 The SQL clause to perform a set difference operation is  
 

  (a) DIFFER
 (b) EXCEPT
 (c) REJECT
 (d) OMIT  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 8. 
 Which of the following SQL statements can be used to add a row to a table?  
 

  (a) INSERT
 (b) ADD
 (c) CREATE
 (d) APPEND  

 Correct answer is  (a)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 9. 
 What can be specified in the selection condition of a SELECT statement?  
 

  (a) the conditions under which the statement should be executed
 (b) an arithmetic operation
 (c) a Boolean operation
 (d) the time at which the selection should be performed  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 10. 
 The term query by example refers to  
 

  (a) example SQL queries provided by other users that can be modified to suit current needs
 (b) a visual query language developed by IBM
 (c) example SQL queries provided by the DBMS that users can modify to suit their current needs
 (d) a query for SQL examples  

 Correct answer is  (b)  

 Your score on this question is: 10.00  

 Feedback: 
   
See section 1.2.3 in the course notes.
 
 

--------------------------------------------------------------------------------

 Go to top of assessment.  

 Total score: 90.00 

 ? Copyright 2004 iCarnegie, Inc. All rights reserved.  

 10. 
 With Query By Example, a user enters a query by  
 

  (a) writing an English description of the data that the user needs
 (b) typing a syntactically correct SQL query that uses column and table names similar to the correct column and table names in a database
 (c) filling in skeleton tables of the database with examples of what is to be retrieved
 (d) placing SQL keywords, such as select, under the column names they want to retrieve  

 Correct answer is  (c)  

 Your score on this question is: 10.00  

 Feedback: 
   
See section 1.2.3 in the course notes.
 
 

 8. 
 A join operation joins _____ tables into _____.  
 

  (a) three, two
 (b) three, one
 (c) four, two
 (d) two, one  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 
Your performance was as follows: 

 You took 2 minutes on this assessment from Sat Apr 28 09:03:45 UTC+0800 2007 to Sat Apr 28 09:05:21 UTC+0800 2007. 

 Total score: 100.00 
 
 

 

 1. 
 In SQL, a database can be created by which of the following?  
 

  (a) the command CREATE SCHEMA
 (b) a series of CREATE TABLE commands
 (c) the command ADD DATABASE
 (d) the command INSERT DATABASE  

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 



--------------------------------------------------------------------------------

 2. 
 When removing a table from the schema, using the RESTRICT option would  
 

  (a) remove the table and all other tables that the specified table refers to
 (b) recursively remove the table and all other tables that the removed table refers to
 (c) remove the table if there are no references to it
 (d) remove the table and all references to it  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 3. 
 In SQL, when destroying a database, the RESTRICT option removes  
 

  (a) the data and schema from the specified database, but not from related databases
 (b) everything in the specified database: the data, schema, etc.
 (c) the data but not the schema
 (d) the schema if the database has no data (empty tables)  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 4. 
 In SQL, a database can be destroyed by which of the following?  
 

  (a) the command DROP SCHEMA
 (b) the command DELETE DATABASE
 (c) the command DESTROY DATABASE
 (d) a series of DESTROY TABLE commands  

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 5. 
 In SQL, one function of the AS operator is to  
 

  (a) control the order in which a query’s rows are sorted
 (b) customize the names of columns in a query’s result
 (c) define the domain of an attribute
 (d) limit the cardinality of a relation  

 Correct answer is  (b)  

 Your score on this question is: 10.00  

 Feedback: 
   
See section 2.1.2, subsection "Aliasing in SQL: The AS operator," in the course notes.
 
 

--------------------------------------------------------------------------------

 6. 
 When a string whose length is strictly less than n is entered as the value of a field whose SQL data type is VARCHAR(n), the system responds by  
 

  (a) padding the end of the string with spaces to length n before storing it.
 (b) storing the string as is.
 (c) padding the end of the string with NULL characters to length n before storing it.
 (d) re-prompting for the entry of a string whose length is exactly n.  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 7. 
 In a FROM clause of a SELECT statement in SQL, a table can be aliased with which of the following operators?  
 

  (a) ALIAS
 (b) @
 (c) RENAME
 (d) AS  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 8. 
 When specifying a selection criterion in SQL, attributes can be renamed with which of the following operators?  
 

  (a) RENAME
 (b) ALIAS
 (c) @
 (d) AS  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 9. 
 In SQL, which of the following clauses can be used to sort results in ascending or descending order of attribute values?  
 

  (a) ARRANGE BY
 (b) SORT
 (c) GROUP BY
 (d) ORDER BY  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 10. 
 In SQL, which of the following operators can be used to express searches that test for a range in a selection condition?  
 

  (a) FROM and TO
 (b) BETWEEN
 (c) START and END
 (d) RANGE  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 Go to top of assessment.  

 Total score: 100.00 

 ? Copyright 2004 iCarnegie, Inc. All rights reserved 

 Your performance was as follows: 

 You took 2 minutes on this assessment from Sat Apr 28 09:01:42 UTC+0800 2007 to Sat Apr 28 09:03:31 UTC+0800 2007. 

 Total score: 100.00 
 
 

 

 1. 
 In SQL, a database can be created by which of the following?  
 

  (a) the command INSERT DATABASE
 (b) the command ADD DATABASE
 (c) a series of CREATE TABLE commands
 (d) the command CREATE SCHEMA  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 



--------------------------------------------------------------------------------

 2. 
 In SQL, when destroying a database, the RESTRICT option removes  
 

  (a) everything in the specified database: the data, schema, etc.
 (b) the schema if the database has no data (empty tables)
 (c) the data but not the schema
 (d) the data and schema from the specified database, but not from related databases  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 3. 
 In SQL, one function of the AS operator is to  
 

  (a) control the order in which a query’s rows are sorted
 (b) limit the cardinality of a relation
 (c) define the domain of an attribute
 (d) customize the names of columns in a query’s result  

 Correct answer is  (d)  

 Your score on this question is: 10.00  

 Feedback: 
   
See section 2.1.2, subsection "Aliasing in SQL: The AS operator," in the course notes.
 
 

--------------------------------------------------------------------------------

 4. 
 When a string whose length is strictly less than n is entered as the value of a field whose SQL data type is VARCHAR(n), the system responds by  
 

  (a) storing the string as is.
 (b) padding the end of the string with spaces to length n before storing it.
 (c) padding the end of the string with NULL characters to length n before storing it.
 (d) re-prompting for the entry of a string whose length is exactly n.  

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 5. 
 In SQL, a database can be destroyed by which of the following?  
 

  (a) a series of DESTROY TABLE commands
 (b) the command DROP SCHEMA
 (c) the command DELETE DATABASE
 (d) the command DESTROY DATABASE  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 6. 
 In SQL, when destroying a database, the CASCADE option removes  
 

  (a) everything in the specified database: the data, schema, etc.
 (b) the data and schema from the specified database, and from related databases
 (c) the schema if the database has no data (empty tables)
 (d) the data but not the schema  

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 7. 
 In SQL, which of the following operators can be used to express searches that test for a range in a selection condition?  
 

  (a) START and END
 (b) FROM and TO
 (c) BETWEEN
 (d) RANGE  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 8. 
 When specifying a selection criterion in SQL, attributes can be renamed with which of the following operators?  
 

  (a) RENAME
 (b) AS
 (c) @
 (d) ALIAS