[Nov-2021] Oracle 1Z0-082 Exam: Basic Questions With Answers
New 2021 Realistic Free Oracle 1Z0-082 Exam Dump Questions & Answer
NEW QUESTION 31
A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?
- A. in the undo tablespace
- B. in the PGA
- C. in the SYSAUX tablespace
- D. in the temporary tablespace
- E. in the SGA
Answer: A
NEW QUESTION 32
Which three object types support deferred segment creation? (Choose three.)
- A. heap organized tables
- B. clustered tables
- C. external tables
- D. partitioned tables
- E. index organized tables
- F. temporary tables
Answer: A,D,E
NEW QUESTION 33
Which two are true about Oracle recovery and data protection solutions? (Choose two.)
- A. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
- B. Oracle Data Guard can prevent data loss caused by a site failure.
- C. RMAN can be used to roll back committed transactions.
- D. Data Recovery Advisor can be used to validate backup strategies.
- E. RMAN can be used to FLASHBACK a database.
Answer: B,E
NEW QUESTION 34
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 DAY TO SECOND
- D. TIMESTAMP WITH TIMEZONE
- E. INTERVAL YEAR TO MONTH
Answer: C
NEW QUESTION 35
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?
- A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
- B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;
- C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
- D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
- E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
Answer: E
NEW QUESTION 36
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 read undo block of UNDOTBS1 is overwritten by the generated undo.
- B. It succeeds and the generated undo is stored in SYSTEM.
- C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- 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 SYSAUX.
Answer: C
Explanation:
Explanation
NEW QUESTION 37
Which three statements are true about a self-join? (Choose three.)
- A. It can be an outer join
- B. The query must use two different aliases for the table
- C. It must be an inner join
- D. The ON clause can be used
- E. It must be an equi join
- F. The ON clause must be used
Answer: B,C,D
NEW QUESTION 38
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. Any data files added to the tablespace must have a size of 5 gigabytes
- B. It must be smaller than the smallest BIGFILE tablespace
- C. It uses the database default blocksize
- D. Free space is managed using freelists
- E. It is a locally managed tablespace
Answer: C,E
Explanation:
Explanation/Reference:
NEW QUESTION 39
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, 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 40
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. Set OS_AUTHENT_PREFIX to OPS$
- B. Alter user KING to be IDENTIFIED EXTERNALLY
- C. Grant DBA to KING
- D. Unset REMOTE_LOGIN_PASSWORDFILE
- E. Have the OS administrator add KING to the OSDBA group
Answer: A
Explanation:
https://oracle-base.com/articles/misc/os-authentication
NEW QUESTION 41
Which three statements are true about Oracle synonyms? (Choose three.)
- A. A synonym can be available to all users
- B. A synonym cannot be created for a PL/SQL package
- C. A SEQUENCE can have a synonym
- D. Any user can drop a PUBLIC synonym
- E. A synonym created by one user can refer to an object belonging to another user
Answer: A,C,E
NEW QUESTION 42
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)
- A. The WHERE clause can be used to exclude rows after dividing them into groups
- B. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
- C. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
- D. The WHERE clause can be used to exclude rows before dividing them into groups
- E. The HAVING clause can be used with aggregating functions in subqueries
Answer: D,E
NEW QUESTION 43
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 DALLAS_DB
- C. as SYS in both the databases
- D. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- E. as SCOTT in BOSTON_DB
Answer: C
NEW QUESTION 44
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
- A. the number of days for which an account is locked after the configured number of login attempts has been reached
- B. the number of hours for which an account is locked after the configured number of login attempts has been reached
- C. the number of days for which an account may be inactive before it is locked
- D. the maximum number of sessions permitted for a user before the account is locked
- E. the ability to prevent a password from ever being reused
- F. the number of password changes required within a period of time before a password can be reused
- G. the maximum amount of CPU time allowed for a user's sessions before their account is locked
Answer: A,D,E,F
NEW QUESTION 45
Which two statements are true about the rules of precedence for operators? (Choose two.)
- A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
- B. Multiple parentheses can be used to override the default precedence of operators in an expression
- C. The + binary operator has the highest precedence in an expression in a SQL statement
- D. NULLS influence the precedence of operators in an expression
- E. Arithmetic operators with equal precedence are evaluated from left to right within an expression
Answer: B,E
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.
NEW QUESTION 46
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL(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_limit * .15, 'Not Available') FROM customers;
- D. SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
- E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
Answer: A,E
NEW QUESTION 47
......
How to Study the Oracle 1z0-082: Oracle Database Administration I Exam
There are many ways to prepare for the Oracle 1Z0-068 Exam. Various strategies can be developed if you are planning to take this exam. Candidates can refer to various PDFs available online and even refer to online videos to prepare for the exam. Various websites are offering practice exams to help you prepare for the Exam. Certificate questions provide the most up to date 1Z0-068 exam dumps and we recommend taking the 1Z0-068 practice tests after studying. The candidates must have to take a certification course or training before giving Oracle 1Z0-068 Exam, which will also help them prepare for the exam. Candidates can also take the following recommended courses to prepare for the exam:
- Oracle Database 12c: Clusterware Administration and
- Oracle Database Learning Subscription
- Oracle Database 12c: RAC Administration
- Oracle Database 12c: ASM Administration and
Guaranteed Success in Oracle Database 19c 1Z0-082 Exam Dumps: https://www.exam4docs.com/1Z0-082-study-questions.html
1Z0-082 Practice Test Engine: Try These 118 Exam Questions: https://drive.google.com/open?id=1QkAX76Gdz0eqQzM0m7gvzUXnbJxMb6G2
