السؤال #1

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions

B. It always compares the latest snapshot with the baseline snapshot for analysis

C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis

D. It requires at least four AWR snapshots for analysis

E. It calls other advisors if required, but does not provide recommendations about the advisors to be use

عرض الإجابة

اجابة صحيحة: AB

السؤال #2

Which three statements are true about checkpointing? (Choose three.)

A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files

B. It ensures that all dirty buffers are written to data files during consistent shutdown

C. It reduces the time required for recovery in case of an instance failure

D. Frequent thread checkpoints can degrade database performance

E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file

عرض الإجابة

اجابة صحيحة: AC

السؤال #3

You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

A. external table

B. Oracle data Pump

C. SQL*Loader with a direct data path

D. SQL*Loader with a conventional data path

E. Enterprise Manager Database Express

عرض الإجابة

اجابة صحيحة: B

السؤال #4

Your database is running in NOARCHIVLOG mode. Examine the following parameters: You execute the following command after performing a STARTUP MOUNT: SQL> ALTER DATABASE ARCHIVELOG; Which statement is true about the execution of the command?

A. It executes successfully and sets the Fast Recovery Area as the local archive destination

B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database

C. It fails and returns an error about LOG_ARCHIVE_DEST not being set

D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destinatio

عرض الإجابة

اجابة صحيحة: C

السؤال #5

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin; Which statement is true?

A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role

B. It fails because system privileges cannot be granted with roles in the same audit policy

C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them

D. It fails because the command does not specify when the unified audit policy should be enforce

عرض الإجابة

اجابة صحيحة: ADF

السؤال #6

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump

B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure

C. Create the database by using the CREATE DATAEAS

D.

E. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location

عرض الإجابة

اجابة صحيحة: C

السؤال #7

Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.

A. Enterprise Manager on port 1158

B. telnet on port 23

C. Cloud Control on port 7799

D. SSH on port 22

E. SSL/TLS on port 443

عرض الإجابة

اجابة صحيحة: D

السؤال #8

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario? (Choose two.)

A. The user-managed backup consists of only formatted data blocks

B. The database must be shut down to take a user-managed backup

C. The RMAN backup contains only data files

D. The RMAN backup can be performed while the database is open

E. The database must be in MOUNT state to take RMAN backu

عرض الإجابة

اجابة صحيحة: ABC

السؤال #9

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time

B. AWR data is stored in memory and in a database

C. All AWR tables belong to the SYSTEM schema

D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self- tuning components in a database

E. An AWR snapshot contains system-wide tracing and logging informatio

عرض الإجابة

اجابة صحيحة: D

السؤال #10

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

A. It terminates if the SYSTEM tablespace in the source database is not autoextensible

B. It automatically makes necessary changes to Oracle environment variables

C. It automatically enables unified auditing in the upgraded database

D. It automatically adds new data files if there is not enough disk space to grow

عرض الإجابة

اجابة صحيحة: A

السؤال #11

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups. Which statement is true about the loss of a duplexed control file?

A. The database remains open but transactions are not permitted

B. The database instance aborts, and media recovery is required after restoration of the control file to open the database

C. The database instance remains open and the control file can be restored without shutting down the database

D. The database instance aborts and a control file restore operation does not require media recover

عرض الإجابة

اجابة صحيحة: A

السؤال #12

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

A. statistics recommendations

B. SQL profile recommendations

C. SQL statement restructure recommendations

D. creation of materialized views to improve query performance

عرض الإجابة

اجابة صحيحة: BC

السؤال #13

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo. Which two actions would you take to solve this problem? (Choose two.)

A. Increase the size of the temporary tablespace

B. Enable Automatic Memory Management (AMM)

C. Enable undo retention guarantee

D. Enable temporary undo for the database

E. Increase the size of the redo log buffe

عرض الإجابة

اجابة صحيحة: BDE

السؤال #14

Examine the parameters: Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks. Which two actions would you take to prevent this problem? (Choose two.)

A. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction

B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users

C. Set a limit in the proles of blocking users to control the number of data blocks that can be accessed in a session

D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions

E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking user

عرض الإجابة

اجابة صحيحة: BCFG

السؤال #15

What action must you take to ensure complete database recovery till the point of failure?

A. Multiplex the control files

B. Duplex the RMAN backup sets

C. Multiplex the online redo log files

D. Configure the database to run in ARCHIVELOG mod

عرض الإجابة

اجابة صحيحة: B

السؤال #16

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

A. A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window

B. A job class specifies a scheduler window that will be open when that job class becomes active

C. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active

D. A scheduler window specifies a job class that will be activated when that scheduler window becomes active

E. A scheduler window can control resource allocation by itsel

عرض الإجابة

اجابة صحيحة: BCD

السؤال #17

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

A. A schedule can be specified to a single job only

B. A scheduler job can point to a chain instead of pointing to a single program object

C. A job may get started automatically when a window opens

D. A program and job can be specified as part of a schedule definition

E. A job is specified as part of a program specification

F. A program can be used in the definition of multiple jobs

عرض الإجابة

اجابة صحيحة: CD

السؤال #18

Which three statements are true about Oracle Data Pump? (Choose three.)

A. IMPDP can be used to change target data file names, schemas, and tablespaces during import

B. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations

C. EXPDP and IMPDP are the client components of Oracle Data Pump

D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege

E. IMPDP always use the conventional path insert method to import data

عرض الإجابة

اجابة صحيحة: BC

لا تريد أن تفوت شيئا؟

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان

عرض الإجابات بعد التقديم

لا تريد أن تفوت شيئا؟

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع! احصل الان

عرض الإجابات بعد التقديم

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان