Free 1z0-082 Exam Braindumps

Examine this command:

Which two statements are true? (Choose two.)

1. A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
2. B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
3. C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
4. D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
5. E. The file is renamed and stored in the same location

Correct Answer: AB

Which two statements are true about UNDO and REDO? (Choose two.)

1. A. The generation of UNDO generates REDO
2. B. DML modifies Oracle database objects and only generates UNDO
3. C. The generation of REDO generates UNDO
4. D. DML modifies Oracle database objects and only generates REDO

Correct Answer: AC

Which three statements are true about the DESCRIBE command? (Choose three.)

1. A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
2. B. It can be used from SQL Developer
3. C. It displays the NOT NULL constraint for any columns that have that constraint
4. D. It can be used to display the structure of an existing view
5. E. It displays all constraints that are defined for each column
6. F. It can be used only from SQL *Plus

Correct Answer: CDF

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

1. A. SELECT NVL(cust_credit_linit * .15, ‘Not Available’) FROM customers;
2. B. SELECT NVL2(cust_credit_linit * .15, ‘Not Available’) FROM customers;
3. C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;
4. D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;
5. E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

Correct Answer: BC

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

1. A. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
2. B. SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;
3. C. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;
4. D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
5. E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Correct Answer: DE