Correct answer is  (b)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (d)  

 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 5 minutes on this assessment from Sat Apr 28 08:56:50 UTC+0800 2007 to Sat Apr 28 09:01:12 UTC+0800 2007. 

 Total score: 80.00 
 
 

 

 1. 
 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) re-prompting for the entry of a string whose length is exactly n.
 (d) padding the end of the string with NULL characters to length n before storing it.  

 Correct answer is  (b)  

 Your score on this question is: 0.00  
 



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

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

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

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (d)  

 Your score on this question is: 0.00  
 

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

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

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

 Correct answer is  (a)  

 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. 
 In SQL, when destroying a database, the RESTRICT option removes  
 

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

 Correct answer is  (c)  

 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) AS
 (b) ALIAS
 (c) RENAME
 (d) @  

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

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

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

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

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

 Go to top of assessment.  

 Total score: 80.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: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.