Examine these statements executed in the PROD1 database: Which statements are audited?
A. only the CREATE USER statement
B. only the ALTER SYSTEM statements
C. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES
D. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement
E. all the statements
The ORCL CDB has a PDB, ORCL_PDB. Examine these parameters in ORCL:
Examine these parameters in ORCL_PDB:
You switch to ORCL_PDB and plan to execute these commands:
What will be the outcome?
A. SGA_TARGET is set to 600M. The other values remain unchanged in both ORCL and ORCL_PDB.
B. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. The other values remain unchanged in both ORCL and ORCL_PDB.
C. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to 200M in ORCL.
D. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
E. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.
SGA_TARGET size is changed to 600 M.
Examine this parameter:
Examine these commands:
Which three are true after executing these commands? (Choose three.)
A. All statements executed by SH are captured and included in a baseline.
B. Statements executed by both SH and SYS may be captured and included in a baseline.
C. Only statements executed by SYS are captured and included in a baseline.
D. Only statements executed by SH containing the "TEST_ONLY" string are excluded from capture.
E. Statements executed by any user containing the "TEST_ONLY" string are excluded from capture.
F. Only repeatable statements executed by SYS and SH are considered for baselines.
You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB. You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:
Where should you execute these statements?
A. All the statements should be executed in the application root.
B. All the statements should be executed in the application seed.
C. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.
D. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.
E. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.
In which two situations does the INHERIT ANY PRIVILIGES privilege regulate the privileges used?
A. when a user creates a new user
B. when a user performs a GRANT or REVOKE operation
C. when a user queries a BEQUEATH CURRENT_USER view that references an invoker's right procedure
D. when a user runs a procedure created with invoker's right
E. when a user runs a procedure created with definer's right
You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events.
Which four might be reasons for these? (Choose four.)
A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.
B. The buffer cache is undersized.
C. Cursors are closed explicitly after each execution.
D. A large number of connected user sessions are idle.
E. DBWR is not writing the dirty buffers fast enough.
F. Blocks are ageing out of the buffer cache frequently.
G. Too many sort operations are being performed.
In which situation can the optimizer choose a hash join?
A. when a non-equijoin is used and the join column in at least one of the tables is a primary key
B. when a non-equijoin is used and the join column for both tables is a primary key
C. when a non-equijoin is used between a table and a sorted hash cluster
D. when an equality operator is used
E. when any self-join is done
U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace,
TBS_CMP with default compression for query low.
You execute commands:
Which three statements are true? (Choose three.)
A. The primary key constraints on T1 are dropped
B. T1 is in the TBS_UNCMP tablespace
C. T1 is in the TBS_CMP tablespace
D. T1 is in compressed format
E. T1 is in uncompressed format
F. All indexes on T1 remain valid
You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:
The SCOTT user has the SELECT privilege on HR.EMP.
Which statement is true about queries by non-DBA users with the SELECT privilege on HR.EMP?
A. All their queries display blanks for LAST_NAME and the true contents of the SALARY column.
B. Only SCOTT'S queries display the true contents of the SALARY column and blanks for LAST_NAME.
C. All their queries display blanks for LAST_NAME and zeroes for SALARY.
D. Only SCOTT'S queries display the true contents of the SALARY and LAST_NAME columns.
E. Only SCOTT'S queries display zero for SALARY and the true contents of the LAST_NAME column.
Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)
A. subpartitions
B. clustered tables
C. materialized views
D. index-organized tables
E. heap tables
F. any SYS owned objects
