You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.You can no longer monitor it
• B.You can reattach to it and monitor it
• C.It is paused and can be resumed
• D.It continues to run in the background
• E.It terminates

Comment: *

Name: *

Email: *

Verification: *

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

• A.SELECT &col1, &col2FROM &&tableWHERE &condition;
• B.SELECT &&col1, &&col2FROM &tableWHERE &&condition;
• C.SELECT '&&col1', '&&col2'FROM &tableWHERE '&&condition' = '&cond';
• D.SELECT &col1, &col2FROM "&table"WHERE &condition;
• E.SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

• A.They can be written by server processes
• B.Trace files are written to the Fast Recovery Area (FRA)
• C.They can be written by background processes
• D.All trace files contain error information that require contacting Oracle Support
• E.Trace file names are based on the database name concatenated with a sequential number

Comment: *

Name: *

Email: *

Verification: *

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• B.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• C.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• D.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• E.Employees 100 and 200 will have the same SALARY as before the update command
• F.Employees 100 and 200 will have the same JOB_ID as before the update command

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

• A.Trace files are written to the Fast Recovery Area (FRA)
• B.All trace files contain error information that require contacting Oracle Support
• C.They can be written by background processes
• D.Trace file names are based on the database name concatenated with a sequential number
• E.They can be written by server processes

Comment: *

Name: *

Email: *

Verification: *