Quiz Discussion

The SQL database language includes statements for:

• 1]

  Database definition

• 2]

  Database manipulation

• 3]

  Database control

• 4]

  All of the above

Values of one type can be converted to another domain using which of the following?

• 1]

  Cast

• 2]

  Drop type

• 3]

  Alter type

• 4]

  Convert

Which SQL Query is used to remove a table and all its data from the database?

• 1]

  Create Table

• 2]

  Alter Table

• 3]

  Drop Table

• 4]

  None of these

The user-defined data type can be created using

• 1]

  Create datatype

• 2]

  Create data

• 3]

  Create definetype

• 4]

  Create type

Which of the following is used to store movie and image files?

• 1]

  Clob

• 2]

  Blob

• 3]

  Binary

• 4]

  Image

Which of the following closely resembles Create view?

• 1]

  Create table . . .like

• 2]

  Create table . . . as

• 3]

  With data

• 4]

  Create view as

In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:

CREATE DOMAIN YearlySalary NUMERIC(8,2)
CONSTRAINT salary VALUE test __________;

• 1]

  Value>=30000.00

• 2]

  Not null;

• 3]

  Check(value >= 29000.00);

• 4]

  Check(value)

An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

• 1]

  Index

• 2]

  Reference

• 3]

  Assertion

• 4]

  Timestamp

Which of the following statements creates a new table temp instructor that has the same schema as an instructor?

• 1]

  Create table temp_instructor;

   

• 2]

  Create table temp_instructor like instructor;

   

• 3]

  Create Table as temp_instructor;

   

• 4]

  Create table like temp_instructor;

   

In contemporary databases, the top level of the hierarchy consists of _______ each of which can contain ______

• 1]

  Catalogs, schemas

• 2]

  Schemas, catalogs

• 3]

  Environment, schemas

• 4]

  Schemas, Environment