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

Oracle 1z0-082 - Oracle Database Administration I

Oracle 1z0-082 Premium Access     Download Demo    
Page: 1 / 5
Total 142 questions

Which three statements are true about the DESCRIBE command? (Choose three.)

A.

It displays the PRIMARY KEY constraint for any column or columns that have that constraint

B.

It can be used from SQL Developer

C.

It displays the NOT NULL constraint for any columns that have that constraint

D.

It can be used to display the structure of an existing view

E.

It displays all constraints that are defined for each column

F.

It can be used only from SQL*Plus

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

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

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.

Which query can be used?

A.

SELECT * FROM customers WHERE city LIKE ‘D_%’;

B.

SELECT * FROM customers WHERE city = ‘%D_’;

C.

SELECT * FROM customers WHERE city LIKE ‘D_’;

D.

SELECT * FROM customers WHERE city = ‘D_%’;

You want to apply the principle of Least Privilege in all your live databases.

One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.

Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

A.

analysis of all privileges used by all users including administrative users in the database

B.

analysis of all privileges used by all users but excluding administrative users in the database

C.

analysis of privileges that a user has on their own schema objects that they did not use

D.

analysis of privileges that a user has on their own schema objects that they did use

E.

analysis of privileges granted directly to a role that are then used by a user who has been granted that role

F.

analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

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

A.

dump files

B.

control files

C.

password files

D.

bad files

E.

input files

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

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

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

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.

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

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

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A.

The Oracle join syntax supports creation of a Cartesian product of two tables

B.

The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

C.

The SQL:1999 compliant ANSI join syntax supports natural joins

D.

The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

E.

The Oracle join syntax only supports right outer joins

F.

The Oracle join syntax supports natural joins

G.

The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE

User U1 has a 1 MB quota in tablespace DATA.

U1 executes this command:

SQL> CREATE TABLE t1 AS

(SELECT object_name, sharing, created

FROM dba_objects);

U1 complains that the command is taking too long to execute.

In the alert log, the database administrator (DBA) finds this:

2017-03-06T12:15:17.183438+05:30

statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA-01536: space quota exceeded for tablespace ‘DATA’

Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A.

Add a data file to DATA

B.

Drop other U1 objects in DATA

C.

Increase U1’s quota sufficiently in DATA

D.

Set DEFERRED_SEGMENT_CREATION to TRUE

E.

Grant UNLIMITED TABLESPACE to U1

F.

Set AUTOEXTEND ON for data files in DATA