Oracle DBA multiple choice answers at the end

Feb 3rd, 2012
Studypool Tutor
Price: $100 USD

Tutor description

Oracle DBA multiple choice answers at the end 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?

Word Count: 1792
Showing Page: 1/5
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 BobB. Only Sharon C. Both Bob and SharonD. No one else will lose their privileges2. Which of the following is not a SQL*Loader file? A. Bad fileB. Control fileC. Discard fileD. Good fileE. Log file3. Which SQL*Loader load keyword deletes data in table before loading? A. APPENDB. DELETEC. SUBSTITUTED. REPLACE4. 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 conventionalB. Parallel direct C. Serial conventional D. Serial direct5. 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=MEMORYB. 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:/ora

Review from student

Studypool Student
" Excellent job "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors