网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）
A
It results in an error because these parameter settings are invalid.
B
One 64G flash cache file will be used.
C
Two 64G flash cache files will be used.
D
Two 32G flash cache files will be used.
参考答案
参考解析
解析：
暂无解析
更多 “单选题To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）A It results in an error because these parameter settings are invalid.B One 64G flash cache file will be used.C Two 64G flash cache files will be used.D Two 32G flash cache files will be used.” 相关考题
考题
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
A. Enable the flash recovery area and specify it as the archived redo log destination.B. Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C.Enable the flash recovery area but do not specify it as the archived redo log destination.D. Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
考题
Which three actions are required to configure the Flashback Database? ()
A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode
考题
You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.How should you configure the database?A．Configure the database on the two servers as a SQL Server 2000 cluster.B．Configure the database on one server, and then configure a standby database on the second server.C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.D．Configure the database as a federated database, and then partition half the data on each server.
考题
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）A、configure the database to run in ARCHIVELOG modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager （RMAN） commands after creating the databaseE、schedule the database backup using Database Configuration Assistant （DBCA） while creating the database
考题
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.
考题
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）A、An upper limit on how far you can flash back the database, depending on the information in the redo logsB、An upper limit on how far you can flash back the database, depending on the information in the undo tablespaceC、The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough spaceD、The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
考题
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）A、Configure the KEEP buffer pool and alter the table with the corresponding storage clause.B、Increase the database buffer cache size.C、Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.D、Configure Automata Shared Memory Management.E、Configure Automatic Memory Management
考题
You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）A、Enable instance failoverB、Configure shared serverC、Enable database failoverD、Enable connect-time failoverE、Enable Transparent Application Failover （TAF）
考题
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
What command would you issue to enable automated backups of control files? （）A、alter database controlfile autobacku onB、alter system controlfile autobackup on C、configure controlfile autobackup on D、enable controlfile autobackup
考题
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）A、Multiplex all database files.B、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter
考题
You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
考题
How can you configure High Availability for interacting with a non-Oracle database using WebLogic?（）A、Configure multiple physical data sources and reuse the same JNDI name for each.B、Use the "compatibility" option of Active GridLink to enable compatibility with non-Oracle databases.C、Configure a single physical data source for each node in a database cluster and wrap it using Multi Data Source.D、Configure a Data Source Group that contains a physical connection pool to each node in the database cluster.
考题
Which three actions are required to configure the Flashback Database？（） A、 set Flash Recovery AreaB、 enable Flashback loggingC、 create FLASHBACK tablespaceD、 start the database in the ARCHIVELOG modeE、 start the database in the NOARCHIVELOG mode
考题
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area （SGA） size to increase memory hits.
考题
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）A、Multiplex all database filesB、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter.
考题
You are the administrator of your company’s network. The dial-up server on your network is configured to support certificate authentication. A user named Tom wants to use smart card authentication on his Windows 2000 Professional portable computer. You that Tom’s computer has a PC Card smart card reader and the appropriate drivers installed. You give Tom a smart card to use. What else should you do to enable smart card authentication on Tom’s computer? （）A、Configure a dial-up connection to use EAP. Select the smart card device for authentication. B、Configure a dial-up connection to use SPAP. Select the smart card device for authentication.C、Configure a dial-up connection to use certificate authentication. Enable the usercredentials for authentication.D、Configure a dial-up connection to connect to a private network through the Internet. Enable L2TP be create a virtual private network （VPN） tunnel.
考题
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）A
Enable the flash recovery area and specify it as the archived redo log destination.B
Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C
Enable the flash recovery area but do not specify it as the archived redo log destination. D
Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
考题
单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?（）A
It results in an error because these parameter settings are invalid.B
One 64G flash cache file will be used.C
Two 64G flash cache files will be used.D
Two 32G flash cache files will be used.
考题
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
考题
单选题You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database（）A
4 and 6B
2，3，4，and 6C
1，2，4，5，and 6D
1，2，3，4，5，and 6
考题
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
考题
单选题You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
考题
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）A
An upper limit on how far you can flash back the database，depending on the information in the redo logsB
An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC
The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD
The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
考题
多选题You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
考题
单选题What command would you issue to enable automated backups of control files？（）A
alter database controlfile autobackup onB
alter system controlfile autobackup onC
configure controlfile autobackup onD
enable controlfile autobackup
考题
单选题You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’ How should the DB_FLASH_CACHE_SIZE be configured to use both devices?（）A
Set DB_FLASH_CACHE_SIZE=64GB
Set D3_FLASH_CACHE_SIZE=64G, 64GC
Set D3_FLASK_CACKE_SI2E=128GD
db_flash_cache_SI2E is automatically configured by the instance at startup
热门标签
最新试卷
