Question 66
You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?
Question 67
Choose three. Which three are true about the FLASHBACK DATABASE feature?
Question 68
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.
Question 69
RMAN is connected to a target database instance and an auxilary instance.
You execute 3625the command:
RMAN> DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE SECTION SIZE 1G;
What is the outcome?
You execute 3625the command:
RMAN> DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE SECTION SIZE 1G;
What is the outcome?
Question 70
Which three are true about Automatic Workload Repository (AWR) snapshots?