QUESTION NO: 1
You opened the encryption wallet and then Issued the following command:
SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secureOI .dbf SIZE 150M ENCRYPTION USING '3DES1681 DEFAULT STORAGE(ENCRYPT);
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?
You opened the encryption wallet and then Issued the following command:
SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secureOI .dbf SIZE 150M ENCRYPTION USING '3DES1681 DEFAULT STORAGE(ENCRYPT);
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?
Correct Answer: D
Vote an answer
QUESTION NO: 2
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
Correct Answer: C,E
Vote an answer
QUESTION NO: 3
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
Correct Answer: C,D
Vote an answer
QUESTION NO: 4
In which two aspects does hot patching differ from conventional patching? (Choose two.)
In which two aspects does hot patching differ from conventional patching? (Choose two.)
Correct Answer: A,E
Vote an answer
QUESTION NO: 5
Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11 .so_stub with libodm11 .so.
Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11 .so_stub with libodm11 .so.
Correct Answer: B
Vote an answer
QUESTION NO: 6
You need to create a partitioned table to store historical data and you Issued the following command:
CREATE TABLE purchas_interval
PARTITION BY RANGE (time_id)
INTERVAL (NUMTOYMINTERVAL(1 ,'month1)) STORE IN (tbs1 ,tbs2,tbs3)
PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005I, 'dd-mm-yyyy')),
PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007', 'dd-mm-yyyy')))
AS
SELECT *
FROM purchases
WHERE time_id < TO_DATE('1-1-2007'l'dd-mm-yyyy');
What is the outcome of the above command?
You need to create a partitioned table to store historical data and you Issued the following command:
CREATE TABLE purchas_interval
PARTITION BY RANGE (time_id)
INTERVAL (NUMTOYMINTERVAL(1 ,'month1)) STORE IN (tbs1 ,tbs2,tbs3)
PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005I, 'dd-mm-yyyy')),
PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007', 'dd-mm-yyyy')))
AS
SELECT *
FROM purchases
WHERE time_id < TO_DATE('1-1-2007'l'dd-mm-yyyy');
What is the outcome of the above command?
Correct Answer: C
Vote an answer
QUESTION NO: 7
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
Correct Answer: C
Vote an answer
QUESTION NO: 8
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)
Correct Answer: A,D
Vote an answer
QUESTION NO: 9
View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
Correct Answer: D
Vote an answer