Tag: databases

Questions Related to databases

Dropping a table causes its synonym to drop.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

can we rename a Synonym?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

If a table is dropped, then triggers created on it will also be dropped.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Select belongs to which type of language?
technology databases

  1. DDL

  2. DML

  3. DCL

  4. None of the Above

Show answer
Correct Option: D

DESC belongs to
technology databases

  1. DDL

  2. DCL

  3. DML

  4. None the above

Show answer
Correct Option: D

Dropped table can be got back without recreating it.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

How can we calculate average of a column?
technology databases

  1. using AVG () function

  2. Using AVERAGE() function

  3. using SUM() and Count() functions

  4. using Total() function

Show answer
Correct Option: A,C

what are the functions used for calculating sub totals ?
technology databases

  1. Using Rollup() function

  2. Using SUBTOT() function

  3. Using SUBSUM() function

  4. All the above

Show answer
Correct Option: A

Which process registers the logfile in a standby database ?
technology databases

  1. RFS

  2. MRP

  3. ARCH

  4. LGWR

Show answer
Correct Option: C

Which process reads data from the data file into the database buffer cache ?
technology databases

  1. Server process

  2. DBWR

  3. CKPT

  4. PMON

Show answer
Correct Option: A