1. Lisa granted the CREATE TABLE privilege WITH ADMIN OPTION to Sharon. Sharon g

Question

1. Lisa granted the CREATE TABLE privilege WITH ADMIN OPTION to Sharon. Sharon granted the privilege to Bob.   If Lisa’s privileges are revoked, who else will lose their privileges?

A. Only Bob

B. Only Sharon

C. Both Bob and Sharon

D. No one else will lose their privileges

2. Which of the following is not a SQL*Loader file?

A. Bad file

B. Control file

C. Discard file

D. Good file

E. Log file

3. Which SQL*Loader load keyword deletes data in table before loading?

A. APPEND

B. DELETE

C. SUBSTITUTE

D. REPLACE

4. You need to insert a large amount of data through the HR_EMP_HIST table. You are concerned about the amount of time the data load may take. Although you will only be using one processor to load the data, you would like to make the load as quick as possible. You are NOT concerned about the available storage space or data integrity. Which SQL*Loader data loading method should you use?

A. Parallel conventional

B. Parallel direct

C. Serial conventional  

D. Serial direct

5. Which of the following commands is a key step in multiplexing control files using an SPFILE?

A. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,

     ‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=MEMORY

B. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,

     ‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=BOTH

C. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,

     ‘D:/oracle/oradata/INST1/control02.ctl’

D. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,

     ‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=SPFILE

Explanation / Answer

Solution:-

----------------------------------------------------------------------------------------------------------------------------------------------------------

Answer 1

The correct answer is option (B) Only Sharon.

Explanation - The priviledge is given by admin option so if Lisa's previledge is revoked with revoke admin option then it only revokes a previously granted admin option from the grantee. Sheron is a grantee of lisa so sheron's previledge is also revoked. Bo is grantee of sheron not lisa.

----------------------------------------------------------------------------------------------------------------------------------------------------------

Answer 2

The correct answer is option (D) Good file.

Explanation - The good file is not a SQL*Loader file parameter. The Bad file, Control file, Discard file and Log file are used as SQL*Loader file parameters.

----------------------------------------------------------------------------------------------------------------------------------------------------------

Answer 3

The correct answer is option (D) Replace.

Explanation - The Replace SQL*Loader load keyword used to load the database with new data after deleting the old data from the tables. It actually replaces the data of the tables in loading.

----------------------------------------------------------------------------------------------------------------------------------------------------------

Answer 4

The correct answer is option (B) Parallel direct.

Explanation - parallel direct path load should be used when load time is concerned. It provides greater performance improvement by permitting multiple loader sessions to run simultaneously to load a single table. Generally it ignores the overhead information contained in tables.

----------------------------------------------------------------------------------------------------------------------------------------------------------

Answer 5

The correct answer is option (D) ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’, ‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=SPFILE

Explanation - The multiplexing of multiple control files using an SPFILE can be done with the option (D). Here when we use SPFILE multiplexing then scope should be set to SPFILE. So option (D) is the corect answer where SCOPE=SPFILE.

----------------------------------------------------------------------------------------------------------------------------------------------------------

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.