Oracle 2 Flashcards by user unknown

Examine the parameters for a database instance:
Your database has three undo tablespaces and the default undo tablespace is not autoextensible.

Resumable space allocation is not enabled for any sessions in the database instance.

What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions?

A. Transactions write their undo in the SYSTEM undo segment.

B. Transactions fail.

C. Transactions wait until space becomes available in UNDOTBS1.

D. Transactions write their undo in a temporary tablespace.

B. Transactions fail.

How well did you know this?

Not at all

Perfectly

The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance.
You execute the following command to create a table:

Which two statements are true? (Choose two.)

A. The table is created without a segment because the storage clause is missing.

B. A segment is allocated when the first row is inserted in the table.

C. A segment is allocated when an index is created for any column in the table.

D. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.

E. A segment is allocated for the table if the ALTER TABLE… ALLOCATE EXTENT command is issued.

B. A segment is allocated when the first row is inserted in the table.

E. A segment is allocated for the table if the ALTER TABLE… ALLOCATE EXTENT command is issued.

How well did you know this?

Not at all

Perfectly

Which three statements are true about automated maintenance tasks? (Choose three.)

A. They run at predefined time intervals that are intended to occur during a period of low system load.

B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning.

A. They run at predefined time intervals that are intended to occur during a period of low system load.

B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning.

How well did you know this?

Not at all

Perfectly

Which three statements are true about the purpose of checkpoints? (Choose three.)

A. They ensure that uncommitted transactions are rolled back in case of an instance failure.

B. They ensure that all the dirty buffers are written to disk during a normal shutdown.

C. They ensure that instance recovery starts in the event of an instance failure.

D. They ensure that dirty buffers in the buffer cache are written to disk regularly.

E. They reduce the time required for recovery in case of an instance failure.

B. They ensure that all the dirty buffers are written to disk during a normal shutdown.

D. They ensure that dirty buffers in the buffer cache are written to disk regularly.

E. They reduce the time required for recovery in case of an instance failure.

How well did you know this?

Not at all

Perfectly

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:

HR then opens a second session.

Which two operations wait when executed in HR’s second session? (Choose two.)

A. LOCK TABLE employees IN EXCLUSIVE MODE;

