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 gathered. B. Statistics collection…
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): Which three are prerequisites for successful execution of the command? A. The import operation must be performed by a user on the…
Which two are true concerning a multitenant container database with three pluggable database? A. All administration tasks must be done to a specific pluggable database. B. The pluggable databases increase patching time. C. The pluggable databases reduce administration effort. D.…
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;…
Examine the query and its output: What might have caused three of the alerts to disappear? A. The threshold alerts were cleared and transferred to d0A_alert_history. B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the…
Which two statements are true? A. A role cannot be assigned external authentication. B. A role can be granted to other roles. C. A role can contain both system and object privileges. D. The predefined resource role includes the unlimited_tablespace…
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB). A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED. B. Use the CREATE DATABASE .…
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…
Which two statements are true about extents? A. Blocks belonging to an extent can be spread across multiple data files. B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk. C. The blocks of a…
You execute the commands: Which two statements are true?(Choose two.) A. The create user command fails if any role with the name Sidney exists in the database. B. The user sidney can connect to the database instance but cannot perform…