On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 52

Q1 | In case of entity integrity, the primary key may be
  • not Null
  • Null.
  • both Null & not null
  • any value
Q2 | The language used in application programs to request data from the DBMS is referred to as the
  • DML
  • DDL
  • VDL
  • SDL
Q3 | Related fields in a database are grouped to form a
  • data file.
  • data record.
  • menu.
  • bank.
Q4 | The language which has recently become the defacto standard for interfacing application programs with relational database system is
  • Oracle.
  • SQL.
  • DBase.
  • 4GL.
Q5 | Transaction ends
  • Only when it is Committed
  • Only when it is Rolledback
  • When it is Committed or Rolledback
  • None of the above
Q6 | A Database Procedure is stored in the Database
  • In compiled form
  • As source code
  • Both A & B
  • Not stored
Q7 | Dedicated server configuration is
  • One server process – Many user processes
  • Many server processes – One user process
  • One server process – One user process
  • Many server processes – Many user processes
Q8 | Which of the following does not affect the size of the SGA?
  • Database buffer
  • Redolog buffer
  • Stored procedure
  • Shared pool
Q9 | What does a COMMIT statement do to a CURSOR?
  • Open the Cursor
  • Fetch the Cursor
  • Close the Cursor
  • None of the above
Q10 | Which of the following is TRUE? (1) Host variables are declared anywhere in the program (2) Host variables are declared in the DECLARE section
  • Only 1 is TRUE
  • Only 2 is TRUE
  • Both 1 & 2are TRUE
  • Both are FALSE
Q11 | Which of the following is NOT VALID is PL/SQL?
  • Boolboolean;
  • NUM1, NUM2 number;
  • deptnamedept.dname%type;
  • date1 date := sysdate
Q12 | Which of the following is not correct about an Exception?
  • Raised automatically / Explicitly in response to an ORACLE_ERROR
  • An exception will be raised when an error occurs in that block
  • Process terminates after completion of error sequence.
  • A Procedure or Sequence of statements may be processed.
Q13 | Which of the following is not correct about User_DefinedExceptions ?
  • Must be declared
  • Must be raised explicitly
  • Raised automatically in response to an Oracle error
  • None of the above
Q14 | A Stored Procedure is a
  • Sequence of SQL or PL/SQL statements to perform specific function
  • Stored in compiled form in the database
  • Can be called from all client environments
  • All of the above
Q15 | Which of the following statement is false?
  • Any procedure can raise an error and return an user message and error number.
  • Error number ranging from 20000 to 20999 are reserved for user defined messages.
  • Oracle checks Uniqueness of User defined errors.
  • Raise_Application_error is used for raising an user defined error.
Q16 | Find the ODD one out of the following:
  • OPEN
  • CLOSE
  • INSERT
  • FETCH
Q17 | Which of the following is a cursor operation?
  • DECLARE
  • OPEN and FETCH
  • CLOSE
  • All of the above
Q18 | Which of the following is not an executable statement?
  • DECLARE
  • OPEN
  • FECTH
  • CLOSE
Q19 | Which of the following is the clause that makes a singleton SELECT different fromthe normal SELECT?
  • WHERE
  • INTO
  • IN
  • None of the above
Q20 | How many attributes are associated with cursors?
  • 1
  • 2
  • 3
  • 4
Q21 | Which of the following attribute of implicit cursor always evaluates to false?
  • %FOUND
  • %OPEN
  • %NOTFOUND
  • %ROWCOUNT
Q22 | Which of the following can be used to supplement declarative referential integrity, to enforce complex business rules or to audit changes to data?
  • Synonyms
  • Tables
  • Triggers
  • None of the above
Q23 | Which of the following can initiate a trigger?
  • INSERT
  • UPDATE
  • DELETE
  • All of the above
Q24 | Which of the following SQL standard support triggers?
  • SQL-89
  • SQL-2
  • SQL-3
  • SQL-4
Q25 | Which of the following trigger is executed once for each row in a transaction?
  • Row-level Triggers
  • Statement-level Triggers
  • Repetitive Triggers
  • All of the above