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 advantage of view?

• 1]

  Data security

• 2]

  Derived columns

• 3]

  Hiding of complex queries

• 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 of the following is a valid SQL type?

• 1]

  CHARACTER

• 2]

  NUMERIC

• 3]

  FLOAT

• 4]

  All of the above

A reason for using an SQL view to hide columns is

• 1]

  to simplify a result only

• 2]

  to prevent the display of sensitive data only

• 3]

  to accomplish both of the above

• 4]

  None of the above

‘AS’ clause is used in SQL for

• 1]

  Selection operation

• 2]

  Rename operation

• 3]

  Join operation

• 4]

  Projection operation

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

• 1]

  BEFORE

• 2]

  AFTER

• 3]

  INSTEAD OF

• 4]

  All 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

Count function in SQL returns the number of

• 1]

  Values

• 2]

  Distinct values

• 3]

  Groups

• 4]

  Columns

Which of the following is a comparison operator in SQL?

• 1]

  =

• 2]

  LIKE

• 3]

  BETWEEN

• 4]

  All of the above