• 多选题 Which three statements are true about Flashback Database?（）

  标签：1Z0-060 2023-03-20 17:08

• 多选题 A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）

  标签：1Z0-060 2022-01-03 19:25

• 单选题 An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）

  标签：1Z0-060 2022-01-03 19:25

• 单选题 A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

  标签：1Z0-060 2022-01-03 17:23

• 多选题 You execute the following PL/SQL:Which two statements are true?（）

  标签：1Z0-060 2022-01-03 13:02

• 多选题 A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）

  标签：1Z0-060 2022-01-03 11:23

• 单选题 In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?（）

  标签：1Z0-060 2022-01-03 05:13

• 多选题 Which two statements are true about Oracle Managed Files (OMF)?（）

  标签：1Z0-060 2022-01-03 05:12

• 单选题 In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）

  标签：1Z0-060 2022-01-03 05:10

• 多选题 Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges?（）

  标签：1Z0-060 2022-01-03 04:08

• 多选题 Which three statements are true about adaptive SQL plan management?（）

  标签：1Z0-060 2022-01-02 17:09

• 单选题 You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

  标签：1Z0-060 2022-01-02 08:55

• 单选题 You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs. How do you accomplish this?（）

  标签：1Z0-060 2022-01-02 03:49

• 单选题 You created an encrypted tablespace: You then closed the encryption wallet because you were advised that this is secure. Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?（）

  标签：1Z0-060 2022-01-02 02:08

• 单选题 You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?（）

  标签：1Z0-060 2022-01-01 12:30

免费的网站请分享给朋友吧