Tag: databases

Questions Related to databases

  1. ALTER SESSION SET NEW_DATE_FORMAT =

  2. ALTER SESSION SET CUR_DATE_FORMAT =

  3. ALTER SESSION SET NLS_DATE_FORMAT =

  4. ALTER SESSION SET SESS_DATE_FORMAT =


Correct Option: C
  1. TO_CHAR, INOUT

  2. PROC, PACKAGE

  3. PRAGMA, MULTI_ROW

  4. SELECT, EXCEPTION


Correct Option: D

Which one of the following SQL*Plus options lets you trace and print the execution plans as well as statistics?

  1. SET AUTOTRACE TRACEONLY

  2. SET AUTOTRACE ON

  3. SET AUTOTRACE ON STATISTICS

  4. SET AUTOTRACE ON EXPLAIN


Correct Option: B
  1. Comment marker

  2. Not equal to operator

  3. Label delimiter

  4. Greater than or equal to operator


Correct Option: C
  1. RAISE_APPLICATION_ERROR(-21001);

  2. RAISE_APPLICATION_ERROR(-20001,'An error has occurred');

  3. RAISE_APPLICATION_ERROR(-21001,'An error has occurred');

  4. RAISE_APPLICATION_ERROR(-20001);


Correct Option: B
  1. Disk space associated with an AMP is divided into three areas: system, permanent and spool

  2. Parallelism is achieved through operating system time slicing

  3. The AMP’s access data from their associated vdisks as required.

  4. The PE’s communicate with the AMP’s across the BYNET


Correct Option: C,D