Your database supports an online transaction processing (OLTP) application.
The application is undergoing some major schema changes, such as addition of new indexes and materialized views.
You want to check the impact of these changes on workload performance.
What should you use to achieve this?（）
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?（）
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:
Which statement should you use to resolve this issue?（）
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.
Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
An enterprise has plans to start adding IPv6 support. The initial deployment requires support from some IPv6 - only device s that need to access servers that support only IPv4.
Which of the following tools would be most appropriate?（）
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.
Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file
3) Start the target database instance
4) Mount the database
5) Restore the data files
6) Open the database with RESETLOGS option
7) Recover the data files
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?（）
具体审计程序 | 管理层认定名称 |
⑴查明所记载的大额销售业务是否满足确认收入的条件 |
|
⑵追查银行存款余额调节表中银行已付、企业未付的未达账项 |
|
⑶检查12月末入库的原材料是否直到资产负债表日仍未收到购货发票 |
|
⑷检查应付账款是否存在借方余额 |
|
⑸对以非记账本位币结算的应付账款，检查其采用的折算汇率是否正确 |
|
⑹检查发运凭证上的商品数量是否与销售发票上的数量一致 |
|
⑺检查月末顾客对账单回函与应收账款明细账记录是否存在差异 |
|
⑻检查投资转出的固定资产是否已作账务处理 |
|
⑼将存货明细账余额加计与总账余额核对 |
|
下面是一份早教机构的半日早教活动计划，请回答相关问题。
|
8:30入园，晨间接待 |
8:40自由活动 |
|
9:00喝水、如厕 |
9:10集体游戏活动 |
|
9:40喝奶 |
10:00 户外游戏活动 |
|
10:30舞蹈律动 |
11:00音乐游戏 |
|
11:30离园 |
|
【1.5分】判断：这份半日活动计划违背了早教活动中“活动内容动静交替”的原则
You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this?（）
Your database supports an online transaction processing (OLTP) application.
The application is undergoing some major schema changes, such as addition of new indexes and materialized views.
You want to check the impact of these changes on workload performance.
What should you use to achieve this?（）
Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）
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?（）
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?（）
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?（）
As an experienced technician, you are responsible for Technical Support in your company. One of the trainees is asking you which Cisco VPN Acceleration Module for Cisco 7200 Series routers and the Cisco 7301 provides high-performance encryption/compression and supports the latest encryption standard.
Which of the following will answer his question?（）
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one
redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?（）
You add an Online Responder to an Online Responder Array.
You need to ensure that the new Online Responder resolves synchronization conflicts for all members of the Array.
What should you do（）
免费的网站请分享给朋友吧