Oracle

1Z0-082
Oracle Database Administration I
QUESTION & ANSWERS

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
QUESTION: 1

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

Option A : A RAC database can have one Instance.

Option B : A RAC database can have instances on separate servers.

Option C : Two RAC databases can share their instances.

Option D : A RAC database must have three or more Instances.

Option E : A RAC database must have two or more instances.

Correct Answer: A,B

QUESTION: 2

Which compression method is recommended for Direct-Path Insert operations?

Option A : COLUMN STORE COMPRESS BASIC

Option B : COLUMN STORE COMPRESS ADVANCED

Option C : RON STORE COMPRESS BASIC

Option D : ROW STORE COMPRESS ADVANCED

Correct Answer: C

QUESTION: 3

Examine the description of the employees table:

Which query requires explicit data type conversion?

Option A :

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
Option B :

Option C :

Option D :

Correct Answer: A

QUESTION: 4

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

Which three statements are true?

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

Option B : The sales table has five foreign keys.

Option C : A product can have a different unit price at different times.

Option D : A customer can exist in many countries.

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

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

Correct Answer: A,B,C

QUESTION: 5

Which two actions can you perform using DBCA for an existing database?

Option A : Create a template that can be used to clone the database.

Option B : Change the server mode from dedicated to shared, and vice versa.

Option C : Change the character set.

Option D : Create an additional listener.

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
Option E : Create nonstandard block size tablespaces.

Correct Answer: B,C

QUESTION: 6

Which three statements are true about roles?

Option A : All roles granted to a user are set on by default when the user logs in,

Option B : Object privileges may not be granted to roles.

Option C : The SET ROLE statement can disable one or more roles for a session.

Option D : Roles must be password protected.

Option E : Roles may be granted to roles.

Option F : The SET ROLE statement can enable one or more roles for a session.

Correct Answer: A,B,C

QUESTION: 7

Examine this SQL statement:SELECT cust_id, cust_last_name ''Last Name''FROM customersWHERE country_id
= 10UNIONSELECT cust_id CUST_NO, cust_last_nameFROM customersWHERE country_id = 30Identify three
ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

Option A : ORDER BY ''Last Name''

Option B : ORDER BY 2, 1

Option C : ORDER BY 2, cust_id

Option D : ORDER BY CUST_NO

Option E : ORDER BY ''CUST_NO''

Correct Answer: B,C,D

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
QUESTION: 8

Examine the description of the BOOKS table:

The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books
VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL);SAVEPOINT a;DELETE FROM books;ROLLBACK
TO SAVEPOINT a;ROLLBACK;Which two statements are true? (Choose two.)

Option A : The second ROLLBACK command does nothing

Option B : The second ROLLBACK command replays the delete

Option C : The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted
row still to be committed

Option D : The second ROLLBACK command undoes the insert

Option E : The first ROLLBACK command restores the 101 rows that were deleted and commits the
inserted row

Correct Answer: C,D

QUESTION: 9

Which statement is true about aggregate functions?

Option A : Aggregate functions can be nested to any number of levels

Option B : The AVG function implicitly converts NULLS to zero

Option C : Aggregate functions can be used in any clause of a SELECT statement

Option D : The MAX and MIN functions can be used on columns with character data types

Correct Answer: D

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
QUESTION: 10

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Option A : Duplicates are eliminated automatically by the UNION ALL operator

Option B : The number of columns selected in each SELECT statement must be identical

Option C : The names of columns selected in each SELECT statement must be identical

Option D : The output is sorted by the UNION ALL operator

Option E : NULLS are not ignored during duplicate checking

Correct Answer: A,B

QUESTION: 11

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.

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
Exhibit 2.
What will be the result?

Option A : It gives an error because the ALL keyword is not valid

Option B : It gives an error because the GROUP BY clause is not valid

Option C : It executes successfully but does not give the required result

Option D : It executes successfully and gives the required result

Correct Answer: D

QUESTION: 12

Which two statements are true about single row functions? (Choose two.)

Option A : MOD : returns the quotient of a division operation

Option B : FLOOR : returns the smallest integer greater than or equal to a specified number

Option C : TRUNC : can be used with NUMBER and DATE values

Option D : CONCAT : can be used to combine any number of values

Option E : CEIL : can be used for positive and negative numbers

Correct Answer: A,C

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
QUESTION: 13

Which three Oracle database space management features will work with both Dictionary and Locally
managed tablespaces? (Choose three.)

Option A :

Oracle Managed Files (OMF)

Option B :

Online table segment shrink

Option C :

Online index segment shrink

Option D :

Automatic data file extension (AUTOEXTEND)

Option E :

Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Correct Answer: A,D,E

QUESTION: 14

Evaluate these commands which execute successfully:

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Option A : If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for
rows inserted into ORD_ITEMS

Option B : Any user inserting rows into table ORD_ITEMS must have been granted access to sequence
ORD_SEQ

Option C : Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted
into ORD_ITEMS and no explicit value is given for ORD_NO

Option D : Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Option E : Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Correct Answer: B,C

QUESTION: 15

Which three statements are true concerning logical and physical database structures? (Choose three.)

Option A : All tablespaces may have one or more data files

Option B : The extents of a segment must always reside in the same datafile

Option C : A smallfile tablespace might be bigger than a bigfile tablespace

Option D : A segment can span multiple data files in some tablespaces

https://www.dumps4less.com/1Z0-082-dumps-pdf.html
Option E : A segment's blocks can be of different sizes

Option F : A segment might have only one extent

Option G : Segments can span multiple tablespaces

Correct Answer: A,B,C

https://www.dumps4less.com/1Z0-082-dumps-pdf.html