Quiz Discussion

A report generator is used to

• 1]

  update files

• 2]

  print files on paper

• 3]

  data entry

• 4]

  delete files

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

• 1]

  BEFORE

• 2]

  AFTER

• 3]

  INSTEAD OF

• 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

What is not an advantage of stored procedures?

• 1]

  Greater security

• 2]

  SQL can be optimized

• 3]

  Code sharing

• 4]

  Increased network traffic

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

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

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

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

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

• 1]

  UPDATE

• 2]

  DROP

• 3]

  ALTER

• 4]

  DELETE