Quiz Discussion

Which is NOT one of the most common types of SQL CHECK constraints?

• 1]

  System date

• 2]

  Range checks

• 3]

  Lists of values

• 4]

  Comparing one column value to another within the same table

What is an advantage of placing computations in SQL views

• 1]

  To save users from having to write an expression

• 2]

  To ensure that the results are consistent

• 3]

  To accomplish both of the above

• 4]

  None of the above

What is not an advantage of stored procedures?

• 1]

  Greater security

• 2]

  SQL can be optimized

• 3]

  Code sharing

• 4]

  Increased network traffic

Count function in SQL returns the number of

• 1]

  Values

• 2]

  Distinct values

• 3]

  Groups

• 4]

  Columns

Which of the following is an advantage of view?

• 1]

  Data security

• 2]

  Derived columns

• 3]

  Hiding of complex queries

• 4]

  All of the above

The SQL ALTER statement can be used to

• 1]

  Change the table structure

• 2]

  Change the table data

• 3]

  Add rows to the table

• 4]

  Delete rows from the table

Which of the following is a legal expression in SQL?

• 1]

  SELECT NULL FROM EMPLOYEE;

   

• 2]

  SELECT NAME FROM EMPLOYEE;

   

• 3]

  SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

   

• 4]

  None of the above

   

Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain

• 1]

  GROUP BY

• 2]

  WHERE

• 3]

  ORDER BY

• 4]

  FROM

‘AS’ clause is used in SQL for

• 1]

  Selection operation

• 2]

  Rename operation

• 3]

  Join operation

• 4]

  Projection operation

What SQL structure is used to limit column values of a table?

• 1]

  The LIMIT constraint

• 2]

  The CHECK constraint

• 3]

  The VALUE constraint

• 4]

  None of the above