网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）
A
It will be created on the local file system.
B
It will be created only in the Flash Recovery Area.
C
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
D
It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
参考答案
参考解析
解析：
暂无解析
更多 “单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）A It will be created on the local file system.B It will be created only in the Flash Recovery Area.C It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.D It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.” 相关考题
考题
多选题Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）AYou can add SQL test cases to the incident package.BYou can add or remove the trace files to the package.CYou cannot create an incremental incident package when the physical files are purged from the ADR.DYou can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.
考题
单选题The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）A
Inactive and current redo log files are required to accomplish recovery.B
Online and archived redo log files are required to accomplish instance recovery.C
All redo log entries after the last checkpoint are applied from redo log files to data files.D
All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
考题
单选题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）A
Insert finding directives for ADDM tasks in the future.B
Create a baseline on a pair of snapshots spanning the peak-load period.C
Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.D
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
考题
单选题View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB. Which configuration couldhave enabled the block selection of 16 KB（）A
Choosing the extent allocation type to uniformB
Choosing the Segment Space Management option to manualC
Setting autoextension on for the data file mentioned for the tablespaceD
Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
考题
单选题User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A
It fails to delete the records because the records are locked in SHARE mode.B
It deletes the rows successfully because the table is locked in SHARE modeC
It fails to delete the records because the table is locked in EXCLUSIVE mode.D
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A
The database user OPS$SKD will be able to administer the database.B
The authentication detail for the database user OPS$SKD is recorded in the password file.C
The local operating system user SKD will be able to access the database instance without specifying theusername and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A
The backup will consist of used data blocks only.B
The database must be shut down to accomplish the backup.C
The backup can be accomplished without shutting down the database.D
The backup will contain all database files that have never been backed up.
考题
单选题In a new installation of Oracle Database 11g， you perform these activities： 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed（）A
Oracle Managed FilesB
Oracle Grid ArchitectureC
Optimal Flexible ArchitectureD
Oracle database architectureE
Automatic Storage Management
考题
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A
7， 1， 5， 2， 3， 6， 4B
1， 2， 3，7， 5， 6， 4C
7， 1， 4， 5， 2， 3， 6D
1， 7， 5， 4， 2， 3， 6
热门标签
最新试卷
