Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Database 19c
1z0-082
Oracle Database Administration I Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-082 Premium Access

View all detail and faqs for the 1z0-082 exam

Go to Exam

833 Students Passed

84% Average Score

92% Same Questions

Viewing page 2 out of 5 pages

Viewing questions 11-20 out of questions

Questions # 11:

Which three statements are true about a self join? (Choose three.)

Options:

The ON clause must be used

The query must use two different aliases for the table

It must be an equijoin

It must be an inner join

The ON clause can be used

It can be an outer join

Answer

B, E, F

Questions # 12:

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.

Examine this command:

SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);

Which segment or segments, if any, are created as a result of executing the command?

Options:

T1, an index segment for the primary key, a LOB segment, and a lobindex segment

no segments are created

T1 only

T1 and an index segment created for the primary key only

T1, an index segment for the primary key, and a LOB segment only

Answer

Questions # 13:

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Question # 13

Which statement is true?

Options:

Dynamic service registration cannot be used for this database instance

The LREG process registers services dynamically with the LISTENER_1 listener

LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer

Explanation

The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.

[Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292, , Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292, , , ]

Questions # 14:

In one of your databases, you create a user, HR, and then execute this command:

GRANT CREATE SESSION TO hr WITH ADMIN OPTION;

Which three actions can HR perform? (Choose three.)

Options:

Revoke the CREATE SESSION privilege from other users

Revoke the CREATE SESSION privilege from user HR

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Execute DDL statements in the HR schema

Execute DML statements in the HR schema

Answer

A, C, D

Explanation

[Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224, , , ]

Questions # 15:

Examine this description of the TRANSACTIONS table:

Question # 15

Which two SQL statements execute successfully? (Choose two.)

Options:

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;

SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;

SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;

SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;

Answer

B, D

Questions # 16:

Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

Options:

the first column in the first select of the compound query

the first varchab2 column in the first select of the compound query

the first number column in the first select of the compound query

the first number or varchar2 column in the last select of the compound query

the first column in the last select of the compound query

Answer

Questions # 17:

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

Options:

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

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

receiving inbound requests from processes using shared server connections

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

broadcasting shared server session responses back to requesters on all connections

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

Answer

A, C, F

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168

Questions # 18:

In your data center, Oracle Managed Files (OMF) is used for all databases.

All tablespaces are smallfile tablespaces.

SALES_Q1 is a permanent user-defined tablespace in the SALES database.

Examine this command which is about to be issued by a DBA logged in to the SALES database:

ALTER TABLESPACE sales_q1 ADD DATAFILE;

Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

Options:

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Add the AUTOEXTEND ON clause with NEXT set to 100M.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Answer

B, C

Questions # 19:

Which two statements are true about the PMON background process? (Choose two.)

Options:

It registers database services with all local and remote listeners known to the database instance

It frees resources held by abnormally terminated processes

It records checkpoint information in the control file

It frees unused temporary segments

It kills sessions that exceed idle time

Answer

B, E

Explanation

[Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm, • Performs process recovery when a user process fails – Cleans up the database buffer cache – Frees resources that are used by the user process • Monitors sessions for idle session timeout, , ]

Questions # 20:

View the Exhibit and examine the structure of the PRODUCTS table.

Which two tasks require subqueries? (Choose two.)

Question # 20