1Z0-082 Dumps PDF - 1Z0-082 Real Exam Questions Answers [Q14-Q36]

Rate this post

1Z0-082 Dumps PDF – 1Z0-082 Real Exam Questions Answers

Get Started: 1Z0-082 Exam [year] Dumps Oracle PDF Questions

For more info read reference:

Oracle 1z0-082: Oracle Database Administration 1 Exam Certification Path

The Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator certification is for Database Development Systems Managers and Database Administrators with at least 1 year of RAC and Grid Infrastructure experience. It is also recommended to understand high availability concepts and clustering. To earn this certificate, you should have the ability to install, manage, monitor, and recover RAC databases, Clusterware, and ASM environments. You will get a complete understanding of the architecture of the Clusterware, ASM, and RAC databases while preparing for the exam. After earning this certification, you will gain the skills of installing, setup, backup and recovering, tuning, and monitoring these components.
Self-study courses are great sources for the preparation of the Exam, but they do not meet the requirement of the training. To meet the requirement of the training course must be offered by Oracle University Training Center, Oracle Authorized Education Center, Oracle Authorized Partner, or Oracle Workforce Development Program. Courses can be a live virtual class, training on demand, learning subscription, or instructor-led in-class.

QUESTION 14
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

GLOBAL TEMPORARY TABLE space allocation occurs at session start.

Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.

A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

QUESTION 15
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/3/6 14:45:17
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.)

Add a data file to DATA

Drop other U1 objects in DATA

Increase U1’s quota sufficiently in DATA

Set DEFERRED_SEGMENT_CREATION to TRUE

Grant UNLIMITED TABLESPACE to U1

Set AUTOEXTEND ON for data files in DATA

QUESTION 16
Examine this SQL statement:
SELECT cust_id, cust_last_name “Last Name”
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)

ORDER BY “Last Name”

ORDER BY 2, 1

ORDER BY 2, cust_id

ORDER BY CUST_NO

ORDER BY “CUST_NO”

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

It can be accessed only by the SYS user

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

It can display multiple rows but only a single column

It can be used to display only constants or pseudo columns

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

It can display multiple rows and columns

QUESTION 18
Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

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

You can no longer monitor it

You can reattach to it and monitor it

It is paused and can be resumed

It continues to run in the background

It terminates

QUESTION 20
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?

SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond;

SELECT &col1, &col2
FROM &&table
WHERE &condition;

SELECT &col1, &col2
FROM “&table”
WHERE &condition;

SELECT `&&col1′, `&&col2′
FROM &table
WHERE `&&condition’ = `&cond’;

SELECT &&col1, &&col2
FROM &table
WHERE &&condition;

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

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

The data dictionary is created and maintained by the database administrator

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Base tables can be queried directly

It is owned by the SYSTEM user

Usernames of all users including database administrators are stored in the data dictionary

QUESTION 22
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

The sales user must have a quota on the TEMP tablespace

The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

The sales user must have been granted the CREATE SESSION privilege

The sales user must have their quota on the users tablespace removed

The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

The sales user must have been granted the CREATE TABLE privilege

QUESTION 23
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

It succeeds and the generated undo is stored in SYSTEM.

It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace
‘UNDOTBS1’ “.

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

It succeeds and the generated undo is stored in SYSAUX.

It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

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

You can no longer monitor it

You can reattach to it and monitor it

It is paused and can be resumed

It continues to run in the background

It terminates

QUESTION 25
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?

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

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

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

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

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

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

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

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

QUESTION 27
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?

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

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

It fails because the SCOPE clause is missing

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

QUESTION 28
Which two statements are true about UNDO and REDO? (Choose two.)

The generation of UNDO generates REDO

DML modifies Oracle database objects and only generates UNDO

The generation of REDO generates UNDO

DML modifies Oracle database objects and only generates REDO

QUESTION 29
Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

They can be written by server processes

Trace files are written to the Fast Recovery Area (FRA)

They can be written by background processes

All trace files contain error information that require contacting Oracle Support

Trace file names are based on the database name concatenated with a sequential number

QUESTION 30
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?

as SCOTT in DALLAS_DB

as SCOTT in BOSTON_DB

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

as SYS in both the databases

as SCOTT in both the databases

QUESTION 31
Which two can you use to recover a dropped table? (Choose two.)

FLASHBACK QUERY

FLASHBACK DATABASE

FLASHBACK TRANSACTION

FLASHBACK TABLE TO SCN

FLASHBACK DROP

QUESTION 32
Which three statements are true concerning logical and physical database structures? (Choose three.)

All tablespaces may have one or more data files

The extents of a segment must always reside in the same datafile

A smallfile tablespace might be bigger than a bigfile tablespace

A segment can span multiple data files in some tablespaces

A segment’s blocks can be of different sizes

A segment might have only one extent

Segments can span multiple tablespaces

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

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

SYSDATE can be queried only from the DUAL table

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

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

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

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

QUESTION 34
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

It gives an error because the ALL keyword is not valid

It gives an error because the GROUP BY clause is not valid

It executes successfully but does not give the required result

It executes successfully and gives the required result

QUESTION 35
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”
fmMonth rrrr’)
What is the result?

It executes successfully but does not return any result

It returns the date for the first Monday of the next month

It generates an error

It returns the date for the last Monday of the current month

QUESTION 36
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)