Instant Access Oracle.1Z0-082.v2022-06-18.q110 Actual Practice Test Engine for Free (Page 23)

Question 106

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.It is paused and can be resumed
B.It terminates
C.It continues to run in the background
D.You can reattach to it and monitor it
E.You can no longer monitor it

Question 107

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

A.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
B.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
C.Display the minimum PROD_LIST_PRICE for each product status
D.Display the total number of products supplied by supplier 102 which have a product status of obsolete
E.Display suppliers whose PROD_LIST_PRICE is less than 1000

Question 108

What is true about non-equijoin statement performance? (Choose two.)

A.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
B.The BETWEEN condition always performs better than using the >= and <= conditions
C.The join syntax used makes no difference to performance
D.The BETWEEN condition always performs less well than using the >= and <= conditions
E.Table aliases can improve performance

Question 109

Which three statements are true about Oracle synonyms? (Choose three.)

A.A synonym cannot be created for a PL/SQL package
B.A synonym can be available to all users
C.A SEQUENCE can have a synonym
D.A synonym created by one user can refer to an object belonging to another user
E.Any user can drop a PUBLIC synonym

Question 110