Oracle认证考试 题目列表
In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）A、 by setting the SQL_TRACE parameter to FALSE in the parameter fileB、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）A、The size of the shared pool is too small.B、Cursors are not being shared.C、A large number COMMITS are being performed.D、There are frequent logons and logoffs.E、The buffers are being read into the buffer cache, but some other session is changing the buffers.
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.
Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA、 b， a， c， d， eB、 a， c， b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 e， a， b， d， c
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）A、 Disable SQL tracing for the APPS tablespace.B、 Disable logging attributes for the APPS tablespace.C、 Modify the tablespace to be a dictionary-managed tablespace.D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
You configured automatic archive logging for the database. On the next startup the database runs for a while， but then hangs. After checking the alert log， you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log？（）A、LOG_ARCHIVE_DEST was not set in the parameter file.B、LOG_ARCHIVE_START was not set in the parameter file.C、alter database archivelog； was not executed in MOUNT mode.D、LOG_ARCHIVE_MAX processes were not set in the parameter file.
What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. D、Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.
Which two statements are true about encrypting RMAN backup?（） (Choose two.)A、The transparent encryption of backups uses the encryption walletB、The database uses the same encryption key for every encrypted backupC、The password encryption of backups only uses the password while creating and restoring backupD、If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.
当ORACLE9.2数据库服务器安装后，将自动创建两个具有超级权限的用户，并且要求设定这两个用户的口令，这两个用户是（）A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER
对于以下SQL语句说法正确的是（） SELECT ename FROM emp WHERE sal IN (SELECT MAX(sal) FROM emp GROUP BY deptno);A、这个语句是符合语法的B、这个语句是不能执行的,因为缺少HAVING子句C、这个语句是不能执行的,因为分组的条件列不在SELECT列表中D、这个语句是不能执行的,因为GROUP BY子句应该在主查询中,而不是在子查询中E、在主查询的WHERE条件中,不应该用IN,而应该用等号
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（）A、 NLS_LANGB、 NLS_COMPC、 NLS_SORTD、 None of the above
Which of the following parameters defines the location where Oracle should create archived redo logs?（）A、LOG_ARCHIVE_1 B、LOG_DESTINATION_1 C、LOG_ARCHIVED_DESTINATION_1D、LOG_ARCHIVE_DEST_1E、LOG_ARCHIVE_SOURCE_1
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?（）A、GRANT select, insert, update ON student_grades TO manager;B、GRANT select, insert, update ON student_grades TO ROLE manager;C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
What are four capabilities of the mysql client program?（）A、Creating, dropping, and modifying tables and indexesB、Initiating a binary backup of the database by using the START BACKUP commandC、Displaying replication status informationD、Shutting down the server by using the SHUTDOWN commandE、Creating and dropping databasesF、Creating and administering users
说明触发器的种类和对应的作用对象、触发事件。