Quiz Discussion

The user-defined data type can be created using

• 1]

  Create datatype

• 2]

  Create data

• 3]

  Create definetype

• 4]

  Create type

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

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

The SQL database language includes statements for:

• 1]

  Database definition

• 2]

  Database manipulation

• 3]

  Database control

• 4]

  All of the above

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)

Which of the following closely resembles Create view?

• 1]

  Create table . . .like

• 2]

  Create table . . . as

• 3]

  With data

• 4]

  Create view as

A type of query that is placed within a WHERE or HAVING clause of another query is called

• 1]

  Super query

• 2]

  Multi-query

• 3]

  Subquery

• 4]

  Master query

Here which one denotes the relation for which index is created?

Create index studentID_index on student(ID);

• 1]

  StudentID_index

• 2]

  ID

• 3]

  StudentID

• 4]

  Student

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

Dates must be specified in the format

• 1]

  mm/dd/yy

• 2]

  yyyy/mm/dd

• 3]

  dd/mm/yy

• 4]

  yy/dd/mm