Oracle PL/Sql 10g, Databases

Question: Which two statements among the following, regarding oracle database 10g PL/SQL support for LOB migration, are true?
A
Standard package functions accept LOBs as parameters

B
Standard package function do not accept LOBs as parameters

C
Implicit data conversion is supported for converting LOB to RAW

D
Implicit data conversion is not supported for converting varchar to LOB

Note: Not available
1. Report
Question: Which command is used to disable all triggers on the EMPLOYEES table?
A
Multiple triggers on a table in one command cannot be disabled

B
ALTER TRIGGERS ON TABLE employees DISABLE;

C
ALTER employees DISABLE ALL TRIGGERS;

D
ALTER TABLE employees DISABLE ALL TRIGGERS;

Note: Not available
1. Report
Question: Which table and column can be queried to see all procedures and functions that have been marked invalid?
A
USER_ERRORS table,STATUS column

B
USER_OBJECTS table,STATUS column

C
USER_ERRORS table,INVALID column

D
USER_OBJECTS table,INVALID column

Note: Not available
1. Report
Question: SQL%ISOPEN always evaluates to false in case of a/an:
A
Explicit Cursor

B
Implicit Cursor

C
Paramertized Cursor

D
Cursor with Arguments

Note: Not available
1. Report
Question: Which datatype does the cursor attribute '%ISOPEN' return?
A
BOOLEAN

B
INTEGER

C
NUMBER

D
VARCHAR2

Note: Not available
1. Report
Question: Which of the following is a benefit of using procedures and functions?
A
Procedures and Function increases the number of calls to the database

B
Procedures and Function are reparsed for multiple users by exploiting shared SQL area

C
Procedures and Function avoid reparsing for multiple users by exploiting shared SQL areas

D
Testing of procedures and functions requires the database to be restarted, to clear out shared SQL areas and future access

Note: Not available
1. Report
Question: All packages can be recompiled by using an Oracle utility called:
A
Dbms_Output

B
Dbms_Lob

C
Dbms_utility

D
Dbms_Error

Note: Not available
1. Report
Question: Which type of variable should be used to assign the value TRUE, FALSE?
A
Constant

B
Scalar

C
Reference

D
Composite

Note: Not available
1. Report
Question: In which type of trigger can the OLD and NEW qualifiers can be used?
A
Row level DML trigger

B
Row level system trigger

C
Statement level DML trigger

D
Row level application trigger

Note: Not available
1. Report
Question: All packages can be recompiled by using an Oracle utility called:
A
Dbms_Output

B
Dbms_Lob

C
Dbms_utility

D
Dbms_Error

Note: Not available
1. Report

First Prev 3 4 5 Next Last

Question: Which two statements among the following, regarding oracle database 10g PL/SQL support for LOB migration, are true?

Question: Which command is used to disable all triggers on the EMPLOYEES table?

Question: Which table and column can be queried to see all procedures and functions that have been marked invalid?

Question: SQL%ISOPEN always evaluates to false in case of a/an:

Question: Which datatype does the cursor attribute '%ISOPEN' return?

Question: Which of the following is a benefit of using procedures and functions?

Question: All packages can be recompiled by using an Oracle utility called:

Question: Which type of variable should be used to assign the value TRUE, FALSE?

Question: In which type of trigger can the OLD and NEW qualifiers can be used?

Question: All packages can be recompiled by using an Oracle utility called: