| Exam Code/Number: | 1z1-074Join the discussion |
| Exam Name: | Upgrade Oracle DBA 11g or 12c to 12c R2 |
| Certification: | Oracle |
| Question Number: | 75 |
| Publish Date: | Jun 03, 2026 |
|
Rating
100%
|
|
In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?
In TESTDB, U1 has SYSDBA privileges and the password Oracle_4U.
You recreate the password file:
$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5
Examine the command and result:
$ sqlplus u1/Oracle_4U@testdb as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
What can you do to fix this error?
Your CDB has a PDB, EMP_PDB.
You successfully execute these commands as the SYSTEM USER in CDB$ROOT:
Which two statements are true about C##USR1? (Choose two.)
Which three statements are true about the SQL Performance Analyzer? (Choose three.)
You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?
