Question 71
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?
Which two are possible if table updates are performed which affect the invisible index columns?
Question 72
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?
Question 73
You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script? (Choose two.)
Question 74
A senior DBA asked you to execute the following command to improve performance:
You checked the data in the SUBSCRIBE_LOGtable and found that it is a large table containing one million rows.
What could be a reason for this recommendation?
You checked the data in the SUBSCRIBE_LOGtable and found that it is a large table containing one million rows.
What could be a reason for this recommendation?
Question 75
Identify two situations in which the alert log file is updated.