网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）
A
Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
B
Use the ANALYZE utility.
C
Use the DBVERIFY utility.
D
Use the DBMS_REPAIR package.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB Use the ANALYZE utility.C Use the DBVERIFY utility.D Use the DBMS_REPAIR package.” 相关考题
考题
You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?()
A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
考题
In which case would you use a FULL OUTER JOIN? ()
A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.
考题
You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.What should you do?A．Select the commit on successful completion check box of the DTS package.B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.
考题
Which of the following defines memory interleaving?()
A. The distribution of data written across all the memory DIMMs and the L1 cacheB. The distribution of data written across all the memory DIMMs in one bankC. The distribution of data written across all the memory DIMMs and the processorD. The distribution of data written across all the memory DIMMs and the L2 cache
考题
You are the administrator of the homeoffice.local domain. You want to create a shared printer for the company's executives so that they do not have to wait for their documents to print when the default printer's queue contains a large number of documents.You configure the new high-priority printer and want to set permissions for the groups shown in the exhibit. Note: The default settings have been cleared.You select the check box to allow Print permission for the Executives group. You want only the Administrators, Print Operators, Server Operators, and Executives group to be able to print to the printer. What can you do? (Select all that apply).A．Remove the Everyone group.B．Select the check box to deny Print permission for the Everyone group.C．Select the check box to deny Manage Documents permission for Everyone group.D．Select all Deny check boxes for the Everyone group.E．Clear all check boxes for Everyone group.
考题
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.You want to minimize changes to your security model and to your database applications. How should you modify the database?A．Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.B．Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.C．Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.D．Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
考题
You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A、by using the ANALYZE utilityB、by using the DBVERIFY utilityC、by using the DB_BLOCK_CHECKING parameterD、by using the DBMS_REPAIR package
考题
Which of the following defines memory interleaving?（）A、The distribution of data written across all the memory DIMMs and the L1 cacheB、The distribution of data written across all the memory DIMMs in one bankC、The distribution of data written across all the memory DIMMs and the processorD、The distribution of data written across all the memory DIMMs and the L2 cache
考题
In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）A、The modified blocks would be written to the data files.B、The modified blocks would be written to the temp files.C、The modified blocks would be written to the control file.D、The modified blocks would be written to the redo log files.E、The modified blocks would be written to the archived redo log files.F、The modified blocks would be retained in the database buffer cache.
考题
According to your backup strategy， you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
考题
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）A、Data blocks have to be written more frequently by DBWR. B、Redo blocks have to be written more frequently by LGWR. C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
考题
You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A、The backup is similar to image copy.B、The backup contains all used data blocks.C、The backup contains only unused data blocks.D、The backup contains all data blocks changed since the last incremental level 1 backup.
考题
You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks（）？A、 ALTER DISKGROUP data CHECKB、 ALTER DISKGROUP data CHECK DISKC、 ALTER DISKGROUP data CHECK FILED、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
考题
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUEB、 Use the ANALYZE utility.C、 Use the DBVERIFY utility.D、 Use the DBMS_REPAIR package.
考题
The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A、 The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B、 The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C、 The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D、 The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E、 The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.
考题
You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）A、Create the relation manually and coordinate the blocks using triggers. B、Base the relation on a REF pointer using the Data Block Wizard. C、Base the relation on a foreign key using the Data Block Wizard. D、This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
考题
You are a network administrator for your company. All servers run Windows Server 2003. A network server named Server1 functions as the main file server. Server1 is backed up each night by using the Backup utility. You perform a test restoration of Server1 by using the Backup utility. You discover that files that are open during the backup process are not being backed up. You need to ensure that open files are backed up successfully. What should you do? （）A、Enable volume shadow copies on the partitions that are being backed up.B、Disable volume shadow copies on the partitions that are being backed up.C、Select the Verify data after backup check box in the Advanced backup options of the backup job.D、Clear the Disable volume shadow copy check box in the Advanced backup options of the backup job.
考题
单选题Which of the following defines memory interleaving？（）A
The distribution of data written across all the memory DIMMs and the L1 cacheB
The distribution of data written across all the memory DIMMs in one bankC
The distribution of data written across all the memory DIMMs and the processorD
The distribution of data written across all the memory DIMMs and the L2 cache
考题
单选题The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A
The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B
DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C
The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D
The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E
The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent
考题
单选题You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A
The backup is similar to image copy.B
The backup contains all used data blocks.C
The backup contains only unused data blocks.D
The backup contains all data blocks changed since the last incremental level 1 backup.
考题
单选题According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）A
The backup is similar to image copy.B
The backup contains all used data blocks.C
The backup contains only unused data blocks.D
The backup contains all data blocks changed since the last incremental level 1 backup.
考题
单选题You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks（）？A
ALTER DISKGROUP data CHECKB
ALTER DISKGROUP data CHECK DISKC
ALTER DISKGROUP data CHECK FILED
ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
考题
单选题You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A
by using the ANALYZE utilityB
by using the DBVERIFY utilityC
by using the DB_BLOCK_CHECKING parameterD
by using the DBMS_REPAIR package
考题
单选题In which case would you use a FULL OUTER JOIN? （）A
Both tables have NULL values.B
You want all unmatched data from one table.C
You want all matched data from both tables.D
You want all unmatched data from both tables.E
One of the tables has more data than the other.F
You want all matched and unmatched data from only one table.
考题
单选题You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）A
Create the relation manually and coordinate the blocks using triggers. B
Base the relation on a REF pointer using the Data Block Wizard. C
Base the relation on a foreign key using the Data Block Wizard. D
This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
考题
单选题In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）A
The modified blocks would be written to the data files.B
The modified blocks would be written to the temp files.C
The modified blocks would be written to the control file.D
The modified blocks would be written to the redo log files.E
The modified blocks would be written to the archived redo log files.F
The modified blocks would be retained in the database buffer cache.
考题
单选题The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A
The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B
The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C
The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D
The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E
The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.
热门标签
最新试卷
