Quiz Discussion

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

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 closely resembles Create view?

• 1]

  Create table . . .like

• 2]

  Create table . . . as

• 3]

  With data

• 4]

  Create view as

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

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

• 1]

  Clob

• 2]

  Blob

• 3]

  Binary

• 4]

  Image

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

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

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)