[Sep-2021] Oracle 1Z0-082 Dumps – Reduce Your Chance of Failure in 1Z0-082 Exam
To help you achieve your ultimate goal, we suggest the actual Oracle 1Z0-082 dumps for your Oracle Database Administration I exam preparation to use as your guideline.
NEW QUESTION 68
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:
What must you do so that KING is authenticated by the OS when connecting to the database instance?
- A. Alter user KING to be IDENTIFIED EXTERNALLY
- B. Have the OS administrator add KING to the OSDBA group
- C. Unset REMOTE_LOGIN_PASSWORDFILE
- D. Grant DBA to KING
- E. Set OS_AUTHENT_PREFIX to OPS$
Answer: E
Explanation:
https://oracle-base.com/articles/misc/os-authentication
NEW QUESTION 69
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 wee.
Which query can be used?
- A. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
- B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
- C. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;
- D. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
Answer: C
NEW QUESTION 70
Which two are true about conventional path SQL load? (Choose two.)
- A. It always generates redo.
- B. It enforces referential integrity constraints.
- C. It cannot load data into clustered tables.
- D. It locks objects being processed.
- E. It does not generate UNDO.
Answer: B,E
NEW QUESTION 71
Which two are true about shrinking a segment online? (Choose two.)
- A. To shrink a table it must have a PRIMARY KEY constraint
- B. It always eliminates all migrated rows if any exist in the table
- C. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- D. To shrink a table it must have a UNIQUE KEY constraint
- E. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- F. To shrink a table it must have row movement enabled
Answer: C,F
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION 72
Which two statements are true about the PMON background process? (Choose two.)
- A. It kills sessions that exceed idle time
- B. It frees unused temporary segments
- C. It frees resources held by abnormally terminated processes
- D. It records checkpoint information in the control file
- E. It registers database services with all local and remote listeners known to the database instance
Answer: C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
NEW QUESTION 73
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?
- A. T1, an index segment for the primary key, and a LOB segment only
- B. T1 only
- C. no segments are created
- D. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- E. T1 and an index segment created for the primary key only
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 74
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
- B. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
- C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- D. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- E. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
Answer: B,C
NEW QUESTION 75
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- B. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- C. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- D. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- E. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- F. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
Answer: A,C,D
Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html
NEW QUESTION 76
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?
- A. SUBTRACT
- B. UNION ALL
- C. UNION
- D. MINUS
- E. INTERSECT
Answer: D
NEW QUESTION 77
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. Grant UNLIMITED TABLESPACE to U1
- C. Set AUTOEXTEND ON for data files in DATA
- D. Increase U1's quota sufficiently in DATA
- E. Drop other U1 objects in DATA
- F. Add a data file to DATA
Answer: A,C,D
NEW QUESTION 78
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- 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. A synonym cannot be created for a PL/SQL package
Answer: B,C,D
NEW QUESTION 79
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?
- A. TIMESTAMP WITH LOCAL TIMEZONE
- B. TIMESTAMP
- C. INTERVAL YEAR TO MONTH
- D. TIMESTAMP WITH TIMEZONE
- E. INTERVAL DAY TO SECOND
Answer: E
NEW QUESTION 80
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL(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 NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
- D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
- E. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
Answer: B,E
NEW QUESTION 81
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. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- C. The file is renamed and stored in the same location
- D. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
- E. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
Answer: A,D
NEW QUESTION 82
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Enable flashback database for an existing database
- C. Register a new database with an available Enterprise Manager Management server
- D. Configure a nonstandard block size for a new database
- E. Change the standard block size of an existing database
Answer: C,D
Explanation:
Reference:
https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 83
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?
- A. It gives an error because the GROUP BY clause is not valid
- B. It gives an error because the ALL keyword is not valid
- C. It executes successfully but does not give the required result
- D. It executes successfully and gives the required result
Answer: D
NEW QUESTION 84
Examine this command and some partial output:
Why does the DB01.abc.comservice show unknown status?
- A. The service DB01.abc.com is dynamically registered
- B. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
- C. The service DB01.abc.com is statically registered
- D. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- E. The listener is not listening on the default port 1521
Answer: D
NEW QUESTION 85
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- 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. A synonym cannot be created for a PL/SQL package
Answer: B,C,D
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION 86
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- 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. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
Answer: A,B
NEW QUESTION 87
A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)
- A. V$SYSTEM_EVENT
- B. V$SESSION_WAIT
- C. V$SESSION
- D. V$SESSION_EVENT
- E. V$SESSION_WAIT_CLASS
Answer: B,D
NEW QUESTION 88
Which statement is true about aggregate functions?
- A. Aggregate functions can be used in any clause of a SELECT statement
- B. Aggregate functions can be nested to any number of levels
- C. The MAX and MIN functions can be used on columns with character data types
- D. The AVG function implicitly converts NULLS to zero
Answer: C
NEW QUESTION 89
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 200 will have SALARY set to the same value as the SALARY of employee 100
- B. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
- C. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- D. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- 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
Answer: B,D
NEW QUESTION 90
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 succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- B. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- C. It succeeds and the generated undo is stored in SYSAUX.
- D. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1' ". - E. It succeeds and the generated undo is stored in SYSTEM.
Answer: A
Explanation:
Explanation
NEW QUESTION 91
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Configure a nonstandard block size for a new database
- C. Enable flashback database for an existing database
- D. Register a new database with an available Enterprise Manager Management server
- E. Change the standard block size of an existing database
Answer: D,E
Explanation:
https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 92
Examine these commands:
Which two statements are true about the sqlldr execution? (Choose two.)
- A. It appends data from EMP.DAT to EMP
- B. It uses the database buffer cache to load data
- C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- D. It generates a sql script that it uses to load data from EMP.DAT to EMP
- E. It overwrites data in EMP with data in EMP.DAT
Answer: A,C
NEW QUESTION 93
......
100% Free 1Z0-082 Demo-Trial [Pdf], get it now: https://drive.google.com/open?id=1yIrNUMU9NOIeQcbibfZCtoK821uIGZha
Accurate & Verified Answers As Seen in the Real Exam here: https://www.testpdf.com/1Z0-082-exam-braindumps.html
