Free 1z0-082 Exam Braindumps

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql What will happen upon execution?

1. A. The command succeeds and HR will be connected to the orcl and abc.sql databases
2. B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
3. C. The command fails because the script must refer to the full path name
4. D. The command fails and reports an error because @ is used twice

Correct Answer: B

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

1. A. AUTOEXTEND is possible for the datafile
2. B. It must be bigger than the largest SMALLFILE tablespace
3. C. Additional data files may not be added
4. D. It will be a dictionary-managed tablespace by default
5. E. It will always have a 32K blocksize

Correct Answer: AB

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

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

Correct Answer: AC

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?

1. A. It executes successfully but does not return any result
2. B. It returns the date for the first Monday of the next month
3. C. It generates an error
4. D. It returns the date for the last Monday of the current month

Correct Answer: B

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