Quiz Discussion

Count function in SQL returns the number of

• 1]

  Values

• 2]

  Distinct values

• 3]

  Groups

• 4]

  Columns

The statement in SQL which allows changing the definition of a table is

• 1]

  Alter

• 2]

  Update

• 3]

  Create

• 4]

  Select

Which of the following is a comparison operator in SQL?

• 1]

  =

• 2]

  LIKE

• 3]

  BETWEEN

• 4]

  All of the above

Which of the following is correct

• 1]

  a SQL query automatically eliminates duplicates

• 2]

  SQL permits attribute names to be repeated in the same relation

• 3]

  a SQL query will not work if there are no indexes on the relations

• 4]

  None of these

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

Which one of the following is not true for a view

• 1]

  View is derived from other tables

• 2]

  View is a virtual table

• 3]

  A view definition is permanently stored as part of the database

• 4]

  View never contains derived columns

Which of the following is a valid SQL type?

• 1]

  CHARACTER

• 2]

  NUMERIC

• 3]

  FLOAT

• 4]

  All of the above

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

Which of the following is an SQL trigger supported by Oracle?

• 1]

  BEFORE

• 2]

  AFTER

• 3]

  INSTEAD OF

• 4]

  All of the above

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