Free Oracle 1Z0-082 Exam Dumps Questions & Answers

Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

• A.  ORDER BY 1, 2
• B.  ORDER BY last_narae DESC, city ASC
• C.  WHERE city IN (?AN%')
• D.  WHERE city = =%AN%'
• E.  WHERE city LIKE *%AN%*
• F.  ORDER BY 1, LNAME DESC

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.)

• A.  SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
• B.  SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• C.  SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• D.  SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
• E.  SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

• A.  in the undo tablespace
• B.  in the temporary tablespace
• C.  in the SGA
• D.  in the SYSAUX tablespace
• E.  in the PGA

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

• A.  A RAC database can have instances on separate servers.
• B.  A RAC database must have three or more Instances.
• C.  A RAC database must have two or more instances.
• D.  A RAC database can have one Instance.
• E.  Two RAC databases can share their instances.

Which two statements are true?

• A.  SALES1 is created with 1 row.
• B.  SALES1 is created with 55,000 rows.
• C.  SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.
• D.  SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.
• E.  SALES1 is created with no rows.