CSC454 Oracle11g HW

Preview (3 of 7 Pages)

100%

CSC454 Oracle11g HW - Page 1 preview image

Loading page ...

1CSC454Oracle11gHWName:_______________________30 points1.Lisa granted the CREATE TABLE privilege WITH ADMIN OPTION to Sharon. Sharon granted theprivilege to Bob.If Lisa’s privileges are revoked, who else will lose their privileges?A. Only BobB. Only SharonC. Both Bob and SharonD. No one else will lose their privilegesAnswer:-C. both bob and sharon2.Which of the following is not a SQL*Loader file?A. Bad fileB. ControlfileC. Discard fileD. Good fileE. LogfileAnswer:-D. Good file3.Which SQL*Loader load keyword deletes data in table before loading?A. APPENDB. DELETEC. SUBSTITUTED. REPLACEAnswer:-D. Replace4.You need to insert a large amount of data through the HR_EMP_HIST table. You are concerned aboutthe 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 storagespace or data integrity. Which SQL*Loader data loading method should you use?A. Parallel conventionalB. Parallel directC. Serial conventionalD. Serial directAnswer:-C. serial conventional5.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=BOTHC. 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=SPFILEAnswer:-B. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=BOTH6.If you have two redo log groups with four members each, what’s the optimal number of disks you need to provideappropriate protection on the redo log files?A. EightB. FourC. TwoD. OneE. Operating system dependentAnswer:-E. Operating system dependent7.When is the redo log buffer written to the redo log file?A. A transaction changes data.B. The redo log buffer becomes one-third full.C. A redo log group is archived.D. The database starts up.Answer:-A. A transaction changes data.

CSC454 Oracle11g HW - Page 2 preview image

Loading page ...

CSC454 Oracle11g HW - Page 3 preview image

Loading page ...

28.You have two redo log groups. Each group has three members that are 150 MB in size. The membersreside on the E, F, and G drives. You issue this command:ALTER DATABASE ADD LOGFILE MEMBER ‘G:\app\oradata\INST1\redo04.log’ SIZE 200M TO GROUP1;The statement will fail because:A. All redo log groups must have the same number of members.B. The size cannot be specified in this command.C. You cannot add a member to a redo log group.D. The size is incorrect.Answer:-D. The size is incorrect.9.What is the correct method for moving a control file (assume you use PFILE)?A. Issue the ALTER DATABASE RENAME FILE command.B. Shut down the database; move the control file; modify the CONTROL_FILES parameter in PFILE; andstart up the database using PFILE.C. Copy the control file to a new location; shut down the database; modify the CONTROL_FILESparameter; and start up the database.D. Shut down the database; delete the control file; start up the database in NOMOUNT mode; issue theCREATE CONTROL FILE command; and start up the database.Answer:-B. Shut down the database; move the control file; modify the CONTROL_FILES parameter inPFILE; and start up the database using PFILE.10.Which statement will add a member C:\app\oradata\INST1\redo2A.log to log file group 2?A. ALTER DATABASE ADD LOGFILE ‘C:\app\oradata\INST1\redo2A.log’ TO GROUP 2;B. ALTER DATABASE ADD LOGFILE MEMBER ‘C:\app\oradata\INST1\redo2A.log’ TO GROUP 2;C. ALTER DATABASE ADD MEMBER ‘C:\app\oradata\INST1\redo2A.log’ TO GROUP 2;D. ALTER DATABASE ADD LOGFILE ‘C:\app\oradata\INST1\redo2A.log’;Answer:-D. ALTER DATABASE ADD LOGFILE ‘C:\app\oradata\INST1\redo2A.log’;11.Which statement is false about block size?A. It can be set at the tablespace levelB. It can be set at the database levelC. Settings at the database level take precedence over settings at the tablespace levelD. Settings at the tablespace level take precedence over settings at the database levelAnswer:-D. Settings at the tablespace level take precedence over settings at the database level12.You are using Data Pump to upload rows into a table, and you wish to usethe direct path. Which of thefollowing statements is correct?A. You must include the “DIRECT” keyword in the Data Pump control file.B. You must enable insert triggers on the table first.C. You have no control over this; Data Pump will use the direct pathautomatically if it can.D. Direct path isnot available in Data Pump.Answer :-A. You must include the “DIRECT” keyword in the Data Pump control file.B. You must enable insert triggers on the table first.C. You have no control over this; Data Pump will use the direct pathautomatically if it can.Or you can choose any one of the three statements.13.Which of the following is not a Data Pump file type?A. Dump fileB. LogfileC. ControlfileD. SQL fileAnswer:-C. control file14.You have decided to implement automatic undo management. Which of thesesteps is optional?A. Set the parameter UNDO_MANAGEMENT.B. Create an undo tablespace.C. Set the parameter UNDO_RETENTION.D. Restart the instanceAnswer:-B. Create an undo tablespace15.You want to add a control filecopy. Which of these sequences is correct andsufficient?

Preview Mode

This document has 7 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Notes CCNA

CCNA 200-301 Portable Command Guide 5th Edition 20

CCNA 200-301 Portable Command Guide 5th Edition 22

CCNA 200-301 Portable Command Guide 5th Edition 36

Foundations of Novell Networking Section 26

Modulo 7 DHCPv4

Build and troubleshooting Integration Challenge

Company

Explore

Study Tools