Quiz Discussion

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

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

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

   

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

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 an SQL trigger supported by Oracle?

• 1]

  BEFORE

• 2]

  AFTER

• 3]

  INSTEAD OF

• 4]

  All of the above

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

• 1]

  UPDATE

• 2]

  DROP

• 3]

  ALTER

• 4]

  DELETE

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

The language which has recently become the defacto standard for interfacing application programs with relational database system is

• 1]

  Oracle

• 2]

  SQL

• 3]

  DBase

• 4]

  4GL