Computer Science Engineering MCQ
151- Which of the following command makes the updates performed by the transaction permanent in the database?
(A) ROLLBACK
(B) COMMIT
(C) TRUNCATE
(D) DELETE
152- PL/SQL is a ________ language.
(A) BLOCK-STRUCTURED
(B) MODULAR
(C) RESTRICTED
(D) MIDDLE-LEVEL
153- If the Oracle Engine has opened a cursor for its internal processing, it is known as _____ cursor.
(A) EXPLICIT
(B) INTERNAL
(C) IMPLICIT
(D) None of the above
154- Which of the following marks and saves the current point in the processing of a transaction?
(A) WORK
(B) CURRENT
(C) ROLLPOINT
(D) SAVEPOINT
155- The data stored in the cursor is called the ______.
(A) DATA SET
(B) DATA MODEL
(C) ACTIVE DATA SET
(D) DATA WAREHOUSE
156- Which of the following command should be fired/executed before creating a Savepoint?
(A) ROLLBACK
(B) COMMIT
(C) WORK
(D) None of the above
157- PL/SQL is a ______ of SQL.
(A) SUPERSET
(B) SUBSET
(C) MEMBER
(D) None of the above
158- PL/SQL code blocks start with a ______ Section.
(A) BEGIN
(B) MASTER BEGIN
(C) DECLARATION
(D) EXCEPTION
159- DNS stands for
(A) Data Network Security
(B) Domain Name System
(C) Domain Network Security
(D) None of the above
160- PL/SQL uses the _____ attribute to declare variables based on definitions of columns in a table.
(A) %TYPE
(B) NULL
(C) NOT NULL
(D) DECLARE
ANSWERS:
151-(B), 152-(A), 153-(C), 154-(D), 155-(C), 156-(B), 157-(A), 158-(C), 159-(B), 160-(A)