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:

Exhibit 1.

Exhibit 2.

What will be the result?

1. A. It gives an error because the ALL keyword is not valid
2. B. It gives an error because the GROUP BY clause is not valid
3. C. It executes successfully but does not give the required result
4. D. It executes successfully and gives the required result

Correct Answer: D

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

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

Correct Answer: AC

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

1. A. The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
2. B. The number, but not names, of columns must be identical for all SELECT statements in the query.
3. C. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
4. D. The names and number of columns must be identical for all SELECT statements in the query.
5. E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Correct Answer: AC

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

1. A. It is available only when the database is open
2. B. It can be used to perform database recovery
3. C. The same port number can be used for Database Express configurations for databases on different hosts
4. D. It can be used to switch a database into ARCHIVELOGMODE
5. E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Correct Answer: DE

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

1. A. It must be the value of the SERVICE_NAMES parameter on the client side
2. B. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file
3. C. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file
4. D. It must be the name of the database to whose instance HR wishes to connect
5. E. It must be the name of the server running the database to whose instance HR wishes to connect

Correct Answer: E