多选题View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.
多选题
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）
A
The tablespace has two data files.
B
An error is reported and tablespace creation fails.
C
Data files are created with names generated by the instance.
D
The tablespace can be extended without specifying the data file.
E
Data files belonging to the USERS tablespace cannot be renamed.
参考解析
解析：
暂无解析
相关考题：
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?() A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUsC. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaD. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?() A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
Which setting enables the baselines by default in Oracle Database 11g?() A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?() A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
Which setting enables the baselines by default in Oracle Database 11g?（）A、setting the STATISTICS_LEVEL parameter to TYPICALB、adding filters to the Automatic Database Diagnostic Monitor (ADDM)C、enabling Automated Maintenance Task using Oracle Enterprise ManagerD、setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（） A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start， and the undo segment will contain the undo data for at least one hour.D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
Which statement regarding the contents of the V$PARAMETER view is true？（）A、displays only the list of default valuesB、displays only the list of all basic parametersC、displays the currently in effect parameter valuesD、displays only the list of all advanced parametersE、displays the list of all the parameter files of a database
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A、The value for MINEXTENTS setting B、The value for PCTINCREASE setting C、The value for MAXEXTENTS setting D、By default, Oracle allocates six extents to all database objects
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）A、Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB、Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUsC、Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery areaD、Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）ASet MEMORY_TARGET to zeroBSet the STATISTICS_LEVEL parameter to BASICCSet the WORKAREA_SIZE_POLICY parameter to MANUALDSet the PGA_AGGREGATE_TARGET parameter to nonzero value
单选题Which statement regarding the contents of the V$PARAMETER view is true？（）Adisplays only the list of default valuesBdisplays only the list of all basic parametersCdisplays the currently in effect parameter valuesDdisplays only the list of all advanced parametersEdisplays the list of all the parameter files of a database
单选题What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）AMTTR Advisor would be disabled.BRedo Log Advisor would be disabled.CAutomatic tuning of checkpoint would be disabled.DCheckpoint information would not be written to the alert log file.
单选题Which setting enables the baselines by default in Oracle Database 11g?（）Asetting the STATISTICS_LEVEL parameter to TYPICALBadding filters to the Automatic Database Diagnostic Monitor (ADDM)Cenabling Automated Maintenance Task using Oracle Enterprise ManagerDsetting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
多选题You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）AEven with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.BA resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition）CWhen a resumable statement is suspended, the transaction that contains the statement is also suspended.DA resumable statement can only be suspended and resumed once during the execution of the statement.EYou can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）Aby setting the SQL_TRACE parameter to FALSE in the parameter fileBby using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionCby setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionDby setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value
单选题You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）A The database will not start.B The database will start but will not retain the undo data in the undo segment.C The database will start， and the undo segment will contain the undo data for at least one hour.D The database will start， and the undo segment will retain the undo data for at least 15 minutes.
单选题Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）AData blocks have to be written more frequently by DBWR. BRedo blocks have to be written more frequently by LGWR. CYou need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. DYou need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A setting the STATISTICS_LEVEL parameter to TYPICALB adding filters to the Automatic Database Diagnostic Monitor （ADDM）C enabling Automated Maintenance Task using Oracle Enterprise ManagerD setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）A Oracle Enterprise ManagerB The V$LOG viewC The V$LOGFILE viewD The V$FLASHBACK_DATABASE_LOGS view
多选题View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）AThe tablespace has two data files.BAn error is reported and tablespace creation fails.CData files are created with names generated by the instance.DThe tablespace can be extended without specifying the data file.EData files belonging to the USERS tablespace cannot be renamed.
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A Query the V$FLASHBACK_DATABASE_LOG view.B Query the V$FLASHBACK_DATABASE_STAT view.C Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D Query the V$RECOVERY_FILE_DEST view.