ORACLE OCP 1Z0-062_在线真题试卷与模拟练习_ORACLE OCP 1Z0-062_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL; Which two statements are true? (Choose two.)

Which three statements are true concerning the multitenant architecture? (Choose three.)

You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window.Which two actions would reduce the job's elapsed time? (Choose two.)

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.Which two methods or commands would you use to accomplish this task? (Choose two.)

You run a script that completes successfully using SQL*Plus that performs these actions:1Creates a multitenant container database (CDB)2Plugs in three pluggable databases (PDBs)3Shuts down the CDB instance4Starts up the CDB instance using STARTUP OPEN READ WRITEWhich two statements are true about the outcome after running the script? (Choose two.)

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byIssuing the following command:1snrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?

Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.) (Choose three.)

You execute the following PL/SQL:

BEGIN

DBMS_FGA.add_policy(Object_schema => JIM',

Object_name => ‘PRODUCTS’,

Policy_name => ‘PROD_AUDIT',

Audit_condition => 'PRICE > 10000’,

Audit_column => 'PRICE');

END;

/

Which two statements are true? (Choose two.)

You execute the following commands to audit database activities:SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;Which statement is true about the audit record that generated when auditing after instance restarts?

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM).Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

To enable the Database Smart Flash Cache, you configure the following parameters:DB_FLASH_CACHE_FILE = ‘ /dev/flash_device_1 ’ , ‘ /dev/flash_device_2 ’ DB_FLASH_CACHE_SIZE=64GWhat is the result when you start up the database instance?

You executed this command to create a password file:$ orapwd file = orapworcl entries = 10 ignorecase = NWhich two statements are true about the password file? (Choose two.)

Identify three valid methods of opening, pluggable databases (PDBs).

You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)

You are administering a database and you receive a requirement to apply the following restrictions:1>A connection must be terminated after four unsuccessful login attempts by user.2>A user should not be able to create more than four simultaneous sessions.3>User session must be terminated after 15 minutes of inactivity.4>Users must be prompted to change their passwords every 15 days.How would you accomplish these requirements?

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c? (Choose two.)

You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)

更多题库