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:
Between -20000 and -20999
Between -200000 and -209999
Between -20001 and -20999
Between -200001 and -209999
Which statement would change the default date format to a specified format for the current session?
ALTER SESSION SET NEW_DATE_FORMAT =
ALTER SESSION SET CUR_DATE_FORMAT =
ALTER SESSION SET NLS_DATE_FORMAT =
ALTER SESSION SET SESS_DATE_FORMAT =
WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?
32767
1024
255
32765
Which one of the following is maximum limit for output generated by DBMS_OUTPUT?
10000000
1000000
100000
1000
Which one of the following contains only valid PL/SQL reserved words?
TO_CHAR, INOUT
PROC, PACKAGE
PRAGMA, MULTI_ROW
SELECT, EXCEPTION
Which one of the following SQL*Plus options lets you trace and print the execution plans as well as statistics?
SET AUTOTRACE TRACEONLY
SET AUTOTRACE ON
SET AUTOTRACE ON STATISTICS
SET AUTOTRACE ON EXPLAIN
What does the <<>> lexical unit or delimiter signify in PL/SQL?
Comment marker
Not equal to operator
Label delimiter
Greater than or equal to operator
Which one of the following is a valid RAISE_APPLICATION_ERROR call?
RAISE_APPLICATION_ERROR(-21001);
RAISE_APPLICATION_ERROR(-20001,'An error has occurred');
RAISE_APPLICATION_ERROR(-21001,'An error has occurred');
RAISE_APPLICATION_ERROR(-20001);
Which one of the following provides you with the number of records affected by the last DML statement?
SQL%ROWCOUNT
SQL%COUNT
SQL%FOUND
SQL%NUM_ROWS
Disk space associated with an AMP is divided into three areas: system, permanent and spool
Parallelism is achieved through operating system time slicing
The AMP’s access data from their associated vdisks as required.
The PE’s communicate with the AMP’s across the BYNET