New Year Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

1z0-082 Questions and Answers

Question # 6

Which two statements are true about substitution variables?

A.

A substitution variable prefixed with & always prompts only once for a value in a session.

B.

A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

C.

A substitution variable can be used only in a select statement.

D.

A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

E.

A substitution variable can be used with any clause in a select statement.

F.

A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

Full Access
Question # 7

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

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

Full Access
Question # 8

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?

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

Full Access
Question # 9

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?

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

Full Access
Question # 10

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 # 11

You execute this command:

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

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

Full Access
Question # 12

Which three statements are true about sequences in a single instance Oracle database?

A.

Sequences can always have gaps.

B.

A sequence can Issue duplicate values.

C.

A sequence's unallocated cached values are lost if the instance shuts down.

D.

Two or more tables cannot have keys generated from the same sequence.

E.

A sequence can only be dropped by a DBA.

F.

A sequence number that was allocated can be rolled back if a transaction fails.

Full Access
Question # 13

Examine the description of the product_details table:

Which two statements are true?

A.

PRODUCT _ic can be assigned the PRIMARY KEY constraint.

B.

PRODUCT _price contains the value zero by default if no value is assigned to it.

C.

PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.

D.

EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.

E.

PRODUCT_NAKE cannot contain duplicate values.

F.

EXPIRY_ DATE cannot be used in arithmetic expressions.

Full Access
Question # 14

Examine this command:

CREATE UNDO TABLESPACE undotbs01

DATAFILE ‘undotbs_01.dbf’

SIZE 100M

AUTOEXTEND ON;

Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

A.

Add the SEGMENT SPACE MANAGEMENT AUTO clause

B.

Set UNDO_TABLESPACE to UNDOTBS01

C.

Add the NOLOGGING clause

D.

Make certain that the database operates in automatic undo management mode

E.

Add the ONLINE clause

Full Access
Question # 15

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

A.

It can be accessed only by the SYS user

B.

It consists of a single row and single column of VARCHAR2 data type

C.

It can display multiple rows but only a single column

D.

It can be used to display only constants or pseudo columns

E.

It can be accessed by any user who has the SELECT privilege in any schema

F.

It can display multiple rows and columns

Full Access
Question # 16

You start your database instance in NOMOUNT state. Which two actions are performed?

A.

The control files are opened.

B.

The consistency of the database is checked.

C.

All required background processes are started.

D.

SYS can access the database.

E.

Memory is allocated for the SG1

Full Access
Question # 17

Examine the description of the BOOKS table:

The table has 100 rows.

Examine this sequence of statements issued in a new session:

INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL);

SAVEPOINT a;

DELETE FROM books;

ROLLBACK TO SAVEPOINT a;

ROLLBACK;

Which two statements are true? (Choose two.)

A.

The second ROLLBACK command does nothing

B.

The second ROLLBACK command replays the delete

C.

The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

D.

The second ROLLBACK command undoes the insert

E.

The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Full Access
Question # 18

Which three statements are true regarding indexes? (Choose three.)

A.

A UNIQUE index can be altered to be non-unique

B.

A SELECT statement can access one or more indices without accessing any tables

C.

A table belonging to one user can have an index that belongs to a different user

D.

An update to a table can result in updates to any or all of the table’s indexes

E.

When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

F.

An update to a table can result in no updates to any of the table’s indexes

Full Access
Question # 19

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 # 20

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

A.

undo

B.

index

C.

stored procedures

D.

sequences

E.

tables

F.

clusters

Full Access
Question # 21

Your database instance is started with a PFILE.

Examine these parameters:

You want to increase the size of the buffer cache.

Free memory is available to increase the size of the buffer cache.

You execute the command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;

What is the outcome?

A.

The value is changed only in the PFILE and takes effect at the next instance startup

B.

The value is changed for the current instance and in the PFILE

C.

It fails because the SCOPE clause is missing

D.

Change is applied to the current instance, but does not persist after instance restart

Full Access