Free 1Z0-082 Exam Questions - Easiest Way for Success

Prepare for the Oracle 1Z0-082 exam questions with our authentic preparation materials, including free 1Z0-082 practice exam questions and answers. TheExamsLab provides all the support you need to succeed in the Oracle Database Administration I 1Z0-082 exam. This dedication to student success is why we have the most satisfied 1Z0-082 certification exam candidates worldwide.

Page: 1 / 29

Total 144 Questions | Updated On: Sep 12, 2024

Add To Cart

Question 1

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

A : All tablespaces may have one or more data files

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

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

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

E : A segment's blocks can be of different sizes

F : A segment might have only one extent

G : Segments can span multiple tablespaces

Answer: A,B,C

Question 2

Which three statements are true about roles?

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

B : Object privileges may not be granted to roles.

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

D : Roles must be password protected.

E : Roles may be granted to roles.

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

Answer: A,B,C

Question 3

Evaluate these commands which execute successfully:

Other-Image-28cf0cb7b-b11d-4b80-bafa-57b0fe4fad71

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

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

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

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

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

E : Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: B,C

Question 4

Examine this SQL statement:

SELECT cust_id, cust_last_name ''Last Name''

FROM customers

WHERE country_id = 10

UNION

SELECT cust_id CUST_NO, cust_last_name

FROM customers

WHERE country_id = 30

Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

A : ORDER BY ''Last Name''

B : ORDER BY 2, 1

C : ORDER BY 2, cust_id

D : ORDER BY CUST_NO

E : ORDER BY ''CUST_NO''

Answer: B,C,D

Question 5

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

A : Oracle Managed Files (OMF)

B : Online table segment shrink

C : Online index segment shrink

D : Automatic data file extension (AUTOEXTEND)

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

Answer: A,D,E

Page: 1 / 29

Total 144 Questions | Updated On: Sep 12, 2024

Add To Cart