CertsTopics Logo

Summer Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 60certs

Oracle 1z0-082 Dumps

Page: 1 / 5
Total 142 questions
Get 1z0-082 Full Access Download 1z0-082 PDF

Oracle Database Administration I Questions and Answers

Question 1

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Options:

A.

A table can have only one primary key but multiple foreign keys

B.

A table can have only one primary key and one foreign key

C.

The foreign key columns and parent table primary key columns must have the same names

D.

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

E.

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

F.

Only the primary key can be defined at the column and table level

G.

Primary key and foreign key constraints can be defined at both the column and table level

Question 2

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 3

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

Options:

A.

Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

B.

WHERE and HAVING clauses can be used in the same statement only if applied to different table columns

C.

The HAVING clause can be used with aggregating functions in subqueries

D.

The WHERE clause can be used to exclude rows before dividing them into groups

E.

The WHERE clause can be used to exclude rows after dividing them into groups

Question 4

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Options:

A.

Column names in each SELECT in the compound query can be different

B.

The number of columns in each SELECT in the compound query can be different

C.

Reversing the order of the intersected tables can sometimes affect the output

D.

INTERSECT returns rows common to both sides of the compound query

E.

INTERSECT ignores NULLs

Question 5

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

Options:

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.

Question 6

Which three statements are true regarding single row subqueries?

Options:

A.

They must be placed on the right side of the comparison operator or condition.

B.

They must be placed on the left side of the comparison operator or condition.

C.

They can be used in the where clause.

D.

A SQL statement may have multiple single row subquery blocks.

E.

They must return a row to prevent errors in the SQL statement.

F.

They can be used in the having clause.

Question 7

Examine these commands:

Which two statements are true about the sqiidr execution?

Options:

A.

It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

B.

It overwrites the data for Alan and adds data for Curl and Bob

C.

It appends data from EMP.DAT TO EMP.

D.

It overwrites all data in emp with data from emp.dat.

E.

It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

Question 8

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

ALTER DATABASE MOUNT;

Which two actions are performed? (Choose two.)

Options:

A.

The online redo logs are opened

B.

The online data files are opened

C.

The alert log records the execution details

D.

The Oracle background processes are started

E.

The initialization parameter file is read

F.

The control file is read

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

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 11

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.

Some sales data is duplicated in both tables.

You want to display the rows from the SALES1 table which are not present in the SALES2 table.

Which set operator generates the required output?

Options:

A.

INTERSECT

B.

UNION ALL

C.

UNION

D.

SUBTRACT

E.

MINUS

Question 12

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 13

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

Options:

A.

dump files

B.

control files

C.

password files

D.

bad files

E.

input files

Question 14

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 15

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 16

Evaluate these commands which execute successfully:

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 17

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

Options:

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

Question 18

In one of your databases, the user HR has the password HRMGR.

You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl

No name server is used.

Which statement is true about ORCL?

Options:

A.

It must be the value of the SERVICE_NAMES parameter on the client side

B.

It must resolve to a valid connect descriptor in the server’s tnsnames.ora file

C.

It must resolve to a valid connect descriptor in the client’s tnsnames.ora file

D.

It must be the name of the database to whose instance HR wishes to connect

E.

It must be the name of the server running the database to whose instance HR wishes to connect

Question 19

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

Options:

A.

The primary key constraint will be enabled and deferred.

B.

The foreign key constraint will be enabled and deferred.

C.

The foreign key constraint will be disabled.

D.

The foreign key constraint will be enabled and immediate.

E.

The primary key constraint will be enabled and immediate.

Question 20

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:

Which statement is true?

Options:

A.

Dynamic service registration cannot be used for this database instance

B.

The LREG process registers services dynamically with the LISTENER_1 listener

C.

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

D.

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

E.

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

Question 21

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

Page: 1 / 5
Total 142 questions
Get 1z0-082 Full Access Download 1z0-082 PDF