Fundamentals of the PL/SQL Language - questions and answers

Fundamentals of the PL/SQL Language - questions and answers

1) PL/SQL keywords are not case-sensitive.

A) True
B) False
View Answer / Hide Answer


2) Which is a simple or compound symbol that has a special meaning to PL/SQL?

A) Delimiters
B) Identifiers
C) Literals
D) Comments
View Answer / Hide Answer


3) From the following PL/SQL Delimiters which symbol is exponentiation operator.

A) <>
B) ~=
C) **
D) --
View Answer / Hide Answer


4) Which of the following is an explicit numeric, character, string, or BOOLEAN value not represented by an identifier?

A) Delimiters
B) Literals
C) Comments
D) None of the above
View Answer / Hide Answer


5) How many types of literals are available in PL/SQL?

A) 6
B) 2
C) 5
D) 4
View Answer / Hide Answer


6) Which keyword is used instead of the assignment operator to initialize variables?

A) NOT NULL
B) DEFAULT
C) %TYPE
D) %ROWTYPE
View Answer / Hide Answer


7) PL/SQL Expressions are constructed using.

A) Operands
B) Operators
C) Both A & B
D) None of the above
View Answer / Hide Answer


8) Which operator tests set membership?

A) IN Operator
B) BETWEEN Operator
C) LIKE Operator
D) IS NULL Operator
View Answer / Hide Answer


9) In CASE Expressions, which expression selects a result from one or more alternatives, and returns the result?

A) Simple CASE Expression
B) Searched CASE Expression
C) Both A & B
D) None of the above
View Answer / Hide Answer


10) PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?

A) Error reporting,Character,Datatype conversion
B) Number,Date,Object reference
C) Miscellaneous
D) All mentioned above
View Answer / Hide Answer


11) PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content.

A) True
B) False
View Answer / Hide Answer


12) Using DBMS_DB_VERSION Package Constants which represents the condition that the database version is less than or equal to 10; it is TRUE.

A) VER_LE_10
B) VER_LE_10_2
C) Both A & B
D) None of the above
View Answer / Hide Answer


13) A searched CASE expression lets you test different conditions instead of comparing a single expression to various values.

A) Yes
B) No
View Answer / Hide Answer


14) Like all identifiers, the names of constants, variables, and parameters are case sensitive.

A) True
B) False
View Answer / Hide Answer


15) PL/SQL programs are written as lines of text using a specific set of characters.

A) Upper- and lower-case letters A .. Z and a .. z
B) Numerals 0 .. 9
C) Symbols ( ) + - * / < > = ! ~ ^ ; : . ' @ % , " # $ & _ | { } ? [ ]
D) Tabs, spaces, and carriage returns
E) All mentioned above
F) None of the above
View Answer / Hide Answer