Mock Oracle Test -DBMS SQL,PL/SQL
5 Questions
| Total Attempts: 3234
DBMS SQL,PL/SQL
Questions and Answers
- 1.A record is a collection of individual fields that represents a row in the table.
- A.
True
- B.
False
- 2.What is the correct order for steps of initialing the cursor? a.FETCH b.OPEN C.Declare d.close
- A.
A,c,d,b,
- B.
C,b,a,d
- C.
B,d,a,c,
- D.
C,a,d,b,
- 3.User-defined SUBTYPES are subtypes based on an existing type.
- A.
True
- B.
False
- 4.%ROWTYPE is used to declare a variable with the same datatype as a column of a specific table
- A.
True
- B.
False
- 5.While using FOR loop,Upper_Bound and Lower_Bound must be integers.
- A.
True
- B.
False
Oracle SQL and PL/SQL Practice Quiz For Developers. It consists of 30 basic to advanced programming questions to assist you in your practicing session. All the best as you go down to tackle these questions.
Questions: 35 | Attempts: 15765 | Last updated: Mar 22, 2022
-
Sample QuestionWhich of the following statements contains an error?
This is a sample PL/SQL test
Questions: 42 | Attempts: 4271 | 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?
Multiple choice questions...
Questions: 10 | Attempts: 4229 | Last updated: Apr 20, 2022
-
Sample QuestionHow many tables may be included with a join?
Back to top