Very soon you will&#...

单项选择题X 纠错

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

A. use DBMS_IJOB package
B. use Oracle Scheduler
C. use DBMS_JOB package
D. use Oracle Data Pump Export and Import

参考答案：

进入题库练习

单项选择题

A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

A. The database allows only queries； no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.

点击查看答案进入题库练习

单项选择题

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

A. the RMAN LIST command
B. the DBNEWID utility
C. the RMAN REPORT command
D. the RMAN BLOCKRECOVER command
E. the RMAN CROSSCHECK command
F. the ANALYZE command

点击查看答案进入题库练习

单项选择题

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table

点击查看答案进入题库练习

单项选择题

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：
1.RESTORE CONTROLFILE；
2.RESTORE DATABASE；
3.ALTER DATABASE MOUNT；
4.SQL ALTER TABLESPACE temp ADD TEMPFILE
5.ALTER DATABASE OPEN RESETLOGS；
6.RECOVER DATABASE；
7.STARTUP NOMOUNT；
In what sequence would you use this process to perform the recovery？（）

A. 2， 7， 3， 5， 1， 6， 4
B. 2， 1， 7， 6， 3， 5， 4
C. 7， 1， 3， 2， 6， 5， 4
D. 7， 2， 3， 1， 4， 6， 5

点击查看答案进入题库练习

单项选择题

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

A. The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
B. Before the instance starts， you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

点击查看答案进入题库练习

单项选择题

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening

点击查看答案进入题库练习

单项选择题

You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）

A. streams pool
B. shared pool
C. log buffer
D. keep buffer cache
E. recycle buffer cache

点击查看答案进入题库练习

单项选择题

You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature.How would you instruct RMAN to use the block change tracking feature when performing incremental backups？（）

A. You need to mention it with every BACKUP command.
B. The block change tracking feature is used automatically by RMAN.
C. You need to configure it using the CONFIGURE command.
D. You need to set the necessary initialization parameters to direct RMAN to use the feature.

点击查看答案进入题库练习

多项选择题

You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？（）

A. The member jobs would get dropped when the job class is dropped.
B. Both the jobs would be executed concurrently.
C. The member jobs would get disabled when the job class is dropped.
D. The attributes defined at the class level would be applied to both the jobs.
E. Jobs in the job class must have been assigned the same priority.

点击查看答案进入题库练习

单项选择题

The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）

A. DB_4K_CACHE_SIZE only
B. DB_8K_CACHE_SIZE only
C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E. SGA_TARGET and DB_4K_CACHE_SIZE
F. DB_CACHE_SIZE only

点击查看答案进入题库练习