Tag: databases

Questions Related to databases

A data item describes a particular attribute of a record.

  1. True

  2. False


Correct Option: A

A collection of data items with real life values is called a

  1. None

  2. Record

  3. Record Structure

  4. Record Occurence


Correct Option: B,D
  1. Data Item

  2. Record Occurence

  3. Record

  4. Record Type


Correct Option: D
  1. Areas

  2. Record Occurence

  3. Record Type

  4. Data Item


Correct Option: B
  1. A view can be created as read only.

  2. A view can be created as a join on two or more tables. AND Insert and delete operations cannot be performed on views using functions

  3. A view cannot have an ORDER BY clause in the SELECT statement.

  4. A view cannot be created with a GROUP BY clause in the SELECT statement.


Correct Option: A,B,C,D
  1. Both tables have NULL values.

  2. You want all unmatched data from one table.

  3. You want all matched data from both tables.

  4. You want all unmatched data from both tables.

  5. One of the tables has more data than the other.


Correct Option: D
  1. TRUNCATE is a DDL command whereas DELETE is a DML command

  2. TRUNCATE is much faster than DELETE

  3. In case of TRUNCATE ,Trigger doesn't get fired.But in DML commands like DELETE .Trigger get fired

  4. All of the above


Correct Option: A
  1. TRUNCATE is a DDL command whereas DELETE is a DML command

  2. TRUNCATE is much faster than DELETE

  3. In case of TRUNCATE ,Trigger doesn't get fired.But in DML commands like DELETE .Trigger get fired

  4. All of the above


Correct Option: A
  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS_RECD

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS_RECD


Correct Option: D