1z0-883
单选题You want a record of all queries that are not using indexes. How would you achieve this?（）A By enabling the Slow Query Log because all queries that are not using indexes will be logged automaticallyB By enabling the Error Log because not using indexes
题目
By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
By enabling the Error Log because not using indexes is an error
By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
By enabling the Error Log and using the – log-queries-not-using-indexes option
相似问题和答案
第1题：
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）
- A、 You must use automatic undo management in the database.
- B、 You must configure OMF in your database.
- C、 You must configure ASM for storing the datafiles.
- D、 You must multiplex the online redo log file.
正确答案:A
第2题：
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
- A、Create both jobs by using events raised by the scheduler
- B、Create both jobs by using events raised by the application
- C、Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
- D、Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application
正确答案:D
第3题：
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.How would you create these jobs?（）
A. Create both jobs by using events raised by the scheduler
B. Create both jobs by using events raised by the application
C. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D. Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application
第4题：
You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）
- A、enable index monitoring and query the DBA_OBJECTS view
- B、enable index monitoring and query the DBA_INDEXES view
- C、enable index monitoring and query the V$OBJECT_USAGE view
- D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
正确答案:C
第5题：
You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）
- A、by using triggers
- B、by using external tables
- C、by using anonymous PL/SQL blocks
- D、by auditing all DML operations on the table
正确答案:A
第6题：
Which information would you find using the CLI help function?（）
- A、message of the day
- B、tip of the day
- C、explanation for specific system log error messages
- D、explanation for specific traceoptions log messages
正确答案:B,C
第7题：
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQL>ALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）
- A、 The log sequence is reset to 0.
- B、 All the online redo logs are deleted.
- C、 All the archived redo logs from a previous incarnation become useless.
- D、 The full database backup taken from a previous incarnation can be used in future.
- E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
正确答案:D
第8题：
You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.
You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.
The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.
Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)
A. On drive C, create a transaction log.
On drive D, create a data file in the PRIMARY filegroup.
On drive E, create a data file in the SECONDARY filegroup.
B. On each drive, create a transaction log.
On each drive, create a data file in the PRIMARY filegroup.
C. On drive D, create a transaction log.
On drive E, create a data file in the PRIMARY filegroup.
D. On the PRIMARY filegroup, create all tables and all indexes.
E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.
F. On the PRIMARY filegroup, create the Parts table and its indexes.
On the SECONDARY filegroup, create all other tables and their indexes.
A,E 解析：Explanation:
A: The transaction log should be placed on a separate disk. A transaction log would not benefit of two or more disks since it is sequential. Create two data files on two separate physical disks would improve performance.
E: Separating the tables and the indexes improve performance for in particular joins.
Note: With SQL Server 2000 it is possible to create tables or indexes on specific filegroups. This allows us to control where the database's tables and indexes are physically located as filegroups can be placed on different hard drives. Placing tables in one filegroup and the table's nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes.
However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table. Furthermore, the transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance.
Incorrect Answers:
B: To improve performance, the transaction log should not be placed on the same physical disk that the tables or indexes are placed on. The transaction log file is written serially; therefore, placing it on a separate, dedicated disk allows the disk heads to stay in place for the next write operation and thus improves performance.
Furthermore, placing tables in one filegroup and the table's nonclustered indexes in another filegroup on different physical disk can improve database performance because it will allow separate threads to access the tables and indexes. However, a table and its clustered index cannot be separated into different filegroups as the clustered index determines the physical order of the data in the table.
C: The transaction log should be placed on a physically separate disk. The transaction log file is written serially; therefore, using a separate, dedicated disk allows the disk heads to stay in place for the next write operation. This will further improve performance. In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.
D: In this solution, the tables and their indexes are placed on the same disk. This solution thus does not take advantage of the performance improvements that can be realised through the correct utlization of the available hardware.
F: Greater performance gains can be realized by placing tables in one filegroup and the table’s nonclustered indexes in another filegroup on different physical disk. This will allow separate threads to access the tables and indexes.
第9题：
For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
- A、 Set the CPU time per call in the users profile.
- B、 Set the CPU time per session in the users profile.
- C、 Set the CPU levels for the user’s group using Resource Manager.
- D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
正确答案:C
第10题：
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）
- A、Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
- B、Execute the PURGE BINARY LOGE NOT USED command
- C、Remove all of the binary log files that have a modification date earlier than today
- D、Edit the .index file to remove the files you want to delete
- E、Ensure that none of the attached slaves are using any of the binary logs you want to delete
正确答案:A,E