单项选择题Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3 (usder_temp) /user_files/user_tbsp’ SIZE 200M; What would be the result of this command?()

A. It would result in an error because the template cannot be used along with the disk group.
B. It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C. It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.
D. It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题A media failure has occurred. This has resulted in all the members of the next hop 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 re-created the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries, no other statements are allowed.
D. The database returns and error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.

3.多项选择题Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()

A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.

4.单项选择题Which statement is true while creating subplans using Resource Manager?()

A. The subplan must belong to the consumer group, SYS_GROUP.
B. The total CPU usage at any given level must be less than 100%.
C. The subplans can be used to restrict the degree of parallelism for a user.
D. You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

5.多项选择题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()

A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C. This operation moves all the redo log files to a different location.
D. This operation deletes the old redo log files and creates new redo log files.
E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

6.多项选择题For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()

A. RMAN image copies.
B. RMAN database backups.
C. RMAN tablespace backups.
D. User-managed backups placed in the flash recovery area.
E. User-managed backups that have been cataloged with RMAN.
F. User-managed data file backups for which the pull path name is specified.

8.多项选择题While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to resolve this error?()

A. GRANT dba TO dbmgr;
B. GRANT connect TO dbmgr;
C. GRANT resource TO dbmgr;
D. GRANT hs_admin_role TO dmbgr;
E. GRANT manage scheduler TO dbmgr;

9.多项选择题What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()

A. BMR lowers the mean time to recover (MTTR).
B. BMR supports point-in-time recovery of individual data blocks.
C. BMR enables you to use incremental backups for block recovery.
D. BMR enables recovery even when the database is not mounted or open.
E. BMR enables you to use proxy backups to perform block media recovery.
F. BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.

10.单项选择题Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()

A. A window must have been created with the WEEKEND_PLAN resource plan.
B. A program must have been created with the WEEKEND_PLAN resource plan.
C. A job class must have been created with the WEEKEND_PLAN resource plan.
D. A windows group must have been created with the WEEKEND_PLAN resource plan.

最新试题

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re­create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re­create the indexes?()

题型:多项选择题

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process? ()

题型:多项选择题

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()

题型:多项选择题

You have a read­only tablespace on read­only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read­only tablespace was read/write when the control file was backed up. What should you consider?()

题型:单项选择题

You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()

题型:多项选择题

You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()

题型:单项选择题

Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database using the RESETLOGS option. Back up the database. Case 2: Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3:Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()

题型:单项选择题

You lost the PRODSTD tablespace, which was read/write. The tablespace was read­only when the last backup was performed. How would you recover the tablespace?()

题型:单项选择题

Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived, and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery: RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario, which statement is true?()

题型:单项选择题

You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’2004­08­05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()

题型:单项选择题