Relational Database Management System MCQ : Relational Database Design - PL/PgSqL: Datatypes, Language structure : Link2
RDBMS MCQ & Answers
Are you worried about the answers to Relational Database Management System questions-Relational Database Design : PL/PgSqL: Datatypes, Language structure? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.
Q.1. Which of the following is true about scalar data types in PL/SQL?
A. They hold single values with no internal components.
B. Examples of scalar data types are NUMBER, DATE, or BOOLEAN.
C. PL/SQL provides subtypes of data types.
D. All of the above
Q.2.Which of the following is not true about PL/SQL constants and literals?
A. A constant holds a value that once declared, does not change in the program.
B. The CONSTANT declaration cannot impose the NOT NULL constraint.
C. A constant is declared using the CONSTANT keyword.
D. A CONSTANT declaration requires an initial value.
Q.3. What value will be assigned to the variable declared as − counter binary_integer;
A. 0
B. 1
C. NULL D. None of the above
Q.4. Which of the following is explicit numeric, string, or BOOLEAN value not represented identifier?
A. Delimiters
B. Literals
C. Comments D. None of the above
Q.5. Which of the following is not true about large object data types and in PL/SQL?
A. BFILE is used to store large binary objects in operating system files outside the database.
B. BLOB is used to store character data in the database.
C. CLOB is used to store large blocks of character data in the database.
D. NCLOB is used to store large blocks of NCHAR data in the database.
Q.6. Which of the following is true about comments in PL/SQL?
A. Comments are explanatory statements.
B. The PL/SQL single-line comments start with the delimiter — (double hyphen)
C. Multi-line comments are enclosed by /* and */.
D. All of the above.
Q.7. Which is a simple or compound symbol that has a special meaning to PL/SQL?
A. Delimiters
B. Identifiers
C. Literals
D. Comments
Q.8. PL/SQL is a procedural language that has which of the following advantages?
A. Integration with database
B. Better Performance
C. Portability
D. All of the above
Q.9. Which data type supports only sequential access of objects?
A. LONG
B. LOB
C. Both A & B
D. None of the above
Q.10. Is it possible to define a CONSTANT value in a record?
A. Yes
B. No
C. Depends upon
D. None of the above
Q.11. Which datatypes can be used with a RECORD Type?
A. NUMBER,VARCHAR2
B. %TYPE OR %ROWTYPE
C. BOTH A & B D. REF,CURSOR
Q.12. Which of the following is used to declare a record?
A. %ROWTYPE
B. %TYPE
C. Both A & B
D. None of the above.
Q.13. Which keyword is used instead of the assignment operator to initialize variables?
A. NOT NULL
B. DEFAULT
C. %TYPE
D. %ROWTYPE
Q.14. What is the advantage of using the %ROWTYPE datatype?
A. It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separately.
B. It can be used even if data type of the table columns is not known.
C. It ensures that data type of the variable changes dynamically if the underlying table is altered.
D. All of the above
Q.15. The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored-------
A. Along with the row
B. Outside the row
C. Both A & B D. None of the above