Database Management System (DBMS) MCQ Questions and answers

A

Admin • 833.24K Points
Coach

Q. A CASE SQL statement is which of the following?

(A) A way to establish an IF-THEN-ELSE in SQL.
(B) A way to establish a loop in SQL.
(C) A way to establish a data definition in SQL.
(D) All of the above.

A

Admin • 833.24K Points
Coach

Q. Which of the following statements is true concerning routines and triggers?

(A) Both consist of procedural code.
(B) Both have to be called to operate.
(C) Both run automatically.
(D) Both are stored in the database.

A

Admin • 833.24K Points
Coach

Q. How many bytes does each character in the UTF8 encoding take up?

(A) 1
(B) 2
(C) 3
(D) All mentioned above

A

Admin • 833.24K Points
Coach

Q. PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

(A) Procedure
(B) Function
(C) Both A & B
(D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which datatype is not allowed in the definition of PL/SQL record?

(A) A Collection
(B) A Scalar
(C) Both A & B
(D) None of the above

A

Admin • 833.24K Points
Coach

Q. In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

(A) %ROWCOUNT
(B) %FOUND
(C) %NOTFOUND
(D) %ISOPEN

A

Admin • 833.24K Points
Coach

Q. For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

(A) TOO_MANY_ROWS
(B) NO_DATA_FOUND
(C) VALUE_ERROR
(D) DUP_VAL_ON_INDEX

A

Admin • 833.24K Points
Coach

Q. In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

(A) 0
(B) 99
(C) 1
(D) 100

A

Admin • 833.24K Points
Coach

Q. Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?

(A) Associative arrays
(B) Nested tables
(C) Varrays
(D) None of the above

A

Admin • 833.24K Points
Coach

Q. Assigning a value to a collection element can cause exceptions, such as

(A) If the subscript is NULL or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must be an integer. Associative arrays can also be declared to have VARCHAR2 subscripts.
(B) If the subscript refers to an uninitialized element, PL/SQL raises SUBSCRIPT_BEYOND_COUNT.
(C) If the collection is atomically null, PL/SQL raises COLLECTION_IS_NULL.
(D) All mentioned above

Database Management System (DBMS) MCQs with answers Page - 141

Q. A CASE SQL statement is which of the following?

Q. Which of the following statements is true concerning routines and triggers?

Q. How many bytes does each character in the UTF8 encoding take up?

Q. PL/SQL has two types of subprograms, procedures and functions. Which subprogram isused to compute a value?

Q. Which datatype is not allowed in the definition of PL/SQL record?

Q. In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?

Q. For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria?

Q. In the PL/SQL block below, how many rows will be inserted in the messages table? DECLARE v_start_salesNUMBER := 2; v_end_sales NUMBER := 100; BEGIN FOR i IN v_start_sales..v_end_sales LOOP INSERT INTO messages(msgid) VALUES v_start_sales; END LOOP; END;

Q. Which collection types is also known as index-by tables, lets you look up elements Using arbitrary numbers and strings for subscript values?

Q. Assigning a value to a collection element can cause exceptions, such as

Add MCQ in this Category

Browse Categories