Quiz Discussion

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 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

   

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

A report generator is used to

• 1]

  update files

• 2]

  print files on paper

• 3]

  data entry

• 4]

  delete files

Count function in SQL returns the number of

• 1]

  Values

• 2]

  Distinct values

• 3]

  Groups

• 4]

  Columns

‘AS’ clause is used in SQL for

• 1]

  Selection operation

• 2]

  Rename operation

• 3]

  Join operation

• 4]

  Projection operation

To delete a particular column in a relation the command used is

• 1]

  UPDATE

• 2]

  DROP

• 3]

  ALTER

• 4]

  DELETE

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

• 1]

  BEFORE

• 2]

  AFTER

• 3]

  INSTEAD OF

• 4]

  All of the above

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

• 1]

  Alter

• 2]

  Update

• 3]

  Create

• 4]

  Select

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