1 MB
6 MB
10 MB
15 MB
11 MB
第1题:
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.
You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.
You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?
A.Increase the maximum file size of Sales_Data to 1,500MB.
B.Use the DBCC SHRINKDATABASE statement.
C.Set automatic file growth to 10 percent.
D.Create another data file named Sales_Data2 in a new SECONDARY filegroup.
第2题:
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
第3题:
A.120M
B.320M
C.480M
D.600M
第4题:
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database?()
第5题:
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario()
第6题:
In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()
第7题:
Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?()
第8题:
A. 90 MB
B. 272 MB
C. 362 MB
D. 1,440 MB
第9题:
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value()
第10题:
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?()