What Is Oracle?
Settings
Oracle
- 1.Which of the following is not a schema object ?
- A.
Indexes
- B.
Public synonyms
- C.
Tables,
- D.
Triggers
- 2.Functions can be overloaded true/false
- A.
A. TRUE
- B.
B. FALSE
- 3.What are the various types of parameter modes in a procedure ? CHOOSE 3
- A.
In
- B.
Outin
- C.
Out
- D.
Inout
- 4.You can have two functions with the same name in a PL/SQL block
- A.
True
- B.
False
- 5.You can call a stored function in the constraint of a table
- A.
True
- B.
False
- 6.What are the various types of Exceptions ? choose 2
- A.
User defined exception
- B.
Pre defined exception
- C.
Try
- D.
Catch
- 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
- 8.How many types of database triggers are possible ?
- A.
12
- B.
11
- C.
13
- 9.What is the maximum no.of statements that can be specified in a trigger statement ?
- A.
One
- B.
Two
- C.
Three
- D.
Four
- 10.Views can be specified in a trigger statement
- A.
True
- 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
- 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
- 13.Types of Triggers : choose all that apply
- A.
A. Row level
- B.
B. Statement level
- C.
C. Column 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
- 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
- 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
- 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
- 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
- 19.Some utilities in Oracle are: choose 3
- A.
Export
- B.
Execute
- C.
Import
- D.
Sql loader
- E.
DDL commands
- 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
Back to top