ORACLE10gDBA1z0-043认证考题及答案4
6.You set SGA parameters in your database as: DB_CACHE_SIZE =24 MB JAVA_POOL_SIZE =48 MB SHARED_POOL_SIZE =96 MB You plan to upgrade to Oracle Database 10 g . You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?A: change JAVA_POOL_SIZE to 68 MB
B: change DB_CACHE_SIZE to 44 MB
C: change SHARED_POOL_SIZE to 116 MB
D: change JAVA_POOL_SIZE to 58 MB and DB_CACHE_SIZE to 34 MB
E: change SHARED_POOL_SIZE to 106 MB and DB_CACHE_SIZE to 34 MB
Correct Answers: C
7.Examine the following commands of Data Pump to import objects to new non-existent users hr1 and oe1 .
http://www.examw.com/oracle/Files/2012-6/27/124624274.jpg
7.Which objective would be achieved by the above command sets?
A: expdp will fail because no path has been defined for the dumpfile.
B: expdp will succeed but Impdp will fail because users do not exist.
C: impdp would create two schemas called hr1 and oe1 and copy the schema objects to the new users.
D: impdp would create two schemas called hr1 and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.
Correct Answers: B
8.Identify four uses of the Oracle Scheduler. (Choose four.)
A:Enables you to set idle time limits for a resource plan.
B:Enables you to schedule job execution based on time.
C:Enables you to execute jobs in a clustered environment.
D:Enables you to assign priorities to the consumer groups.
E:Enables you to map a consumer group to an Oracle user.
F:Enables you to create a job that makes use of saved programs and schedules.
G:Enables you to periodically execute operating system script files located on the same server as the database.
Correct Answers: B, C, F, G
9.You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
A:Your database includes a large number of BFILEs.
B:You are making image copies, and you have not enabled tablespace compression.
C:You are backing up to tape and your tape device performs its own compression.
D:You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
E:You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
F:You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
Correct Answers: D, E, F
10.You want to convert your existing non-ASM files to ASM files for the database PROD . Which method or command would you use to accomplish this task?
A: the CONVERT command of RMAN
B: Data Pump Export and Import
C: conventional export and import
D: the BACKUP .. RESTORE .. command of RMAN
E: the BACKUP AS COPY DATABASE .. command of RMAN
Correct Answers: E
页:
[1]