Question 1

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

Options :

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 two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

Options :

A : Duplicates are eliminated automatically by the UNION ALL operator

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

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

D : The output is sorted by the UNION ALL operator

E : NULLS are not ignored during duplicate checking

Answer: A,B

Question 3

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

Options :

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

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

C : Change the character set.

D : Create an additional listener.

E : Create nonstandard block size tablespaces.

Answer: B,C

Question 4

Examine the description of the employees table:

Other-Image-27be966aa-f1d1-485b-934c-16348004fe68

Which query requires explicit data type conversion?

Options :

A :

B :

C :

D :

Answer: A

Question 5

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:

Other-Image-40a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 1.

Other-Image-60a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

Exhibit 2.

Other-Image-80a5dd6cd-84d9-4396-b8cc-2b23c0f0e79e

What will be the result?

Options :

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

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

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

D : It executes successfully and gives the required result

Answer: D

Higher Test Marks with Free Online 1Z0-082 Exam Practice

Buying Options: