网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）
A
4， 1， 3， 2， 5
B
1， 3， 4， 5， 2
C
1， 3， 2， 5； 4 not required
D
4， 1， 5， 2； 3 not required
E
1， 3， 4， 5； 2 not required
参考答案
参考解析
解析：
暂无解析
更多 “单选题You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）A 4， 1， 3， 2， 5B 1， 3， 4， 5， 2C 1， 3， 2， 5； 4 not requiredD 4， 1， 5， 2； 3 not requiredE 1， 3， 4， 5； 2 not required” 相关考题
考题
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 have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE path;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE path;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
考题
You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?A．Enable the torn page detection database option for each database.B．Disable write caching on all disk controllers.C．Ensure that write caching disk controllers have battery backups.D．Create a database maintenance plan to check database integrity and make repairs each night.
考题
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.
考题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）A、to enable the ASM instance to identify the alert log fileB、to enable the ASM instance to identify the server parameter fileC、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
考题
You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. You have enabled Internet connection sharing. You do not want to initiate this connection automatically when a request for Internet reaches your computer. What should you do? （）A、You should uncheck “Enable on demand dialingB、Enable on-demand dialingC、Enable sharing a modem on one computer on the networkD、Configure a DHCP ServerE、Disable Internet Connection Sharing
考题
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 have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. What should you do？ （）A、Enable Internet Connection SharingB、Enable on-demand dialingC、Enable sharing a modem on one computer on the networkD、Configure a DHCP ServerE、Disable Internet Connection Sharing
考题
You are an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. What should you do？ （）A、Enable Internet Connection SharingB、Enable on-demand dialingC、Enable sharing a modem on one computer on the networkD、Configure a DHCP ServerE、Disable Internet Connection SharingF、Configure all the other computers to be DHCP enabled.
考题
单选题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 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 work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A
Information about each Oracle Net connection.B
Information about each entry in theLinstener.orafileC
Information about the changed done in the databaseD
Information about the different listeners in your systemE
Information about all thenondatabasefiles required to operate the database
考题
单选题You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）A
ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
考题
单选题You want to enable archiving on your database. Presently， the database is running in NOARCHIVELOG mode.Given below are the steps to accomplish the task in random order： 1. Shut down the instance. 2. Execute the ALTER DATABASE ARCHIVELOG command. 3. Start up the instance and mount the database. 4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5. Open the database. Which is the correct sequence of steps for accomplishing the task（）A
4， 1， 3， 2， 5B
1， 3， 4， 5， 2C
1， 3， 2， 5； 4 not requiredD
4， 1， 5， 2； 3 not requiredE
1， 3， 4， 5； 2 not required
考题
单选题You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should you take to enable archiving at instance startup？（）A
AB
BC
CD
D
考题
单选题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 an administrator of a small business network. You have one dial-up account at an ISP and want all computers on your network connect to the Internet. You have enabled Internet connection sharing. You do not want to initiate this connection automatically when a request for Internet reaches your computer. What should you do? （）A
You should uncheck “Enable on demand dialingB
Enable on-demand dialingC
Enable sharing a modem on one computer on the networkD
Configure a DHCP ServerE
Disable Internet Connection Sharing
考题
单选题You have a DHCP server that runs Windows Server 2008.You need to reduce the size of the DHCP database. What should you do？（）A
From the DHCP snap-in， reconcile the database.B
From the folder that contains the DHCP database， run jetpack.exe dhcp.mdb temp.mdb.C
From the properties of the dhcp.mdb file， enable the File is ready for archiving attribute.D
From the properties of the dhcp.mdb file， enable the Compress contents to save disk space attribute.
考题
单选题You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A
the system change numberB
the locations of the redo log filesC
the locations of the datafilesD
the physical location of all the database changes
考题
单选题You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）A
Use the Database Resource Manager.B
Set the limits in the profiles used by users.C
Modify the SESSIONS initialization parameter.D
Set the warning threshold for the Current Logons Count metric.
考题
单选题You are attempting to connect to your ISP. You view the status change from Dialing to Verifying user name and password. After several seconds， the status changes to Disconnecting. You are then disconnected from the computer you dialed. You verify that your user name and password are entered correctly. You want to enable your Computer to connect to your ISP correctly. What should you do？ （）A
Configure your connection to enable data encryption.B
Configure your connection to use the UNIX SLIP server.C
Configure your connection to allow unsecured passwords.D
Instruct your ISP to configure your account to support Multilink.
考题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace，it must be in backup modeD
To back up a tablespace，it must first be taken offline
考题
单选题You want to enable archiving on your database. Presently， the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order： 1：Shut down the instance. 2：Execute the ALTER DATABASE ARCHIVELOG command. 3：Start up the instance and mount the database. 4：Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 5： Open the database. Which is the correct sequence of steps for accomplishing the task（）A
4，1，3，2，5B
1，3，4，5，2C
1，3，2，5；4 not requiredD
4，1，5，2；3 not requiredE
1，3，4，5；2 not required
考题
单选题You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature？（）A
ALTER DATABASE ENABLE BLOCK CHANGE TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
考题
单选题You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this？（）A
Run Segment AdvisorB
Run the SQL Tuning Advisor （STA）C
Run the Automatic Workload Repository （AWR） reportD
Run the SQL Access Advisor with a hypothetical workload
考题
单选题You have a DHCP server that runs Windows Server 2008 R2.You need to reduce the size of the DHCP database. What should you do？（）A
From the DHCP snap-in, reconcile the database.B
From the folder that contains the DHCP database, run jetpack.exe dhcp.mdb temp.mdb.C
From the properties of the dhcp.mdb file, enable the File is ready for archiving attribute.D
From the properties of the dhcp.mdb file, enable the Compress contents to save disk space attribute.
热门标签
最新试卷
