Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-082 - Oracle Database Administration I

1z0-082 Exam Dumps - Oracle Database Administration I

Go to page:
Question # 17

You have been tasked to create a table for a banking application.

One of the columns must meet three requirements:

Be stored in a format supporting date arithmetic without using conversion functions

Store a loan period of up to 10 years

Be used for calculating interest for the number of days the loan remains unpaid

Which data type should you use?

A.

INTERVAL YEAR TO MONTH

B.

INTERVAL DAY TO SECOND

C.

TIMESTAMP WITH LOCAL TIMEZONE

D.

TIMESTAMP

E.

TIMESTAMP WITH TIMEZONE

Full Access
Question # 18

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, LNAME DESC

B.

ORDER BY 1, 2

C.

WHERE city LIKE *%AN%*

D.

WHERE city = =%AN%'

E.

WHERE city IN (•%AN%')

F.

ORDER BY last_narae DESC, city ASC

Full Access
Question # 19

You execute this query:

SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’)

What is the result?

A.

It executes successfully but does not return any result

B.

It returns the date for the first Monday of the next month

C.

It generates an error

D.

It returns the date for the last Monday of the current month

Full Access
Question # 20

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

A.

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

B.

The data dictionary is created and maintained by the database administrator

C.

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

D.

Base tables can be queried directly

E.

It is owned by the SYSTEM user

F.

Usernames of all users including database administrators are stored in the data dictionary

Full Access
Question # 21

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

A.

They can be written by server processes

B.

Trace files are written to the Fast Recovery Area (FRA)

C.

They can be written by background processes

D.

All trace files contain error information that require contacting Oracle Support

E.

Trace file names are based on the database name concatenated with a sequential number

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps