Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. What does a COMMIT statement do to a CURSOR?
a. Open the Cursor
b. Fetch the Cursor
c. Close the Cursor
d. None of the above
Q. Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section
a. Only 1 is TRUE
b. Only 2 is TRUE
c. Both 1 & 2are TRUE
d. Both are FALSE
Q. Which of the following is NOT VALID is PL/SQL?
a. Boolboolean;
b. NUM1, NUM2 number;
c. deptnamedept.dname%type;
d. date1 date := sysdate
Q. Which of the following is not correct about an Exception?
a. Raised automatically / Explicitly in response to an ORACLE_ERROR
b. An exception will be raised when an error occurs in that block
c. Process terminates after completion of error sequence.
d. A Procedure or Sequence of statements may be processe
Q. Which of the following is not correct about User_DefinedExceptions ?
a. Must be declared
b. Must be raised explicitly
c. Raised automatically in response to an Oracle error
d. None of the above
Q. A Stored Procedure is a
a. Sequence of SQL or PL/SQL statements to perform specific function
b. Stored in compiled form in the database
c. Can be called from all client environments
d. All of the above
Q. Which of the following statement is false?
a. Any procedure can raise an error and return an user message and error number.
b. Error number ranging from 20000 to 20999 are reserved for user defined messages.
c. Oracle checks Uniqueness of User defined errors.
d. Raise_Application_error is used for raising an user defined error.
Q. Which of the following is a cursor operation?
a. DECLARE
b. OPEN and FETCH
c. CLOSE
d. All of the above
Q. Which of the following is the clause that makes a singleton SELECT different fromthe normal SELECT?
a. WHERE
b. INTO
c. IN
d. None of the above
Q. Which of the following attribute of implicit cursor always evaluates to false?
a. %FOUND
b. %OPEN
c. %NOTFOUND
d. %ROWCOUNT
Q. Which of the following can be used to supplement declarative referential integrity, to enforce complex business rules or to audit changes to data?
a. Synonyms
b. Tables
c. Triggers
d. None of the above