B. INSERT INTO employees(empno,ename) VALUES (1289, `Dick’);

C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;

D. SELECT empno,ename FROM employees WHERE job=’CLERK’;

E. INSERT INTO employees(empno,ename,job) VALUES 2001,’Harry’,’CLERK);

A. LOCK TABLE employees IN EXCLUSIVE MODE;

C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;

How well did you know this?

Not at all

Perfectly

In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.

B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.

D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.

E. The MYTAB table is owned by the SYS user.

B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.

E. The MYTAB table is owned by the SYS user.

How well did you know this?

Not at all

Perfectly

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

A. Performance improves because less redo is written to the redo log.

B. Temporary undo reduces the amount of undo stored in undo tablespaces.

C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.

D. Performance improves because no redo and undo are generated for the temporary tables.

A. Performance improves because less redo is written to the redo log.

B. Temporary undo reduces the amount of undo stored in undo tablespaces.

How well did you know this?

Not at all

Perfectly

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

A. It generates a script to recompile invalid objects post-upgrade.

B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.

C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.

D. It checks for required tablespaces and if they are not available, creates them automatically.

E. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.

F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.

C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.

F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

How well did you know this?

Not at all

Perfectly

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

A. execution of SQL statements by users connected with the SYSDBA privilege

B. creation of a fine-grained audit policy

C. configuration of unified auditing mode

D. usage of the AUDIT statement

A. execution of SQL statements by users connected with the SYSDBA privilege

How well did you know this?

Not at all

Perfectly

You want to create a role that:

is protected from unauthorized usage
does not use a password embedded in the application source code or stored in a table
is enabled for a user based on security policies defined in a PL/SQL package

How would you create this role?

A. as a secure application role

B. with definer’s rights

C. with global authentication

D. with external authentication

A. as a secure application role

How well did you know this?

Not at all

Perfectly

Your database instance is started by using a server parameter file (SPFILE).

You execute the following command to change the value of the LOG_BUFFER initialization parameter:

ALTER SYSTEM SET LOG_BUFFER=32 M;

What is the outcome of this command?

A. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

B. It returns an error because the value of this parameter cannot be changed dynamically.

C. The parameter value is changed and it comes into effect at the next instance startup.

D. It returns an error because SCOPE should be set to MEMORY

B. It returns an error because the value of this parameter cannot be changed dynamically.

How well did you know this?

Not at all

Perfectly

You want to create a database and you have the following:

Oracle Grid Infrastructure is installed and configured.
Oracle Database Vault is installed in ORACLE_HOME to be used for this database.
Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.

Examine the requirements:

configuring the database instance to support shared server mode
using Automatic Storage Management (ASM) for storing database files.
configuring a naming method to help a remote user connect to a database instance
configuring the Fast Recovery Area
configuring Database Vault
configuring Enterprise Manager (EM) Database Express
registering with EM Cloud Control
configuring remote log archive destinations
enabling daily incremental backups
configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A. 1, 2, 4, 5, 7, 8, 9 and 10

B. 1, 2, 4, 5, 6 and 7

C. 1, 2, 3, 8, 9 and 10

D. 1, 2, 3, 4, 6, 8, 9 and 10

E. 1, 2, 4, 5, 6, 7 and 8

D. 1, 2, 3, 4, 6, 8, 9 and 10

How well did you know this?

Not at all

Perfectly

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.

You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.

Which two statements are true? (Choose two.)

A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

C. A resumable statement can be suspended and resumed only once during execution.

D. A suspended statement will report an error if no corrective action has taken place during a timeout period.

E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

D. A suspended statement will report an error if no corrective action has taken place during a timeout period.

How well did you know this?

Not at all

Perfectly

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A. It calls SQL advisors automatically if required.

B. It provides recommendations only for poorly performing SQL statements.

C. Its results are stored in AWR.

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

E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysis.

C. Its results are stored in AWR.

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

How well did you know this?

Not at all

Perfectly

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.

B. It automatically makes necessary changes to Oracle environment variables.

How well did you know this?

Not at all

Perfectly

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.

B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.

C. Install Oracle HTTP Server.

D. Configure at least one dispatcher for the TCP/IP protocol.

E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.

B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.

D. Configure at least one dispatcher for the TCP/IP protocol.

How well did you know this?

Not at all

Perfectly

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload.

You want to analyze some of the most resource-intensive statements cached in the library cache.

What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A. Automatic Database Diagnostic Monitor (ADDM)

B. SQL Tuning Advisor

C. SQL Access Advisor

D. SQL Performance Analyzer

E. Automatic Workload Repository (AWR) report

C. SQL Access Advisor

How well did you know this?

Not at all

Perfectly

In which situations does the Database Writer process (DBWn) write to data files? (choose two).

A. when the RMAN recovery process starts

B. when a user process commits a transaction

C. when a tablespace is made read-only or taken offline

D. when PMON cleans up dirty buffers in the database buffer cache

E. when clean buffers for reading new blocks into the database buffer cache are not found easily

C. when a tablespace is made read-only or taken offline

E. when clean buffers for reading new blocks into the database buffer cache are not found easily

How well did you know this?

Not at all

Perfectly

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

A. The ability of users to audit their own schema objects is not available in the post-migrated database.

B. Operating system audit trail is available in the post-migrated database.

C. Network auditing is available in the post-migrated database.

D. Mandatory auditing of audit administrative actions is available in the post-migrated database.

A. The ability of users to audit their own schema objects is not available in the post-migrated database.

D. Mandatory auditing of audit administrative actions is available in the post-migrated database.

How well did you know this?

Not at all

Perfectly

Which three statements are true about Database Resource Manager? (Choose three.)

A. A resource plan change can be automated by using the Oracle Scheduler.

B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

C. It can be used to control the usage of the undo tablespace by consumer groups.

D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

E. It can be used to enable resumable timeout for user sessions.

F. It can be used to control the usage of the temp tablespace by consumer groups.

A. A resource plan change can be automated by using the Oracle Scheduler.

C. It can be used to control the usage of the undo tablespace by consumer groups.

D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

How well did you know this?

Not at all

Perfectly

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

A. Optimizer statistics are collected automatically.

B. Only timed operating system (OS) statistics and plan execution statistics are collected.

C. Automatic Workload Repository (AWR) snapshots are not generated automatically.

D. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

C. Automatic Workload Repository (AWR) snapshots are not generated automatically.

How well did you know this?

Not at all

Perfectly

You are administering a database that supports an OLTP workload.
The default UNDO tablespace is a fixed size tablespace with the RETENTION NOGUARATNEE clause and undo retention set to 12 minutes.

The user SCOTT queries a large table during peak activity.

The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old

Which is possible reason for this?

A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

B. The query is unable to place data blocks in the UNDO tablespace.

C. The flashback data archive is not enabled for the table on which the query is issued.

D. There is not enough space in Fast Recovery Area.

E. The Oracle server is unable to generate a read-consistent image for a block containing uncommitted updates.

A. The Oracle server is unable to generate a read-consistent image for a block containing updates.committed after the query began.

How well did you know this?

Not at all

Perfectly

Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)

A. segments in tablespaces that have exceeded a critical or warning space threshold

B. segments that have the highest growth rate in a database

C. segments that are sparsely populated and have more than 10% of free space below the high water mark.

D. segments that have unusable indexes

E. segments for tables created using ADVANCED ROW COMPRESSION

A. segments in tablespaces that have exceeded a critical or warning space threshold

B. segments that have the highest growth rate in a database

How well did you know this?

Not at all

Perfectly

Automatic Shared Memory Management (ASMM) is enabled for your database instance.

You execute the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

B. It fails because DB_CACHE_SIZE is a static initialization parameter.

C. It fails because ASMM is enabled and individual SGA components cannot be sized.

D. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.

A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

How well did you know this?

Not at all

Perfectly

You want to create a database with a block size other than the default 8 kilobytes (KB) by using the Database Configuration Assistant (DBCA). Which option should you use? A. Automatic Storage Management (ASM) for storage of data files B. a file system for storage of data files C. a Data Warehouse database template D. a custom database template

D. a custom database template

Which two statements are true about using SQL\*Loader? (Choose two.) A. It can load data from external files by using the direct path only. B. It can load data into multiple tables using the same load statement. C. It can load data into only one table at a time. D. It can generate unique sequential key values in specified columns. E. It can load data from external files by using the conventional path only.

B. It can load data into multiple tables using the same load statement. D. It can generate unique sequential key values in specified columns.

The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command: SQL\> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION; Tom then executes this command to grant privileges to the user JIM: SQL\> GRANT SELET ON hr.bonuses TO jim; Which statement is true? A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM. B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM. C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them. D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

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 destination.

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

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database? A. It provides a summary of the upgrade results. B. It recompiles all invalid PL/SQL and Java code. C. It generates a log file containing the fixes that can be made to the source database. D. It provides parallel upgrade options to finish the upgrade process with a reduced down time. E. It generates fix-up scripts to be run on the source database before upgrade.

D. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

Which statement is true about redo log files during instance recovery? A. All current, online, and archived redo logs are required to complete instance recovery. B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint. C. All redo log entries in the current log are applied to data files until the checkpoint position is reached. D. All current, active, and inactive redo logs are required to complete instance recovery.

B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.

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 backup.

B. The database must be shut down to take a user-managed backup. E. The database must be in MOUNT state to take RMAN backup.

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery? (Choose three.) A. loss of all the copies of the control file B. loss of all the inactive online redo log group members C. loss of a data file that belongs to the active undo tablespace D. loss of data files that belong to the SYSTEM tablespace E. logical corruption of data that is caused by a wrong transaction F. abnormal termination of the database instance

A. loss of all the copies of the control file C. loss of a data file that belongs to the active undo tablespace D. loss of data files that belong to the SYSTEM tablespace

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.) A. You cannot specify how partitioned tables should be handled during an import operation. B. Only data can be compressed during an export operation. C. Existing dump files can be overwritten during an export operation. D. Tables cannot be renamed during an import operation. E. Metadata that is exported and imported can be filtered based on objects and object types.

C. Existing dump files can be overwritten during an export operation. E. Metadata that is exported and imported can be filtered based on objects and object types.

Your database instance has the following parameter setting: OS\_AUTHENT\_PREFIX = OPS$ You execute the following command: And then grant OPS$GUEST\_USER the CREATE SESSION privilege. Which two statements are true? (Choose two.) A. GUEST\_USER can query the tables created in the USERS tablespace by default. B. The authentication details for GUEST\_USER are stored in the database password file. C. A local GUEST\_USER OS account should exist before GUEST\_USER can log on to the database. D. GUEST\_USER can log on to the database without specifying a username and password. E. GUEST\_USER is forced to change the password at the first login.

C. A local GUEST\_USER OS account should exist before GUEST\_USER can log on to the database. D. GUEST\_USER can log on to the database without specifying a username and password.

Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period for comparison when you analyze the performance of the database later. What must you do to achieve this? A. Increase the window size of the moving window baseline so that it equals the Automatic Workload Repository (AWR) snapshot retention period. B. Create a baseline on a pair of snapshots that span the peak load period. C. Generate Active Session History reports for the peak load period. D. Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

B. Create a baseline on a pair of snapshots that span the peak load period.

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.) A. listener configured by using NETCA B. database service created by using SRVCTL C. database created by using a SQL statement D. database created by using DBCA E. ASM instance created by using ASMCA F. database service created by using DBMS\_SERVICE.CREATE\_SERVICE G. database service created by modifying the SERVICE\_NAMES initialization parameter

A. listener configured by using NETCA B. database service created by using SRVCTL D. database created by using DBCA E. ASM instance created by using ASMCA

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command: $ make fins\_rdbms.mk uniaud\_on ioracle ORACLE\_HOME=$ORACLE\_HOME Which two steps should you perform before executing this command? (Choose two.) A. Ensure that the initialization parameter AUDIT\_TRAIL is set to DB. B. Drop any existing fine-grained audit (FGA) policies. C. Stop the listener. D. Shut down the database instance. E. Disable auditing by setting the initialization parameter AUDIT\_TRAIL to NONE.

C. Stop the listener. D. Shut down the database instance.

You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed. You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas. What must you run to achieve this? A. SQL Access Advisor with a SQL tuning set B. Automatic Database Diagnostic Monitor (ADDM) report C. SQL Tuning Advisor D. SQL Access Advisor with a hypothetical workload E. SQL Performance Analyzer

D. SQL Access Advisor with a hypothetical workload

The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction. Which two types of lock exist in this situation? (Choose two.) A. exclusive lock on the EMPLOYEES table B. null lock on the row being updated C. null lock on the EMPLOYEES table D. row level lock on the row being updated E. shared lock on the EMPLOYEES table

D. row level lock on the row being updated E. shared lock on the EMPLOYEES table

For which three requirements would you use the Database Resource Manager? (Choose three.) A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions B. limiting the degree of parallelism of operations performed by user sessions in a consumer group C. specifying the maximum number of concurrent sessions allowed for a user D. limiting the CPU used per database call E. specifying the amount of private space a session can allocate in the shared pool of the SGA.

A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions B. limiting the degree of parallelism of operations performed by user sessions in a consumer group C. specifying the maximum number of concurrent sessions allowed for a user

In your database instance, the UNDO\_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace. Which statement is true about undo retention? A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency. B. Inactive undo is retained for at least 1000 seconds if free undo space is available. C. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace. D. Undo becomes expired obsolete after 1000 seconds.

B. Inactive undo is retained for at least 1000 seconds if free undo space is available.

Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.) A. the tnsnames.ora file B. the sqlnet.ora file C. the initialization parameter file D. the password file E. the listener.ora file

C. the initialization parameter file D. the password file

In your Oracle 12c database, you invoke SQL \*Loader Express Mode command to load data: $\> sqlldr hr/hr table=employees Which two statements are true about this command? (Choose two.) A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist. B. It fails because the SQL \*Loader control file location is not specified. C. It fails because the SQL \*Loader data file location is not specified. D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database. E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.

D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database. E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.

Backup requirements for a database: * \* Level 0 backup on Sunday * \* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday * \* Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.) A. Level 0 backup on Sunday contains all the blocks that have been formatted. B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup. C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup. D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup. E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.

A. Level 0 backup on Sunday contains all the blocks that have been formatted. C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup. D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.) A. It can be used to create a database template from an existing database. B. It can be used to add a new tablespace. C. It can generate SQL database creation scripts. D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host. E. It can configure Automatic Storage Management (ASM) diskgroups.

A. It can be used to create a database template from an existing database. C. It can generate SQL database creation scripts.

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.) A. The backups would be consistent. B. The backups would be possible only if the database is running in ARCHIVELOG mode. C. The backups need to be restored and the database has to be recovered in case of a media failure. D. The backups would be inconsistent. E. The backups by default consist of all the data blocks within the chosen files or the full database.

B. The backups would be possible only if the database is running in ARCHIVELOG mode. C. The backups need to be restored and the database has to be recovered in case of a media failure. D. The backups would be inconsistent.

Which three tools or tasks are run by default as part automated maintenance tasks? (Choose three.) A. Automatic Database Diagnostic Monitor B. optimizer statistics gathering C. SQL Access Advisor D. Segment Advisor E. Automatic SQL Tuning Advisor

B. optimizer statistics gathering D. Segment Advisor E. Automatic SQL Tuning Advisor

You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.) A. Perform a rolling upgrade. B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA). C. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command. D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database. E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database. E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

Examine the following command: SQL\> DBMS\_STATS. SET\_TABLE\_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false'); What is the effect of executing this command? A. Existing statistics for the CUSTOMERS table become unusable for the query optimizer. B. Automatic statistics collection is stopped for the CUSTOMERS table. C. Statistics for the CUSTOMERS table are locked and cannot be overwritten. D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.

D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.

You install Oracle Grid Infrastructure for a standalone server. Which two components are automatically included in the Oracle Restart configuration? (Choose two.) A. A pre-existing Oracle Net Listener B. Oracle Notification services C. A pre-existing database D. A pre-existing Oracle management agent E. Oracle CSSD service

B. Oracle Notification services E. Oracle CSSD service

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 used.

A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions. C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured. Loss of which three database files can lead to an incomplete recovery? (Choose three.) A. inactive online redo log file group B. a data file belonging to the default temporary tablespace C. a data file belonging to the SYSAUX tablespace D. server parameter file (SPFILE) E. active online redo log file group F. all the control flies

C. a data file belonging to the SYSAUX tablespace E. active online redo log file group F. all the control flies

Which two statements are true about resumable space allocation? (Choose two.) A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions. B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution. C. A resumable statement can be suspended and resumed only once during a session. D. Resumable space allocation does not apply when a database instance uses asynchronous commit. E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace. F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions. B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

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 buffer.

A. Increase the size of the temporary tablespace. D. Enable temporary undo for the database.

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems. Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.) A. The remote system must have a running Oracle Database instance and a scheduler agent installed. B. The initialization parameter REMOTE\_OS\_AUTHENT must be set to TRUE on your database. C. The local database must be set up to run remote external jobs. D. The remote system's scheduler agent must be registered with your database. E. Database links to remote databases must be created.

C. The local database must be set up to run remote external jobs. D. The remote system's scheduler agent must be registered with your database.

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 role. OE\_ADMIN 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 enforced.

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 role. OE\_ADMIN

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance. Which tool would you use to get advice on how to improve performance? A. Memory Advisor for the PGA B. SQL Access Advisor C. Memory Advisor for the shared pool D. SQL Tuning Advisor

C. Memory Advisor for the shared pool

Identify three uses of the CROSSCHECK command (Choose three.) A. to validate the database backup B. to synchronize logical backup records with physical files in backup storage C. to check the obsolete backups that can be deleted from the file system D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file E. to update the recovery catalog or control file if archived log files are deleted with operating system commands

B. to synchronize logical backup records with physical files in backup storage D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file E. to update the recovery catalog or control file if archived log files are deleted with operating system commands

Which statement is true about the Oracle central inventory directory (oraInventory)? A. oraInventory must not be shared by all Oracle software installations on a single system. B. If ORACLE\_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ path. oraInventory C. lf an OFA-compliant path is not created and the ORACLE\_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation. D. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.

C. lf an OFA-compliant path is not created and the ORACLE\_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.

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 information.

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

You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: What should you do to resolve the error? A. Add network\_link = devdb.us.oracle.com. B. Add the SYSTEM user to the schemas option. C. Change the dumpfile option value to schema.dat@devdb.us.oracle.com. D. Replace the schemas option with network\_1ink = devdb.us.oracle.com. E. Replace the dumpfile option with network\_1ink = devdb.us.oracle.com.

E. Replace the dumpfile option with network\_1ink = devdb.us.oracle.com.

Which three statements are true about server-generated alerts? (Choose three.) A. Server-generated alerts notify administrators of problems that cannot be resolved automatically. B. Alerts are not issued for locally managed read-only tablespaces. C. Response actions cannot be specified for server-generated alerts. D. Stateful alerts can be queried only from the DBA\_ALERT\_HISTORY view. E. When an alert is cleared, it is moved to the DBA\_ALERT\_HISTORY view.

A. Server-generated alerts notify administrators of problems that cannot be resolved automatically. B. Alerts are not issued for locally managed read-only tablespaces. E. When an alert is cleared, it is moved to the DBA\_ALERT\_HISTORY view.

Which two statements are true about Automatic Storage Management (ASM)? (Choose two.) A. It mounts databases and diskgroups to make ASM files available to database instances. B. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load. C. It automatically places each disk from an external redundancy diskgroup in its own failure group. D. It divides files into extents and allows an extent to span disks. E. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

B. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load. E. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.

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 DATABASE. . . command and manually import data by using Data Pump. D. 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.

D. 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.

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

C. SQL\*Loader with a direct data path

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command: SQL\> STARTUP UPGRADE Which three statements are true about the upgrade process? (Choose three.) A. All system triggers are disabled during the upgrade process. B. Only queries on fixed views execute without errors until you run the catctl.pl script. C. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command. D. All job queues remain active during the upgrade process. E. Only connections AS SYSDBA are allowed during the upgrade process.

A. All system triggers are disabled during the upgrade process. B. Only queries on fixed views execute without errors until you run the catctl.pl script. E. Only connections AS SYSDBA are allowed during the upgrade process.

Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c? A. It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure. B. It can be used to migrate a database only if the source and target databases are hosted on the same endian format. C. It can be used to migrate a database only if the source database does not have any tablespace in readonly mode. D. It allows migration of a database directly over network links.

D. It allows migration of a database directly over network links.

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database. Which two tools or utilities would you use to achieve this? (Choose two.) A. Oracle Enterprise Manager Database Express (EM Express) B. Oracle Enterprise Manager Cloud Control C. Database Configuration Assistant (DBCA) D. Recovery Manager (RMAN) script invoked by using scheduler

B. Oracle Enterprise Manager Cloud Control D. Recovery Manager (RMAN) script invoked by using scheduler

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.) A. recommending creation of indexes based on SQL workload B. recommending restructuring of SQL statements that have suboptimal plans C. checking schema objects for missing and state statistics D. recommending optimization of materialized views E. generating SQL profiles

B. recommending restructuring of SQL statements that have suboptimal plans C. checking schema objects for missing and state statistics E. generating SQL profiles

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 profiles 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 users.

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 users.

Examine the following steps: A DBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user. Which statement is true? A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it. B. HR can grant the CREATE TABLE system privilege to other users. C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY. D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY.

What is pre-requisite to alter a role? A. You should be granted the DBA role. B. You should set the OS\_ROLES parameter to true. C. You should be granted the role with the GRANT OPTION. D. You should have the ALTER ANY ROLE system privilege.

D. You should have the ALTER ANY ROLE system privilege.

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. SSH on port 22

In your database, the RESOURCE\_LIMIT parameter is set to TRUE. You create the profile: Which two statements are true about users and their sessions that are subject to this profile? (Choose two.) A. The CPU\_PER\_CALL is ignored in the user sessions because of the unlimited value of CPU\_PER\_CALL B. These users can never reuse a password C. The PASSWORD\_LIFE\_TIME value is ignored because of the unlimited value of PASSWORD\_REUSE\_MAX. D. In each user session, the limit for LOGICAL\_READS\_PER\_SESSION in the same as defined in the DEFAULT profile.

B. These users can never reuse a password D. In each user session, the limit for LOGICAL\_READS\_PER\_SESSION in the same as defined in the DEFAULT profile.

Examine the command: SQL\> ALTER SYSTEM SET ENABLE\_DDL\_LOGGING=TRUE; Which two statements are true in this scenario? (Choose two.) A. All data definition language (DDL) commands are logged in to the alert log file. B. All DDL commands are logged in to a text file in Automatic Diagnostic Repository (ADR) home. C. A subset of executed DDL statements is written into an XML file in ADR home. D. A subset of executed DDL statements is written to the DDL log in ADR home. E. All DDL commands are logged in to a trace file in ADR home.

C. A subset of executed DDL statements is written into an XML file in ADR home. D. A subset of executed DDL statements is written to the DDL log in ADR home.

What is the outcome of the SHUTDOWN ABORT command? A. Pending transactions are committed and the database is closed. B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively. C. Uncommitted transactions are rolled back D. Instance recovery must be requested by the DBA at the next startup

B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively.

Which component resides in the System Global Area (SGA) of a database instance only in shared server connections? A. User Global Area B. Program Global Area C. SQL Query Result Cache D. PL/SQL Function Result Cache

A. User Global Area

Which three statements are true about Enterprise Manager Database Express? (Choose three.) A. It can be used to perform database backup operations. B. It can use the HTTP protocol. C. The same port number is used for multiple Database Express configurations on the same host. D. It can use the HTTPS protocol. E. It is available only when the database is open.

B. It can use the HTTP protocol. D. It can use the HTTPS protocol. E. It is available only when the database is open.

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this? A. Configure the nonstandard buffer cache with a buffer size greater than the size of the default buffer cache. B. Increase the size of the shared pool C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache. D. Configure the RECYCLE buffer cache and alter the tables to use the RECYCLE cache.

C. Configure the KEEP buffer cache and alter the tables to use the KEEP cache.

Your database is open in read/write mode and multiple users are connected to the database instance. You execute the following command: SQL\> ALTER SYSTEM ENABLE RESTRICTED SESSION; What would be the effect on current sessions? A. They are not terminated but may only issue queries. B. They are not affected. C. They are terminated immediately. D. They are terminated after completing the transaction.

B. They are not affected.

You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform. Which method provides the fastest way of achieving this? A. using the DBVERIFY utility B. using direct-path INSERT SQL statements C. using SQL\*Loader D. using RMAN transportable tablespace operation

D. using RMAN transportable tablespace operation

You create a locally managed tablespace ORDERS\_TBS with automatic segment management. You then create the table DAILY\_ORDS\_LST in the ORDERS\_TBS tablespace using the command. CREATE TABLE daily\_ords\_1st(ordno NUMBER, ord\_date DATE) PCTFREE 20; How does the PCTFREE storage parameter influence data storage for this table? A. It allows only 80% of space to be occupied in all data blocks of this table. B. It minimizes row chaining during row insertion. C. It minimizes row migration during existing row data updation. D. It automatically coalesces free space of a data block when it reaches 20% of

A. It allows only 80% of space to be occupied in all data blocks of this table.

What must you use to read data from a table in your database and write it to an external table? A. Use SQL\* LOADER conventional path load. B. Use SQL\* LOADER direct path load. C. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE\_LOADER access driver. D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE\_DATAPUMP access driver.

D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE\_DATAPUMP access driver.

Which two statements are true about initialization parameter files? (Choose two.) A. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log. B. A PFILE must exist for an SPFILE to be created. C. The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE. D. Both the SPFILE and PFILE must always reside on a file system accessible from the database host server. E. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.

A. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log. E. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE.

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.) A. Archived redo log files that have multiple copies in a different archive location B. user-managed backups of data files and control files C. RMAN backups that are obsolete D. flashback logs

C. RMAN backups that are obsolete D. flashback logs

Which statement is true about a database in ARCHIVELOG mode? A. All backups taken prior to switching to ARCHIVELOG mode can be used to perform complete recovery. B. Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode. C. A Fast Recovery Area (FRA) must be configured for the database. D. Full database backups can be performed when the database is opened.

D. Full database backups can be performed when the database is opened.

Which statement is true about profiles? A. Resource limits specified in a profile assigned to a user are always enabled. B. A user can exist without any profile. C. A profile can be assigned only to one user. D. Password management using profiles is always enabled.

D. Password management using profiles is always enabled.

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements? A. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M) B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED C. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases. Examine these commands: Conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING 'orcl2'; What is the outcome of executing these commands in the ORCL1 database? A. ORCL2 is created as a public database link to connect a single session to the SALES schema in the ORCL2 database. B. ORCL2 is created as a shared database link to connect multiple sessions to the SALES schema in the ORCL2 database. C. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database. D. ORCL2 database link creation fails.

C. ORCL2 is created as a private database link to connect to only the SALES schema in the ORCL2 database.

Examine the command: SQL\> CONNECT hr/hr@orcl Which two configurations allow this command to execute successfully? (Choose two.) A. In the tnsnames.ora file, the SERVICE\_NAME value of CONNECT\_DATA should be explicitly suffixed with the domain name. B. The SERVICE\_NAMES initialization parameter should contain the name orcl in the database host. C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host. D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host. E. The TNS\_ADMIN environment variable should be set to orcl on the client.

B. The SERVICE\_NAMES initialization parameter should contain the name orcl in the database host. C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.

Which three statements are true about Oracle Data Pump? (Choose three.) A. Oracle Data Pump export and import operations can be performed to move data across different database releases. B. DBMS\_DATAPUMP PL/SQL packages can be used independent of Data Pump clients. C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object. D. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege. E. Oracle Data Pump export operations invoked from the clients that are connected remotely by using a connection string, create Data Pump files on the client file system.

A. Oracle Data Pump export and import operations can be performed to move data across different database releases. B. DBMS\_DATAPUMP PL/SQL packages can be used independent of Data Pump clients. C. A directory object must exist and a user performing an EXPDP or IMPDP operation must have read and write permission on that directory object.

In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to media failure. In which two recovery scenarios must you use the RESETLOGS option? (Choose two.) A. One control file copy is intact so the spfile is changed to refer to only one copy. B. One control file copy is intact and damaged control file copies have to be restored to the default location. C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually. D. All copies of the control file are damaged and the auto backed up control file is used for recovery. E. One control file copy is intact and damaged control file copies have to be restored to a non-default location.

C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually. D. All copies of the control file are damaged and the auto backed up control file is used for recovery.

Which statement is true regarding the DEFAULT profile? A. The values assigned to the resource limits and password parameters in the default profile can be altered. B. A different DEFAULT profile can be created before each user in a database. C. It can be dropped and recreated. D. it must be explicitly assigned to the user.

A. The values assigned to the resource limits and password parameters in the default profile can be altered.

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. RMAN backups contain only data files. B. The database instance must be shut down to take a user-managed consistent backup. C. Consistent RMAN backups can be taken while the database is open. D. User-managed backups only contain formatted data blocks. E. The database must be in MOUNT state to take consistent RMAN backups.

B. The database instance must be shut down to take a user-managed consistent backup. E. The database must be in MOUNT state to take consistent RMAN backups.

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components? A. PMON B. SMON C. MMNL D. MMAN E. MMON

D. MMAN

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file? A. RBAL B. CKPT C. SMON D. PMON E. MMON F. CTWR G. DBWR

F. CTWR

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.) A. backup pieces B. copies of all parameter files C. trace file generated using BACKUP CONTROLFILE TO TRACE D. control file autobackups

A. backup pieces D. control file autobackups

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS\_PITR\_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.) A. Taking the MASTERTBS tablespace offline B. Dropping the relationship between the tables C. Adding the MASTERTBS tablespace to the recovery set D. Putting the MASTERTBS tablespace in read-only mode

B. Dropping the relationship between the tables C. Adding the MASTERTBS tablespace to the recovery set

You executed the following query: Considering that all the redo logs are available, what information can you derive from the output of the preceding query? A. The time when the last flashback operation in your database was performed B. The time when the first flashback operation in our database was performed C. The approximate time and the lowest system change number (SCN) to which you can flash back your database D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

C. The approximate time and the lowest system change number (SCN) to which you can flash back your database

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.) A. Multiple change tracking files can be created for a database. B. The change tracking file must be created after the first level 0 backup. C. RMAN does not support backup and recovery of the change tracking file. D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

C. RMAN does not support backup and recovery of the change tracking file. D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.) A. It clears all user recycle bins in a database and releases their storage space. B. It writes a list of invalid SYS and SYSTEM object to the registry$sys\_inv\_objs table. C. It evaluates the dependencies of network utility packages. D. It identifies any deprecated and unsupported parameters. E. It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.

B. It writes a list of invalid SYS and SYSTEM object to the registry$sys\_inv\_objs table. C. It evaluates the dependencies of network utility packages. D. It identifies any deprecated and unsupported parameters.

You install Oracle Grid Infrastructure standalone server and issue the following command: crsctl start has Which two existing components get automatically added to the Oracle Restart configuration? (Choose two.) A. Oracle CSSD services B. the database whose instance is running C. Oracle Notification services D. Oracle Healthcheck services E. Oracle Net Listener

A. Oracle CSSD services C. Oracle Notification services

Examine this command executed on a client that is remote from the database server. SQL\> CONNECT hr/hr@orcl Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.) A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files B. An orcl TNS entry must be defined in the client-side tnsnames.ora file C. A service name must be defined to the listener that matches the service name in the orcl TNS entry D. An orcl TNS entry must be defined in the server-side tnsnames.ora file E. The service name orcl must be defined to the listener

B. An orcl TNS entry must be defined in the client-side tnsnames.ora file C. A service name must be defined to the listener that matches the service name in the orcl TNS entry

One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with: 1. RETENTION NOGUARANTEE 2. UNDO\_RETENTION is 12 minutes User SCOTT gets this error after a query on the SALES table has run for more than 15 minutes: ORA-01555: snapshot too old Which three factors taken separately or in some combination might be the cause? (Choose three.) A. An update was made to the SALES table after the query began B. An update to the SALES table was committed after the query began C. A committed delete to the SALES table was made more than 12 minutes before the query began D. An uncommitted update to the SALES table was made more than 12 minutes before the query began E. A committed update to the SALES table was made more than 12 minutes before the query began F. An uncommitted delete to the SALES table was made more than 12 minutes before the query began G. An update was made to the SALES table before the query began

A. An update was made to the SALES table after the query began D. An uncommitted update to the SALES table was made more than 12 minutes before the query began E. A committed update to the SALES table was made more than 12 minutes before the query began

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace? A. STARTUP FORCE B. ALTER TABLESPACE users OFFLINE IMMEDIATE; C. SWITCH DATAFILE ALL; D. ALTER TABLESPACE users OFFLINE NORMAL; E. ALTER TABLESPACE users OFFLINE TEMPORARY;

E. ALTER TABLESPACE users OFFLINE TEMPORARY;

Which two statements are true about SQL\*Loader Express Mode in an Oracle 12c database? (Choose two.) A. It loads data faster than conventional SQL\*Loader B. No data file needs to be specified C. It can load data in parallel D. It loads data more efficiently than conventional SQL\*Loader E. It requires Enterprise Manager Express to be configured

A. It loads data faster than conventional SQL\*Loader C. It can load data in parallel

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.) A. Dynamic Registration by the LREG process B. Dynamic Registration by the SMON process C. Static registration in the listener.ora file using the GLOBAL\_DBNAME parameter D. Dynamic Registration by the PMON process E. Static registration in the listener.ora file using the SERVICE\_NAME parameter

A. Dynamic Registration by the LREG process E. Static registration in the listener.ora file using the SERVICE\_NAME parameter

You ran this command on a source database: $\> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS\_AS\_TABLES=emp\_dept On the target database, you run this command: $\> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS\_AS\_TABLES=emp\_dept Which two statements are true? (Choose two.) A. The expdp operation exports all rows for tables contained in the defining query of the EMP\_DEPT view B. The impdp operation creates separate tables for each table contained in the defining query of the EMP\_DEPT view C. The expdp operation exports all rows that are displayed when querying the EMP\_DEPT view with no filter D. The impdp operation creates EMP\_DEPT as a table E. The expdp operation exports the table definitions for tables that are queried in the EMP\_DEPT view. F. The impdp operation creates EMP\_DEPT as a view

D. The impdp operation creates EMP\_DEPT as a table E. The expdp operation exports the table definitions for tables that are queried in the EMP\_DEPT view.

Which four statements are true about database instance behavior? (Choose four.) A. An idle instance is created when a STARTUP NOMOUNT is successful B. All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state C. The consistency of redo logs and data files is checked when mounting the database D. Redo log files can be renamed in MOUNT state E. An SPFILE can be updated when connected to an idle instance F. Datafiles can be renamed in MOUNT state

C. The consistency of redo logs and data files is checked when mounting the database D. Redo log files can be renamed in MOUNT state E. An SPFILE can be updated when connected to an idle instance F. Datafiles can be renamed in MOUNT state

Examine this command: SQL\> ALTER SYSTEM SET ENABLE\_DDL\_LOGGING=TRUE; Which two statements are true? (Choose two.) A. All data definition language (DDL) statements are written to the control file B. Some DDL statements are written to an XML file in the ADR home C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home D. Some data definition language (DDL) statements are written to the control file E. Some DDL statements are written to a text file in the ADR home F. The Alert Log still contains some DDL statements

B. Some DDL statements are written to an XML file in the ADR home E. Some DDL statements are written to a text file in the ADR home