ITPub博客

516.In a Database Replay workload capture, what client request information is gathered? (Choose all thatapply.)A. SQL textB. Shared server requests (Oracle MTS)C. Bind variable valuesD. Information about transactionsE. Remote DESCRIBE and COMMIT operationsAnswer: ACDhttp://docs.oracle.com/c...

617.A database instance is using an Automatic Storage Management (ASM) instance, which has a diskgroup, DGROUP1, created as follows:SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK'/devices/diskb1', '/device...

432.For which of the following can you use Segment Shrink? (Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partitions and subpartitionsE. None of the aboveAnswer: ACD带有函数索引的表不能收缩段参考：https://docs.oracle.com/cd/B28359_01/server.111/b283...

365.Which of the following restrictions are not true with respect to tablespace point-in-time recovery?(Choose all that apply.)A. The target database must be in NOARCHIVELOG mode.B. No backup is required of the database before you perform a TSPITR.C. You must have all archived redo logs generate...

193.What is the purpose of the recover command? (Choose all that apply.)A. Recover database datafiles from physical disk backup sets.B. Recover required incremental backups from physical disk backup sets.C. Recover required archived redo logs from physical disk backup sets.D. Apply incremental b...

425.Which of the following are included in a transportable tablespace set? (Choose all that apply.)A. The datafiles that make up a self-contained group of tablespaces required for copyB. The system tablespaceC. An export of the tablespace metadataD. The spfileE. All of the aboveAnswer: AC...

582.You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289:suggestion:/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17/o1_mf_1_11_%u_.arcORA-00280: chan...

311.Given the scriptcreate script db_backup_datafile_script{backup datafile and 1, and2 plus archivelog delete input;}What is the result of running this command?Run {execute script db_backup_datafile_script using 2;}A. The script will fail since you instructed RMAN to back up only one datafile ...

411.Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to restart one instance to begin workload capture.C. Specifically in RAC, you shut down all instances, restart them individually, and begin work...

216.Which three elements can a job chain process involve? (Choose three)A. an eventB. a scheduleC. a programD. another chainE. a lightweight jobAnswer: BDE正确答案应为ACD?官方参考：http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12458Defining Chain StepsAf...

710. You executed the following commands in a database session:Which statement is true about the contents of the recycle bin in this situation?A.They remain unaffected.B.They are moved to flashback logs.C.They are moved to the undo tablespace.D.They are moved to a temporary tablespace.E.The ob...

36.Which two statements are true regarding the functionality of the remap command in ASMCMD?(Choose two.)A. It repairs blocks that have read disk I/O errors.B. It checks whether the alias metadata directory and the file directory are linked correctly.C. It repairs blocks by always reading them f...

594.Which of the following most closely represents an image copy?A. Unix cp command of a fileB. Bit-by-bit copy of a fileC. Windows COPY command of a fileD. All of the aboveAnswer: D

257.Which client requests to the database can be captured as a part of the workload capture? (Choose allthat apply.)A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external filesA...

695. Identify two options that Oracle recommends while configuring the backup and recovery environmentfor your recovery catalog. (Choose two.)A. configuring control file autobackup to be ONB. backing up data filed only and not the archived redo log filesC. running the recovery catalog database i...

312.Which is the correct way to connect to both the target database and the recovery catalog from theRMAN command line? Assume that the target database is called ORCL and that the recovery catalogdatabase is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assumethe en...

692. Your company wants to upgrade the production database to a Real Application Clusters (RAC)environment. You set up the best RAC database and want to replay a recorded workload captured fromthe production database on the test machine.The following steps may be used to replay the database workl...

239.Evaluate the following command:SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';What is the impact of this setting on the usage of SecureFiles?A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.B. It forces SecureFiles to be created even if the BA...

241.You issued the following RMAN command to back up the database:RMAN> RUN{ALLOCATE CHANNEL c1 DEVICE TYPE sbtBACKUP DATABASETAG quarterlyKEEP FOREVERRESTORE POINT FY06Q4;}Which two statements are true regarding the backup performed? (Choose two.)A. Archived redo log files are backed up alo...

476.What is the name of the file that identifies the set of available locale definitions?A. locale.defB. lxdef.oraC. lx1boot.nlbD. lx1boot.oraE. lang.defAnswer: C