IT Certification Exam Questions & Answers

QUESTION 65
Which statement is true regarding the default behavior of the order by clause?

QUESTION 66
After implementing full Oracle Data Redaction, you change the default value for the NUMBERdata type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?

QUESTION 67
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

QUESTION 68
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be used to back up only the PDB1 pluggable database? (Choose two.)

QUESTION 69
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

QUESTION 70
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
(Choose three.)

QUESTION 71
Which three statements are true about using flashback database in a multitenant container database (CDB)?

QUESTION 72
Which three are true about the large pool for an Oracle database instance that supports shared server connections? (Choose three.)

QUESTION 73
Identify the category of recommendation that can be implemented automatically by the Automatic SQL Tuning Advisor.

QUESTION 74
What are three purposes of the RMAN “FROM” clause?

QUESTION 75
What are three purposes of the RMAN “FROM” clause?

QUESTION 76
Examine these two statements:

Which three are true about the MRKT tablespace?

QUESTION 77
In your Database, the TBS PERCENT USED parameter is set to 60 and the 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? (Choose two.)

QUESTION 78
Your multitenant container database (CDB) contains two pluggable databases (PDBs). Which three tools can be used to add a new PDB to the CDB?

QUESTION 79
Which three statements are true about Flashback Database?

QUESTION 80
You must track all transactions that modify certain tables in the sales schema for at least
three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

QUESTION 81
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2′
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

QUESTION 82
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

QUESTION 83
What is the result of executing a TRUNCATE TABLE command on a table that hasFlashback Archivingenabled?

QUESTION 84
Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

QUESTION 85
Which three functions are performed by the SQL Tuning Advisor?

QUESTION 86
Which two statement is true concerning dropping a pluggable database (PDB)?

QUESTION 87
While investigating a possible security breach, you realized that some audit records were not retrieved when the unified_audit_trail view was queried.
How can you ensure that all available audit records are returned when the audit trail is queried?