Databases - Upwork

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
Question: Which of the following clauses are not allowed in a single row sub-query?
A
From

B
Where

C
Group by

D
Having

E
Order by

Note: Not available
1. Report
Question: What is the function of "DBCC CHECKDB" command?
A
It checks the allocation of all the objects in the specified database

B
It checks the structural integrity of all the objects in the specified database

C
It checks for consistency in and between system tables in the specified database

D
It checks the consistency of disk space allocation structures of a specified database

Note: Not available
1. Report

First Prev 58 59 60 61 62 Next Last

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:

Question: Which of the following clauses are not allowed in a single row sub-query?

Question: What is the function of "DBCC CHECKDB" command?