Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

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

Oracle 1z0-082 Oracle Database Administration I Exam Practice Test

Demo: 21 questions
Total 142 questions
Get 1z0-082 Full Access Download 1z0-082 PDF

Oracle Database Administration I Questions and Answers

Question 1

Which three statements are true about inner and outer joins? (Choose three.)

Options:

A.

A full outer join returns matched and unmatched rows

B.

An inner join returns matched rows

C.

Outer joins can only be used between two tables per query

D.

A full outer join must use Oracle syntax

E.

Outer joins can be used when there are multiple join conditions on two tables

F.

A left or right outer join returns only unmatched rows

Question 2

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

Options:

A.

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

B.

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

C.

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

D.

Partition key columns cannot be dropped.

E.

A DROP COLUMN command can be rolled back

F.

A column that is set to UNUSED still counts towards the limit of 1000 columns per table

Question 3

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

Options:

A.

writing inbound request to the common request queue from all shared server connections

B.

checking for outbound shared server responses on the common outbound response queue

C.

receiving inbound requests from processes using shared server connections

D.

sending each connection input request to the appropriate shared server input queue

E.

broadcasting shared server session responses back to requesters on all connections

F.

sending shared server session responses back to requesters on the appropriate connection

Question 4

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

Options:

A.

WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

B.

WHERE ADD_MONTHS

C.

WHERE TO_XUMBER(start_date - SYSDATE) <= 25

D.

WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

Question 5

Examine the description of the EMPLOYEES table:

Which query is valid?

Options:

A.

SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

B.

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

C.

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

D.

SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Question 6

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

Options:

A.

A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

B.

GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

C.

GLOBAL TEMPORARY TABLE space allocation occurs at session start.

D.

Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

E.

A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.

F.

A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Question 7

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:

Which three statements are true?

Options:

A.

The second rollback command restores the row that was inserted.

B.

The first rollback command leaves the table's 100 original rows locked.

C.

The second rollback command rolls back the rollback to savepoint a command.

D.

The first rollback command leaves the inserted row locked.

E.

The first RollBack command restores the row that was inserted.

F.

The second rollback command restores the 100 rows that were in the table originally.

G.

The first rollback command restores the 100 rows that were in the table originally.

Question 8

Which statement is true about aggregate functions?

Options:

A.

Aggregate functions can be nested to any number of levels

B.

The AVG function implicitly converts NULLS to zero

C.

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

D.

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

Question 9

Which three statements are true about using SQL*Plus?

Options:

A.

It has its own commands that are separate from any SQL statements.

B.

It must be downloaded from the Oracle Technology Network (OTN).

C.

It can run scripts entered at the SQL prompt.

D.

It can run Recovery Manager (RMAN) commands.

E.

It has both command-line and graphical user interfaces (GUI).

F.

It can run scripts passed to it by a shell script.

Question 10

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

Question 11

Which two queries execute successfully?

Options:

A.

SELECT NULLIF(NULL, 100) FROM DUAL;

B.

SELECT COALESCE (100, 'AM FROM DUAL;

C.

SELECT 2TOLLIF(100, 'A') FROM DUAL;

D.

SELECT NULLIF(100,100) FROM DUAL;

E.

SELECT COALESCE(100, NULL, 200) FROM DUAL;

Question 12

Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.

Examine this partial query:

SELECT cust_last_name, cust_credit_limit FROM customers

Which two where conditions give the required result?

A)

B)

C)

D)

E)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

Question 13

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

Options:

A.

It is available only when the database is open

B.

It can be used to perform database recovery

C.

The same port number can be used for Database Express configurations for databases on different hosts

D.

It can be used to switch a database into ARCHIVELOGMODE

E.

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Question 14

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

Options:

A.

COLUMN STORE COMPRESS BASIC

B.

COLUMN STORE COMPRESS ADVANCED

C.

RON STORE COMPRESS BASIC

D.

ROW STORE COMPRESS ADVANCED

Question 15

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

Question 16

Examine this command:

SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT

Which two statements are true?

Options:

A.

The high-water mark (HWM) of orders is adjusted.

B.

Only queries are allowed on ORDERS while the shrink is executing.

C.

Queries and DML statements are allowed on ORDERS while the shrink is executing.

D.

The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.

E.

Dependent indexes become UNUSABLE.

F.

The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.

Question 17

Which three statements are true about roles?

Options:

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.

Question 18

Which three statements are true about Deferred Segment Creation in Oracle databases?

Options:

A.

It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

B.

Sessions may dynamically switch back and forth from deferred to immediate segment creation.

C.

It Is the default behavior for tables and indexes.

D.

It is supported for SYS-owned tables contained in locally managed tablespaces.

E.

Indexes inherit the deferred or immediate segment creation attribute from their parent table

Question 19

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.

Only the EMPLOYEE_ID column is indexed.

Rows exist for employees 100 and 200.

Examine this statement:

Which two statements are true? (Choose two.)

Options:

A.

Employee 100 will have SALARY set to the same value as the SALARY of employee 200

B.

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

C.

Employee 200 will have SALARY set to the same value as the SALARY of employee 100

D.

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

E.

Employees 100 and 200 will have the same JOB_ID as before the update command

F.

Employees 100 and 200 will have the same SALARY as before the update command

Question 20

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”

Question 21

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)

Load More 1z0-082 Questions
Demo: 21 questions
Total 142 questions
Get 1z0-082 Full Access Download 1z0-082 PDF