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

 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  

 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.  
View Assessment Result: Multiple-Choice Quiz 4


 

 Your performance was as follows:  

 1. 
 Which of the following is true about views being up to date?  
 

  (a) Views are never up to date; there is always a lag time.
 (b) Views can be automatically made up to date periodically by the system.
 (c) Views are up to date only after the synchronization operation by the user.
 (d) Views are always up to date.  

 Correct answer is  (d)  

 Your score on this question is: 0.00  
 

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

 2. 
 A vertical view allows users access to  
 

  (a) only specific columns of the defining tables
 (b) only specific rows of the defining tables
 (c) only the system tables
 (d) only the user tables  

 Correct answer is  (a)  

 Your score on this question is: 10.00  
 

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

 3. 
 Which of the following is true about updateability of views?  
 

  (a) A view is updateable if it involves one table and does not contain a key.
 (b) A view is updateable if it involves multiple tables and no keys.
 (c) A view is not updateable under any circumstance.
 (d) A view is updateable if it involves one table and contains a key.  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

 4. 
 Consider two tables, Employee(EmpNo, Name, DeptNo) and Department(DeptNo, Name, Manager) with primary keys being EmpNo and DeptNo respectively. The DeptNo attribute of the Employee table has a NOT NULL constraint and is a foreign key that references the DeptNo attribute of the Department table. The Manager attribute of the Department table has a NOT NULL constraint and is a foreign key that references the EmpNo attribute of the Employee table. When the tables are empty, the only way to insert rows into the two tables is  
 

  (a) to use a transaction in NOT DEFERRABLE mode
 (b) not to use a transaction at all
 (c) to use a transaction either in DEFERRABLE mode or in NOT DEFERRABLE mode
 (d) to use a transaction in DEFERRABLE mode  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

 5. 
 Which of the following referentially triggered actions are supported in SQL when a referential integrity constraint is violated? 
SET NULL 
REJECT 
CASCADE 
SET DEFAULT 
 
 

  (a) I, II, and III only
 (b) I, III, and IV only
 (c) II and III only
 (d) I and IV only  

 Correct answer is  (b)  

 Your score on this question is: 0.00  
 

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

 6. 
 Which of the following commands can be used to remove access privileges associated with a table?  
 

  (a) REMOVE
 (b) DENY
 (c) REVOKE
 (d) RETRACT  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

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

 7. 
 Which of the following commands can be used to give access permissions to a table?  
 

  (a) ALLOW
 (b) AUTHORIZE
 (c) PERMIT
 (d) GRANT  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

 8. 
 Who can always give access permissions to a table?  
 

  (a) the user of the table
 (b) only the super-user
 (c) only the database administrator (DBA)
 (d) the owner of the table  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

 9. 
 When is embedded SQL referred to as dynamic SQL?  
 

  (a) when the embedded SQL always returns different sets of results
 (b) when the embedded SQL operates on the dynamic part of the database
 (c) when the SQL statements are changed in every run
 (d) when the embedded SQL is translated into DBMS calls at run-time  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

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

 10. 
 When is embedded SQL referred to as static SQL?  
 

  (a) when the embedded SQL operates on the static part of the database
 (b) when the embedded SQL always returns the same set of results
 (c) when the