Tag: databases

Questions Related to databases

A data item describes a particular attribute of a record.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. None

  2. Record

  3. Record Structure

  4. Record Occurence

Show answer
Correct Option: B,D

Structure of the record in the database is called
technology databases

  1. Data Item

  2. Record Occurence

  3. Record

  4. Record Type

Show answer
Correct Option: D

"Pages" contain
technology databases

  1. Areas

  2. Record Occurence

  3. Record Type

  4. Data Item

Show answer
Correct Option: B

A "page" can have multiple record-occurences
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which two statements about views are true? (Choose two.)
technology databases

  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.

Show answer
Correct Option: A,B,C,D

In which case would you use a FULL OUTER JOIN?
technology databases

  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.

Show answer
Correct Option: D

Difference between Truncate and Delete
technology databases

  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

Show answer
Correct Option: A

Difference between Truncate and Delete(select multiple answers)
technology databases

  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

Show answer
Correct Option: A

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?
technology databases

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS_RECD

  3. USER_COL_PRIVS_MADE

  4. USER_COL_PRIVS_RECD

Show answer
Correct Option: D