You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job's elapsed time? (Choose two.)
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.Which two methods or commands would you use to accomplish this task? (Choose two.)
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 instance4. Starts up the CDB instance using STARTUP OPEN READ WRITEWhich two statements are true about the outcome after running the script? (Choose two.)
You execute the following piece of code with appropriate privileges:User SCOTT has been granted the CREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:1snrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?
Examine the parameters for your database instance:You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario?
