This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file?
Examine the command:
SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');
Which statement describes the effect of the above command?
The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?
Examine the command:
SQL>ALTER USR skd ACCOUNT LOCK;
Which two statements are true after the command is executed? (Choose two.)