1Z0-082 Premium PDF & Test Engine Files with 145 Questions & Answers [Q60-Q74]

Rate this post

1Z0-082 Premium PDF & Test Engine Files with 145 Questions & Answers

Get 100% Real 1Z0-082 Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!

Oracle 1Z0-082 exam is a valuable certification for professionals seeking to advance their careers as Oracle Database Administrators. It tests your abilities to manage Oracle Database 19c and validates your skills and knowledge in this area. To pass the exam, you need to have a strong understanding of Oracle Database Administration concepts and practices and use the official study materials provided by Oracle. Passing the exam can help you increase your career prospects and earn a higher salary.

Oracle 1Z1-082 exam is a 2-hour test that consists of 80 multiple-choice questions. It is a proctored exam that can be taken at authorized testing centers or online. In order to pass the exam, candidates must score at least 63% and demonstrate their proficiency in various areas of database administration. Successful completion of the exam leads to the Oracle Database Administration I certification, which is recognized worldwide and can help professionals advance their careers in the IT industry.

NO.60 You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

It must be smaller than the smallest BIGFILE tablespace

Free space is managed using freelists

Any data files added to the tablespace must have a size of 5 gigabytes

It uses the database default blocksize

It is a locally managed tablespace

Explanation/Reference:

NO.61 You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2019′ FROM DUAL;

SELECT ROUND(SYSDATE – ’01-JAN-2019′) FROM DUAL;

SELECT ROUND(SYSDATE – TO_DATE(’01/JANUARY/2019′)) FROM DUAL;

SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ’01/JANUARY/2019′ FROM DUAL;

SELECT SYSDATE – TO_DATE(’01-JANUARY-2019′) FROM DUAL;

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

C)

D)

E)

Option A

Option B

Option C

Option D

Option E

NO.63 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

NO.64 Which two statements are true regarding a SAVEPOINT? (Choose two.)

Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

Rolling back to a SAVEPOINT can undo a TRUNCATE statement

Only one SAVEPOINT may be issued in a transaction

A SAVEPOINT does not issue a COMMIT

Rolling back to a SAVEPOINT can undo a DELETE statement

NO.65 Which two queries execute successfully?

SELECT NULLIF(NULL, 100) FROM DUAL;

SELECT COALESCE (100, ‘AM FROM DUAL;

SELECT 2TOLLIF(100, ‘A’) FROM DUAL;

SELECT NULLIF(100,100) FROM DUAL;

SELECT COALESCE(100, NULL, 200) FROM DUAL;

NO.66 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?

SELECT REPLACE<TRIM<TRAILING ‘son* FROM cust_last_name), ‘An’, *O’> FROM customers;

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

SELECT REPLACE(REPLACE(cust_last_name, ‘son’, ”), ‘An’, ‘O’> FROM customers;

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

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

Employee 100 will have SALARY set to the same value as the SALARY of employee 200

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Employee 200 will have SALARY set to the same value as the SALARY of employee 100

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Employees 100 and 200 will have the same JOB_ID as before the update command

Employees 100 and 200 will have the same SALARY as before the update command

NO.68 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

NO.69 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

NO.70 Which two statements are true about the PMON background process? (Choose two.)

It registers database services with all local and remote listeners known to the database instance

It frees resources held by abnormally terminated processes

It records checkpoint information in the control file

It frees unused temporary segments

It kills sessions that exceed idle time

Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
* Performs process recovery when a user process fails – Cleans up the database buffer cache – Frees resources that are used by the user process * Monitors sessions for idle session timeout

NO.71 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

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

Add the SEGMENT SPACE MANAGEMENT AUTO clause

Set UNDO_TABLESPACE to UNDOTBS01

Add the NOLOGGING clause

Make certain that the database operates in automatic undo management mode

Add the ONLINE clause

NO.73 View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)