Which of the following about a SELECT INTO statement is FALSE?
Which of the following about a SELECT INTO statement is FALSE?
What is the initial value for a record variable declared with RECORD Type?
What is the initial value for a record variable declared with RECORD Type?
Which of the following are correct results of a Boolean expression?
Which of the following are correct results of a Boolean expression?
What is a %ROWTYPE attribute used for?
What is a %ROWTYPE attribute used for?
What are the conditions when a record variable is assigned to another record variable, the target variable is declared with a RECORD type and the source variable is declared with %ROWTYPE?
What are the conditions when a record variable is assigned to another record variable, the target variable is declared with a RECORD type and the source variable is declared with %ROWTYPE?
Which of the following operators has the highest precedence?
Which of the following operators has the highest precedence?
How is comparison made in Boolean character expression?
How is comparison made in Boolean character expression?
Which of the following clause is not mandatory while using a SQL SELECT statement?
Which of the following clause is not mandatory while using a SQL SELECT statement?
How can a user defined record be created in PL/SQL?
How can a user defined record be created in PL/SQL?
Which one of these operators does not have the same precedence as the others?
Which one of these operators does not have the same precedence as the others?
What is scope and visibility of an identifier?
What is scope and visibility of an identifier?
What are the two types of case expressions?
What are the two types of case expressions?
Which of the following is not TRUE about using records for database inserts or updates?
Which of the following is not TRUE about using records for database inserts or updates?
Which of the following correctly describes the use of a %TYPE attribute?
Which of the following correctly describes the use of a %TYPE attribute?
Which of the following about %ROWTYPE attribute is not true?
Which of the following about %ROWTYPE attribute is not true?
Where can a % be used in LIKE conditions in PL/SQL?
Where can a % be used in LIKE conditions in PL/SQL?
How should any declaration statement end in PL/SQL?
How should any declaration statement end in PL/SQL?
Using which of the following clauses is the MERGE condition specified?
Using which of the following clauses is the MERGE condition specified?
Which of the DML statements can be used inside a PL/SQL block?
Which of the DML statements can be used inside a PL/SQL block?
While using SELECT INTO statements where are the database columns specified?
While using SELECT INTO statements where are the database columns specified?