Database Management System Set 52

Learning Mode Previous Next

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

INSERT

FETCH

Q17 | Which of the following is a cursor operation?

DECLARE

OPEN and FETCH

All of the above

Q18 | Which of the following is not an executable statement?

DECLARE

OPEN

FECTH

Q19 | Which of the following is the clause that makes a singleton SELECT different fromthe normal SELECT?

WHERE

INTO

None of the above

Q20 | How many attributes are associated with cursors?

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

Previous Next