New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

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

Page: 1 / 14
Total 142 questions

Oracle Database Administration I Questions and Answers

Question 1

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

Options:

A.

the first column in the first select of the compound query

B.

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

C.

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

D.

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

E.

the first column in the last select of the compound query

Question 2

Which statement is true about the INTERSECT operator used in compound queries?

Options:

A.

Multiple INTERSECT operators are not possible in the same SQL statement

B.

It processes NULLs in the selected columns

C.

INTERSECT is of lower precedence than UNION or UNION ALL

D.

It ignores NULLs

Question 3

Examine this description of the TRANSACTIONS table:

Question # 3

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

Options:

A.

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

B.

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

C.

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

D.

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

E.

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

Question 4

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 5

The customers table has a cust_last_name column of data type varchar2.

The table has two rows whose "jst_last_name values are Andersen and Ausson.

Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

Options:

A.

SELECT REPLACE FROM customers;

B.

SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

C.

SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;

D.

SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

Question 6

You execute this command:

Question # 6

During the export operation, you detach from the job by using CTRL+C and then execute this command:

Export> STOP_JOB=immediate

Are you sure you wish to stop the job ([yes]/no): yes

Which two statements are true about the job? (Choose two.)

Options:

A.

You can no longer monitor it

B.

You can reattach to it and monitor it

C.

It is paused and can be resumed

D.

It continues to run in the background

E.

It terminates

Question 7

Evaluate these commands which execute successfully:

Question # 7

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

Options:

A.

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

B.

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

C.

Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO

D.

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E.

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Question 8

Which three statements are true about Oracle synonyms? (Choose three.)

Options:

A.

A synonym cannot be created for a PL/SQL package

B.

A synonym can be available to all users

C.

A SEQUENCE can have a synonym

D.

A synonym created by one user can refer to an object belonging to another user

E.

Any user can drop a PUBLIC synonym

Question 9

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:

A.

Revoke the CREATE SESSION privilege from other users

B.

Revoke the CREATE SESSION privilege from user HR

C.

Log in to the database instance

D.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

E.

Execute DDL statements in the HR schema

F.

Execute DML statements in the HR schema

Question 10

You currently have an active transaction in your session and have been granted select access to vstransaction.

Question # 10

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

Options:

A.

after successfully executing a commit or rollback followed by a select statement

B.

after successfully executing a create table as select statement followed by a select for update statement

C.

after successfully executing a commit or rollback followed by a DML statement

D.

after successfully executing a create table statement followed by a create index statement

E.

after successfully executing a DML statement following a failed DML statement

F.

after successfully executing a truncate statement followed by a DML statement

Question 11

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.

The variables used in your query are never undefined in your session.

Which query can be used?

Options:

A.

SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

B.

SELECT &col1, &col2FROM &&tableWHERE &condition;

C.

SELECT &col1, &col2FROM “&table”WHERE &condition;

D.

SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

E.

SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Question 12

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

Options:

A.

A single database instance can support connections for multiple service names.

B.

A service name is created by a listener.

C.

A single connection string can refer to multiple database instances.

D.

A connection string including a service name must be defined in the cnsnames.ora file.

E.

A connection string must include the SID of a database Instance.

F.

Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

Question 13

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

Options:

A.

An undo segment may be used by multiple transactions simultaneously

B.

Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

C.

Undo segments have a minimum of three extents

D.

Undo segments can extend when a transaction fills the last extent of the undo segment

E.

A single transaction may use multiple undo segments simultaneously

F.

Undo segments must be stored in a BIGFILE tablespace

G.

Undo segments must be stored in a SMALLFILE tablespace

Question 14

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

Options:

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

Question 15

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

Options:

A.

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

B.

SYSDATE can be queried only from the DUAL table

C.

CURRENT_DATE returns the current date and time as per the session time zone

D.

SYSDATE can be used in expressions only if the default date format is DD-MON-RR

E.

SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

F.

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Question 16

Your database instance is started with an SPFILE.

A PFILE is also available. You execute this command:

ALTER SYSTEM SET DB_CACHE_SIZE=100K;

Where Is the value changed?

Options:

A.

in the SPFILE, SPFILE, and memory

B.

in the SPFILE and in memory

C.

only In the SPFILE

D.

in the SPFILE and SPFILEc

E.

only in memory

Question 17

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.

Each database has a tnsnames.ora file defining DALLAS_DB as a service name.

Examine this command:

CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’;

How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

Options:

A.

as SCOTT in DALLAS_DB

B.

as SCOTT in BOSTON_DB

C.

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

D.

as SYS in both the databases

E.

as SCOTT in both the databases

Question 18

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Options:

A.

Connect Time Failover requires the use of Transparent Application Failover (TAF)

B.

Source Routing requires the use of a name server

C.

Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

D.

Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

E.

Load Balancing requires the use of a name server

F.

Connect Time Failover requires the connect string to have two or more listener addresses configured

Question 19

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 20

Which three statements are true about the Automatic Diagnostic Repository (ADR)?

Options:

A.

It Is held Inside an Oracle database schema.

B.

The ADR base is specified In the diagnostic_dest database parameter.

C.

It is only used for Oracle Database diagnostic information.

D.

It is a file-based repository held outside any database.

E.

It can be used for problem diagnosis of a database when that database's instance is down.

Question 21

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

Page: 1 / 14
Total 142 questions