NEW QUESTION 1
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B. It fails and reports an error because the CONTAINER=ALL clause is not use
• C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Answer: A

NEW QUESTION 2
Which two are prerequisites for performing a flashback transaction?

• A. Flashback Database must be enable
• B. Undo retention guarantee for the database must be configure
• C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D. Supplemental logging must be enable
• E. Recycle bin must be enabled for the database.
• F. Block change tracking must be enabled tor the database.

Answer: CD

NEW QUESTION 3
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

• A. It collects data from SGA and compares it with a preserved snapshot.
• B. It collects data from SGA, analyzes it, and provides a report.
• C. It collects data from SGA and compares it with the latest snapshot.
• D. It collects data from both SGA and PGA, analyzes it, and provides a report.

Answer: B

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

• A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
• B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
• C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
• D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
• E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
• F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Answer: ACE

NEW QUESTION 5
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B. Run the Automatic Workload Repository Monitor (ADDM).
• C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Answer: D

NEW QUESTION 6
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

• A. Thread creation must be routed through a dispatcher process
• B. The local listener may spawn a now process and have that new process create a thread
• C. Each Oracle process runs an SCMN threa
• D. Each multithreaded Oracle process has an SCMN threa
• E. The local listener may pass the request to an existing process which in turn will create a threa

Answer: ADE

NEW QUESTION 7
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?

• A. RMAN CONVERT command
• B. Data Pump Export and import
• C. Conventional Export and Import
• D. The BACKUP AS COPY DATABASE . . . command of RMAN
• E. DBMS_FILE_TRANSFER with transportable tablespace

Answer: AD

NEW QUESTION 8
Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?

• A. An EMP table is created if a table does not exis
• B. Otherwise, if the EMP table is appended with the loaded dat
• C. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• D. The SQL* Loader operation fails because no record terminators are specifie
• E. Field names should be the first line in the both the SQL* Loader data files.
• F. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Answer: ABE

NEW QUESTION 9
Which three statements are true concerning the multitenant architecture?

• A. Each pluggable database (PDB) has its own set of background processes.
• B. A PDB can have a private temp tablespace.
• C. PDBs can share the sysaux tablespace.
• D. Log switches occur only at the multitenant container database (CDB) level.
• E. Different PDBs can have different default block sizes.
• F. PDBs share a common system tablespace.
• G. Instance recovery is always performed at the CDB level.

Answer: BDG

NEW QUESTION 10
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

• A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
• B. It succeeds only if memory is available from the autotuned components if SG
• C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: D

NEW QUESTION 11
You execute the following PL/SQL:

Which two statements are true?

• A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accesse
• B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accesse
• C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Answer: AD

NEW QUESTION 12
Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A. All database operations performed by the impdp command are logge
• B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logge
• C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logge
• D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logge

Answer: C

NEW QUESTION 13
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’,
‘false’);
Which three statements are true about the effect of this command?

• A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathere
• B. Statistics collection is not done for the CUSTOMERS table when database stats are gathere
• C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
• D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Answer: CDE

NEW QUESTION 14
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

• A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically starte
• B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still starte
• C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Answer: B

NEW QUESTION 15
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

• A. None of the data definition language (DDL) statements are logged in the trace file.
• B. Only DDL commands that resulted in errors are logged in the alert log file.
• C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
• D. Only DDL commands that resulted in the creation of new database files are logge

Answer: A

NEW QUESTION 16
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

• A. They are able to perform only queries.
• B. They are not affected and continue to function normally.
• C. They are terminated and the active transactions are rolled back.
• D. They are not allowed to perform any operations until the listener LISTENER is starte

Answer: B

NEW QUESTION 17
In which two scenarios do you use SQL* Loader to load data?

• A. Transform the data while it is being loaded into the database.
• B. Use transparent parallel processing without having to split the external data first.
• C. Load data into multiple tables during the same load statement.
• D. Generate unique sequential key values in specified columns.

Answer: CD

NEW QUESTION 18
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B. All DDL commands are logged in the alert log file.
• C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D. Only DDL commands that resulted in the creation of new segments are logge
• E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Answer: C