PL/SQL Questions Exam Quiz!
(453).jpg "PL/SQL Questions Exam Quiz! - Quiz")
Multiple choice questions. . .
- 1.How many tables may be included with a join?
- A.
One
- B.
Two
- C.
Three
- D.
All the above
- 2.Which of the following SQL functions can operate on any data type?
- A.
TO_CHAR
- B.
LOWER
- C.
LPAD
- D.
CEIL
- 3.Assuming today is Monday, 21 NOV 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
- A.
03-NOV-00
- B.
10-NOV-00
- C.
28-NOV-00
- D.
17-NOV-00
- 4.In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
- A.
NULL
- B.
0
- C.
Results in a compilation error
- D.
An exception will be raised
- 5.What is the result if two NULL values are compared to each other?
- A.
True
- B.
False
- C.
Undefined
- D.
Null
- 6.PL/SQL raises an exception, in which TWO of the following cases:
- A.
When a SELECT statement returns no rows
- B.
When a SELECT statement returns more than one row
- C.
When the datatypes of SELECT clause and INTO clause do not match
- 7.Functions for error trapping are contained in which section of a PL/SQL block?
- A.
Header
- B.
Declarative
- C.
Executable
- D.
Exception
- 8.The SQL WHERE clause
- A.
Limits the column data that are returned
- B.
Limits the row data are returned
- C.
Both A and B are correct.
- D.
Neither a or b is correct
- 9.Which of the following is true concerning triggers?
- A.
You do not create them with SQL
- B.
They execute against only some applications that access a database
- C.
They have an event, condition, and action
- D.
They cannot cascade (cause another trigger to fire).
- 10.In this PL/SQL statement, which of the following lines will produce an error?
- A.
Cursor CAPITALS is
- B.
Select CITY, STATE
- C.
Into my_city, my_state
- D.
From CITIES
- E.
Where CAPITAL = 'Y'
- F.
There are no errors in these statements
Questions: 35 | Attempts: 15764 | Last updated: Mar 22, 2022
-
Sample QuestionWhich of the following statements contains an error?
Questions: 42 | Attempts: 4270 | Last updated: Mar 22, 2022
-
Sample QuestionExamine this function: CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which statement will successfully invoke this function in SQL *Plus?
Questions: 5 | Attempts: 3234 | Last updated: Mar 22, 2022
-
Sample QuestionA record is a collection of individual fields that represents a row in the table.
Back to top