Free Access Oracle.1Z0-082.v2023-03-31.q49 Practice Test (Page 7)

Question 26

Which three statements are true about using SQL*Plus?

A.It must be downloaded from the Oracle Technology Network (OTN).

B.It can run Recovery Manager (RMAN) commands.

C.It can run scripts entered at the SQL prompt.

D.It has both command-line and graphical user interfaces (GUI).

E.It can run scripts passed to it by a shell script.

F.It has its own commands that are separate from any SQL statements.

Question 27

View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

A.A product can have a different unit price at different times.

B.A customer can exist in many countries.

C.The sales table has five foreign keys.

D.The statement will fall if a row already exists in the sales table for product 23.

E.The statement will execute successfully and a new row will be inserted into the sales table.

F.The statement will fail because a subquery may not be contained in a values clause.

Question 28

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A.The online redo logs are opened

B.The online data files are opened

C.The alert log records the execution details

D.The Oracle background processes are started

E.The initialization parameter file is read

F.The control file is read

Question 29

In which three situations does a new transaction always start? (Choose three.)

A.when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

B.when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

C.when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

E.when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

F.when issuing a DML statement after a DML statement failed in the same session

Question 30

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement: