What Is Oracle?
Oracle
- 1.
Which of the following is not a schema object ?
- A.
Indexes
- B.
Public synonyms
- C.
Tables,
- D.
Triggers
Correct Answer
B. Public synonyms -
- 2.
Functions can be overloaded true/false
- A.
A. TRUE
- B.
B. FALSE
Correct Answer
A. A. TRUE -
- 3.
What are the various types of parameter modes in a procedure ? CHOOSE 3
- A.
In
- B.
Outin
- C.
Out
- D.
Inout
Correct Answer(s)
A. In
C. Out
D. Inout -
- 4.
You can have two functions with the same name in a PL/SQL block
- A.
True
- B.
False
Correct Answer
A. True -
- 5.
You can call a stored function in the constraint of a table
- A.
True
- B.
False
Correct Answer
B. False -
- 6.
What are the various types of Exceptions ? choose 2
- A.
User defined exception
- B.
Pre defined exception
- C.
Try
- D.
Catch
Correct Answer(s)
A. User defined exception
B. Pre defined exception -
- 7.
What are the parts of a database trigger ? choose 3
- A.
A. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger a. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger A triggering event or statement
- B.
Open trigger
- C.
A trigger restriction
- D.
A trigger action
- E.
Close trigger
Correct Answer(s)
A. A. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger a. A triggering event or statement b. Open trigger c. A trigger restriction d. A trigger action e. Close trigger A triggering event or statement
C. A trigger restriction
D. A trigger action -
- 8.
How many types of database triggers are possible ?
- A.
12
- B.
11
- C.
13
Correct Answer
A. 12 -
- 9.
What is the maximum no.of statements that can be specified in a trigger statement ?
- A.
One
- B.
Two
- C.
Three
- D.
Four
Correct Answer
A. One -
- 10.
Views can be specified in a trigger statement
- A.
True
- B.
False
Correct Answer
B. False -
- 11.
Can you increase the size of a tablespace ? How ?
- A.
Yes, by adding datafiles to it.
- B.
No, It is impossible
- C.
Yes, by using alter command
- D.
Yes, by using update command
Correct Answer
A. Yes, by adding datafiles to it. -
- 12.
Benefits of Subprograms: choose 4
- A.
Easy maintenance
- B.
Improved data security and integrity
- C.
Improved performance
- D.
Improved code clarity
- E.
Improved speed
- F.
Improves efficiency
Correct Answer(s)
A. Easy maintenance
B. Improved data security and integrity
C. Improved performance
D. Improved code clarity -
- 13.
Types of Triggers : choose all that apply
- A.
A. Row level
- B.
B. Statement level
- C.
C. Column level
Correct Answer(s)
A. A. Row level
B. B. Statement level -
- 14.
A Trigger will fire the trigger before the INSERT operation is executed
- A.
Before insert
- B.
Insert before
- C.
After Insert
- D.
Before update
Correct Answer
A. Before insert -
- 15.
are stored procedures that gets implicitly executed when some database-related event occurs .
- A.
A. Procedures
- B.
B. Triggers
- C.
C. Functions
- D.
D. Cursor
Correct Answer
B. B. Triggers -
- 16.
The four PL/SQL steps necessary for explicit cursor processing are as follows: choose 4
- A.
Declare the cursor
- B.
Open the cursor
- C.
Fetch the results into PL/SQL variables
- D.
Close the cursor
- E.
Execute the cursor
- F.
Delete the cursor
Correct Answer(s)
A. Declare the cursor
B. Open the cursor
C. Fetch the results into PL/SQL variables
D. Close the cursor -
- 17.
The statement prepares (parses) and immediately executes a dynamic SQL statement or an anonymous PL/SQL block.
- A.
Immediate execute
- B.
Execute immediate
- C.
Execute
- D.
Execute later
Correct Answer
B. Execute immediate -
- 18.
. enables to write programs that reference SQL statement whose full text is not known until runtime.
- A.
Static SQL
- B.
Dynamic SQL
- C.
PL/SQL
- D.
Oracle 10g
Correct Answer
B. Dynamic SQL -
- 19.
Some utilities in Oracle are: choose 3
- A.
Export
- B.
Execute
- C.
Import
- D.
Sql loader
- E.
DDL commands
Correct Answer(s)
A. Export
C. Import
D. Sql loader -
- 20.
Which of the following cursor attributes allows you to check whether the cursor is open or not
- A.
%isopen
- B.
%open
- C.
%isclose
- D.
Isopen
Correct Answer
A. %isopen -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Dec 08, 2017Quiz Edited by
ProProfs Editorial Team -
Nov 21, 2011Quiz Created by
Kiruthika_L
Back to top