问题:下列关于序列的使用场景说法正确的是()。A、使用序列代替多个字段的主键标识记录,以简化子表对于父表的引用关系B、需要产生诸如此类的单据流水号,可以借助序列来完成C、如果有多个用户同时向序列提出申请,可能会生成两个相同的整数
Thursday, September 15, 2022
问题:Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()A、SQL Repair AdvisorB、SQL OptimizerC、SQL Access AdvisorD、SQL Tuning Advisor
问题:当ORACLE9.2数据库服务器安装后,将自动创建两个具有超级权限的用户,并且要求设定这两个用户的口令,这两个用户是()A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER
Tuesday, November 22, 2022
问题:On Monday, you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A、You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.B、You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.C、You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.D、You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
问题:在Oracle中,关于锁,下列描述不正确的是()。A、锁用于在用户之间控制对数据的并发访问B、可以将锁归类为行级锁和表级锁C、insert、update、delete语句自动获得行级锁D、同一时间只能有一个用户锁定一个特定的表
问题: 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
Friday, September 16, 2022
问题:A team of programmers is reviewing a proposed API for a new utility class. After some discussion,they realize that they can reduce the number of methods in the API without losing any functionality.If they implement the new design, which two OO principles will they be promoting?()A、Looser couplingB、Tighter couplingC、Lower cohesionD、Higher cohesionE、Weaker encapsulationF、Stronger encapsulation
问题: You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? ()A、After two days, a backup will be marked obsoleteB、After two days, a backup will be deleted from the mediaC、If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.D、If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
问题: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 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.
问题:Which statement is true regarding the VALIDATE DATABASE command?()A、 It checks the database for intrablock corruptions only.B、 It checks for block corruption in the valid backups of the database.C、 It checks the database for both intrablock and interblock corruptions.D、 It checks for only those corrupted blocks that are associated with data files.
问题:You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?()A、All data along with the table structure is deleted B、The pending transaction in the session is committed C、All indexes on the table will remain but they are invalidated D、All views and synonyms will remain but they are invalidated E、All data in the table are deleted but the table structure will remain
问题: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.
问题:You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area?()A、 backup piecesB、 copies of all the parameter filesC、 trace file generated using BACKUP CONTROLFILE TO TRACED、 control file autobackups
问题: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
问题: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.
Tuesday, November 15, 2022
问题: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.
问题: 对于以下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,而应该用等号
问题:Identify three unique integration features of Spring and WebLogic Server.()A、ability to automatically convert Spring application to JavaEE 6 frameworkB、ability to export the WebLogic Container feature to another Spring enabled JavaEE serverC、ability to extend the WebLogic Server console with some Spring-related pagesD、official support of Spring apps inside WebLogic by Oracle SupportE、support for injection of WebLogic MBeans and Resources into Spring applications
问题: 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.