1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-082
  5. Oracle Database Administration I Questions and Answers

Pass the Oracle Oracle Database 19c 1z0-082 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 3 out of 5 pages
Viewing questions 21-30 out of questions
Questions # 21:

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Options:
A.

Data block headers contain their own Data Block Address (DBA)

B.

A table row piece can be chained across several database blocks

C.

Multiple row pieces from the same row may be stored in different database blocks

D.

Multiple row pieces from the same row may be stored in the same block

E.

Data block free space is always contiguous in the middle of the block

F.

Index block free space is always contiguous in the middle of the block

Questions # 22:

Which three statements are true about the DESCRIBE command? (Choose three.)

Options:
A.

It displays the PRIMARY KEY constraint for any column or columns that have that constraint

B.

It can be used from SQL Developer

C.

It displays the NOT NULL constraint for any columns that have that constraint

D.

It can be used to display the structure of an existing view

E.

It displays all constraints that are defined for each column

F.

It can be used only from SQL*Plus

Questions # 23:

Which three activities are recorded in the database alert log? (Choose three.)

Options:
A.

Data Definition Language (DDL) statements

B.

non-default database parameters

C.

block corruption errors

D.

deadlock errors

E.

session logins and logouts

Questions # 24:

You need to calculate the number of days from 1st January 2019 until today.

Dates are stored in the default format of DD-MON-RR.

Which two queries give the required output? (Choose two.)

Options:
A.

SELECT TO_CHAR(SYSDATE,‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL;

B.

SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL;

C.

SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL;

D.

SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL;

E.

SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL;

Questions # 25:

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

Options:
A.

The Oracle Net Configuration Assistant is only used when running the Oracle installer

B.

Oracle Net Manager can be used to centrally configure listeners on any database server target

C.

The lsnrctl utility requires a listener.ora file to exist before it is started

D.

Oracle Net Manager can be used to locally configure naming methods on a database server

E.

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

F.

Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

Questions # 26:

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

Options:
A.

Tablespace free space can be viewed in V$TABLESPACE

B.

V$TABLESPACE displays information that is contained in the controlfile about tablespaces

C.

V$TABLESPACE displays information about tablespaces contained in the data dictionary

D.

Tablespace free space can be viewed in DBA_TABLESPACES

E.

A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Questions # 27:

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

Options:
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”

Questions # 28:

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

Options:
A.

The CURRENT_TIMESTAMP function returns data without time zone information

B.

A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

C.

A TIMESTAMP data type column contains information about year, month, and day

D.

The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

E.

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Questions # 29:

Examine this command:

Question # 29

Which two statements are true? (Choose two.)

Options:
A.

DML may be performed on tables with one or more extents in this data file during the execution of this command.

B.

The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C.

The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

D.

If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

E.

The file is renamed and stored in the same location

Questions # 30:

Which three are types of segments in an Oracle Database? (Choose three.)

Options:
A.

undo

B.

index

C.

stored procedures

D.

sequences

E.

tables

F.

clusters

Viewing page 3 out of 5 pages
Viewing questions 21-30 out of questions