Get 1Z1-082 Actual Free Exam Q&As to Prepare for Your Oracle Certification
Oracle Actual Free Exam Questions And Answers
Oracle 1Z0-082 exam consists of 70 multiple-choice questions that must be completed within 105 minutes. 1Z1-082 exam is computer-based and administered at Pearson VUE testing centers. Candidates can register for the exam online through the Oracle Certification website.
NEW QUESTION # 87
Which two statements are true about the DUAL table? (Choose two.)
- A. It can display multiple rows but only a single column
- B. It can be accessed by any user who has the SELECT privilege in any schema
- C. It can be used to display only constants or pseudo columns
- D. It can display multiple rows and columns
- E. It consists of a single row and single column of VARCHAR2 data type
- F. It can be accessed only by the SYS user
Answer: D,E
NEW QUESTION # 88
Which two are true about RETENTION GUARANTEE? (Choose two.)
- A. It prevents out-of-space errors.
- B. It is a tablespace attribute.
- C. It is a static parameter.
- D. It prevents FLASHBACK DATABASE operation failure.
- E. It prevents "Snapshot too old" errors.
Answer: B,D
NEW QUESTION # 89
Examine these commands:
Which two statements are true about the sqlldrexecution? (Choose two.)
- A. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- B. It uses the database buffer cache to load data
- C. It overwrites data in EMP with data in EMP.DAT
- D. It generates a sql script that it uses to load data from EMP.DAT to EMP
- E. It appends data from EMP.DAT to EMP
Answer: B,D
NEW QUESTION # 90
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- C. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- D. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- E. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
Answer: A,C,E
NEW QUESTION # 91
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- B. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- E. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- F. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
Answer: A,B,C
NEW QUESTION # 92
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?
- A. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1' ". - B. It succeeds and the generated undo is stored in SYSAUX.
- C. It succeeds and the generated undo is stored in SYSTEM.
- D. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- E. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
Answer: E
Explanation:
Explanation
NEW QUESTION # 93
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.)
- A. Free space is managed using freelists
- B. It must be smaller than the smallest BIGFILE tablespace
- C. It is a locally managed tablespace
- D. It uses the database default blocksize
- E. Any data files added to the tablespace must have a size of 5 gigabytes
Answer: C,D
Explanation:
Explanation/Reference:
NEW QUESTION # 94
Which statement is true about the INTERSECT operator used in compound queries?
- A. INTERSECT is of lower precedence than UNION or UNION ALL
- B. It processes NULLs in the selected columns
- C. Multiple INTERSECT operators are not possible in the same SQL statement
- D. It ignores NULLs
Answer: B
NEW QUESTION # 95
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- B. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
- C. SELECT NVL2(cust_credit_linit * .15, 'Not Available') FROM customers;
- D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- E. SELECT NVL(cust_credit_linit * .15, 'Not Available') FROM customers;
Answer: C,D
NEW QUESTION # 96
Examine this command and some partial output:
Why does the DB01.abc.com service show unknown status?
- A. The listener is not listening on the default port 1521
- B. The service DB01.abc.com is statically registered
- C. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- D. The service DB01.abc.com is dynamically registered
- E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
Answer: B
NEW QUESTION # 97
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.
Which query can be used?
- A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(`MONDAY') FROM employees;
- B. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
- C. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
- D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), `MONDAY') FROM employees;
Answer: D
NEW QUESTION # 98
Which two statements are true about the PMON background process? (Choose two.)
- A. It kills sessions that exceed idle time
- B. It records checkpoint information in the control file
- C. It frees unused temporary segments
- D. It frees resources held by abnormally terminated processes
- E. It registers database services with all local and remote listeners known to the database instance
Answer: D,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
NEW QUESTION # 99
Examine this command:
Which two statements are true? (Choose two.)
- A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- B. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
- C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- D. The file is renamed and stored in the same location
- E. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
Answer: A,D
NEW QUESTION # 100
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 both the databases
- B. as SCOTT in BOSTON_DB
- C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- D. as SCOTT in DALLAS_DB
- E. as SYS in both the databases
Answer: B
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085 Database links are either private or public. If they are private, then only the user who created the link has access; if they are public, then all database users have access.
https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205
NEW QUESTION # 101
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. It is available only when the database is open
- B. It can be used to perform database recovery
- C. The same port number can be used for Database Express configurations for databases on different hosts
- D. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- E. It can be used to switch a database into ARCHIVELOGMODE
Answer: A,C
Explanation:
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with-database-administration.html#GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5
NEW QUESTION # 102
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.)
- A. Set DEFERRED_SEGMENT_CREATION to TRUE
- B. Increase U1's quota sufficiently in DATA
- C. Add a data file to DATA
- D. Grant UNLIMITED TABLESPACE to U1
- E. Drop other U1 objects in DATA
- F. Set AUTOEXTEND ON for data files in DATA
Answer: A,B,F
NEW QUESTION # 103
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- B. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- D. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
Answer: A
NEW QUESTION # 104
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. Employees 100 and 200 will have the same SALARY as before the update command
- B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- C. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- D. Employees 100 and 200 will have the same JOB_ID as before the update command
- E. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
- F. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
Answer: C,F
NEW QUESTION # 105
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
- A. the maximum number of sessions permitted for a user before the account is locked
- B. the number of password changes required within a period of time before a password can be reused
- C. the number of days for which an account is locked after the configured number of login attempts has been reached
- D. the number of days for which an account may be inactive before it is locked
- E. the number of hours for which an account is locked after the configured number of login attempts has been reached
- F. the maximum amount of CPU time allowed for a user's sessions before their account is locked
- G. the ability to prevent a password from ever being reused
Answer: A,B,C,G
NEW QUESTION # 106
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. Set DEFERRED_SEGMENT_CREATION to TRUE
- B. Increase U1's quota sufficiently in DATA
- C. Add a data file to DATA
- D. Grant UNLIMITED TABLESPACE to U1
- E. Drop other U1 objects in DATA
- F. Set AUTOEXTEND ON for data files in DATA
Answer: A,B,F
NEW QUESTION # 107
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
- B. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- D. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
- E. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
Answer: A,C
NEW QUESTION # 108
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?
- A. It must be the value of the SERVICE_NAMES parameter on the client side
- B. It must be the name of the server running the database to whose instance HR wishes to connect
- 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 resolve to a valid connect descriptor in the server's tnsnames.ora file
Answer: C
NEW QUESTION # 109
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- D. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
Answer: A
NEW QUESTION # 110
The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?
- A. WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))
- B. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
- C. WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
- D. WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
- E. WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
Answer: D,E
NEW QUESTION # 111
......
1Z1-082 Questions Truly Valid For Your Oracle Exam: https://itcertspass.itcertmagic.com/Oracle/real-1Z1-082-exam-prep-dumps.html