Database Management System Set 52
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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