4, 1, 3, 2, 5
1, 3, 4, 5, 2
1, 3, 2, 5; 4 not required
4, 1, 5, 2; 3 not required
1, 3, 4, 5; 2 not required
第1题:
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.
第2题:
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?()
第3题:
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第4题:
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? ()
第5题:
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()
第6题:
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? ()
第7题:
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? ()
第8题:
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;
第9题:
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?()
第10题:
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? ()