OE_ADMIN roles exist and are granted system privileges. You execute the
Command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin;
Which statement is True?
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
Or OE_ADMIN role.
It fails because the command does not specify when the unified audit policy
Should be enforced.
It succeeds and starts capturing only successful SQL statements for all users
Who have either the specified privileges or roles granted to them.
It fails because system privileges cannot be granted with roles in the same Audit policy.
Table exists.
You successfully execute these commands: SQL> CREATE
AUDIT POLICY sales_pol ACTIONS select on sh.sales; SQL> AUDIT POLICY
Sales_pol; Which statement is true about SALES_POL?
It is enabled for all users having SELECT privilege on SH.SALES.
Only successful queries of SH.SALES are written to the audit trail.
It is only enabled for user SH.
Audit records are always stored in an external audit file.
Oracle_home_path –destinationhome Oracle_home_path
For which two purposes can you use this command? (Choose two.)
Two.)
The Oracle Database time model should be used to find the database and
Instance areas most in need of tuning.
Tuning activities should stop once the user is satisfied with performance.
Tuning activities should stop once agreed service levels for performance have
Been met.
The database instance memory should always be tuned before tuning any file
Systems.
SQL statements should always be tuned before tuning any file systems.
The alert log should be used to find the database and instance areas most in
Need of tuning.
Database. You want to know what caused this performance difference.
Which method or feature should you use?
Database Replay
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
Active Session History (ASH) report
SQL Performance Analyzer
You use RMAN with a recovery catalog to back up your database to media and the
Database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process.
You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this? choose one
by using the RMAN switch command to set the new location for the data files
by using the RMAN duplicate command with nofilenamecheck to recover the
Database to the new host
by using the RMAN duplicate command with dbid and set new name for
Tablespace to recover the database to the new host
by creating a new database in the new host, and then using the RMAN recover
Command
Media management interface (MMI).
Which two are true about the use of
The RMAN MMI?
You can use it to create proxy copies for database files.
You can use it to create proxy copies for entire file systems.
You can use it to create image copies for entire file systems.
You can use it to create image copies for database files.
Use Flashback Database. Which two features or parameters manage space
Availability in the fast recovery area?
Container database (CDB) that contains pluggable databases (PDBs).
Examine the query and its output:
SQL> SELECT * FROM v$PWFILE_users;
USERNAME
SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
---------------------------------------------------------------------
---
SYS
TRUE TRUE
FALSE
FALSE
FALSE
FALSE
0
Which two tasks must you perform to add users with the SYSBACKUP,
SYSDG, and SYSKM prileges to the password file?
Database has significantly degraded. Sometimes you are not able to connect
To the instance because it hangs. You do not want to restart the database
Instance. How can you detect the cause of the degraded performance?
Enable Memory Access Mode, which reads performance data from SGA.
Use emergency monitoring to fetch data directly from SGA for analysis.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information
From the latest Automatic Workload Repository (AWR) snapshots.
Use Active Session History (ASH) data and hang analysis in regular
Performance monitoring,
Database. You want to know which change caused this performance
Difference. Which method or feature should you use?
Compare Period ADDM report
AWR Compare Period report
Active Session History (ASH) report
Taking a new snapshot and comparing it with a preserved snapshot.
TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using
Information Lifecycle Management (ILM) to automate data movement?
Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ;
Which three are true about PDB1?
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)
CDB1 and CDB2 must be in shared undo mode.
A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
Cloning HR_ROOT automatically clones HR_PDB1.
The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.
With two application PDBs and an application seed.No changes have been
Made to the standard PDB$SEED.How many default temporary tablespaces
Can be assigned in the CDB?
six
seven
five
eight
Database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG,
And SYSKM privilege to the password file?
Assign the appropriate operating system groups to SYSBACKUP, SYSDG,
SYSKM.
Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege
And the FORCE argument set to No.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege,
And FORCE arguments set to Yes.
Re-create the password file in t he Oracle Database 12c format.
我来回答: