Tag: databases

Questions Related to databases

RAISE_APPLICATION_ERROR is a built-in procedure in oracle which is used to display the user-defined error messages along with the error number. What is the range of the error number for user defined error messages:

technology databases

  1. Between -20000 and -20999

  2. Between -200000 and -209999

  3. Between -20001 and -20999

  4. Between -200001 and -209999

Show answer
Correct Option: A

Which statement would change the default date format to a specified format for the current session?
technology 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 =

Show answer
Correct Option: C

WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?

technology databases

  1. 32767

  2. 1024

  3. 255

  4. 32765

Show answer
Correct Option: A

Which one of the following is maximum limit for output generated by DBMS_OUTPUT?
technology databases

  1. 10000000

  2. 1000000

  3. 100000

  4. 1000

Show answer
Correct Option: B

Which one of the following contains only valid PL/SQL reserved words?
technology databases

  1. TO_CHAR, INOUT

  2. PROC, PACKAGE

  3. PRAGMA, MULTI_ROW

  4. SELECT, EXCEPTION

Show answer
Correct Option: D

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

  1. SET AUTOTRACE TRACEONLY

  2. SET AUTOTRACE ON

  3. SET AUTOTRACE ON STATISTICS

  4. SET AUTOTRACE ON EXPLAIN

Show answer
Correct Option: B

What does the <<>> lexical unit or delimiter signify in PL/SQL?
technology databases

  1. Comment marker

  2. Not equal to operator

  3. Label delimiter

  4. Greater than or equal to operator

Show answer
Correct Option: C

Which one of the following is a valid RAISE_APPLICATION_ERROR call?
technology databases

  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);

Show answer
Correct Option: B

Which one of the following provides you with the number of records affected by the last DML statement?

technology databases

  1. SQL%ROWCOUNT

  2. SQL%COUNT

  3. SQL%FOUND

  4. SQL%NUM_ROWS

Show answer
Correct Option: A
  1. Which of the following are two architectural attributes of a Teradata System?
technology databases

  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

Show answer
Correct Option: C,D