You execute the following PL/SQL:
Which two statements are true? (Choose two.)
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 accessed.
B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
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.
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:
Which two statements are true? (Choose two.)
A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
C. The command will, create a common user whose description is contained in the root and each PDB.
D. The schema for the common user C # # A_ADMIN can be different in each container.
E. The command will create a user in the root container only because the container clause is not used.
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output? (Choose three.)
A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
C. The C # # A_ADMIN user can perform wallet operations.
D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
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.
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)
A. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
B. You cannot have multiple SQL *Loader data files.
C. If no data file is specified, it assumes the data file to be
D. You can have multiple bad files created when loading in parallel.
E. You can selectively load rows into a table based on a filter.
The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?
A. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and
3:00 PM.
B. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
C. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.
D. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.
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
In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)
A. when free space in a locally managed tablespace falls below a specified percentage
B. when the number of logons per second exceeds a specific value
C. when a resumable statement is suspended
D. when the total number of locked user account exceeds a specific value
E. when the total number of logons exceeds a specific value
F. when free space in a dictionary managed tablespace falls below a specified percentage
Examine this command.
Now examine these statements: Which three are true about the result of processing the last statement? (Choose three.)
A. The parameter is modified in memory and in the parameter file.
B. The modification persists across instance checkpoint.
C. The parameter is modified in the parameter file only.
D. The parameter is modified in memory only.
E. The modification persists across a SHUTDOWN IMMEDIATE command.
F. The modification does not persist across a SHUTDOWN TRANSACTIONAL command.
A database runs in NOARCHIVELOG mode.
Backup scheduling for this database must be automated before upgrading to a new version of the
database.
Which two tools or utilities can do this? (Choose two.)
A. Oracle Enterprise Manager Database Express (EM Express)
B. Database Upgrade Assistant (DBUA)
C. SQL Developer
D. Database Configuration Assistant (DBCA)
E. Oracle Enterprise Manager Cloud Control
