[May-2023] Verified Oracle Exam Dumps with 1Z1-082 Exam Study Guide
Best Quality Oracle 1Z1-082 Exam Questions TopExamCollection Realistic Practice Exams [2023]
How to book the Oracle 1z0-082: Oracle Database Administration I Exam
If you are looking to appear in the Oracle 1z0-082: Oracle Database Administration I Exam, you can do so by either redeeming a voucher that you have to buy from Oracle or paying directly with a credit card. After payment, you can schedule the test via Oracle's external testing provider, PearsonVue.
The Oracle 1Z1-082 certification exam is an excellent opportunity for database administrators to validate their skills and knowledge in managing Oracle Database 19c. Passing this certification exam can open up new career opportunities and help professionals advance in their careers. It is highly recommended for IT professionals who want to demonstrate their expertise in database administration and become proficient in managing Oracle databases.
NEW QUESTION # 77
Which three activities are recorded in the database alert log? (Choose three.)
- A. deadlock errors
- B. Data Definition Language (DDL) statements
- C. non-default database parameters
- D. block corruption errors
- E. session logins and logouts
Answer: A,C,D
NEW QUESTION # 78
Which two statements are true about UNDO and REDO? (Choose two.)
- A. The generation of REDO generates UNDO
- B. DML modifies Oracle database objects and only generates UNDO
- C. The generation of UNDO generates REDO
- D. DML modifies Oracle database objects and only generates REDO
- E. DML modifies Oracle database objects and generates UNDO and REDO
Answer: A,C
NEW QUESTION # 79
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.)
- A. ORDER BY 2, cust_id
- B. ORDER BY "CUST_NO"
- C. ORDER BY CUST_NO
- D. ORDER BY "Last Name"
- E. ORDER BY 2, 1
Answer: A,D,E
NEW QUESTION # 80
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- A. It will always have a 32K blocksize
- B. Additional data files may not be added
- C. It must be bigger than the largest SMALLFILE tablespace
- D. AUTOEXTEND is possible for the datafile
- E. It will be a dictionary-managed tablespace by default
Answer: B,D
NEW QUESTION # 81
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)
- A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
- B. Display the minimum PROD_LIST_PRICE for each product status
- C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
- D. Display suppliers whose PROD_LIST_PRICE is less than 1000
- E. Display the total number of products supplied by supplier 102 which have a product status of obsolete
Answer: A,C
NEW QUESTION # 82
Which two are true about shrinking a segment online? (Choose two.)
- A. It always eliminates all migrated rows if any exist in the table
- B. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- C. To shrink a table it must have a UNIQUE KEY constraint
- D. To shrink a table it must have a PRIMARY KEY constraint
- E. To shrink a table it must have row movement enabled
- F. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
Answer: D,E
NEW QUESTION # 83
Examine this description of the books table containing 100 rows:
Now examine this sequence of statements Issued In a new session;
Examine this description of the books table containing 100 rows:
Which three statements are true?
- A. The second rollback command rolls back the rollback to savepoint a command.
- B. The second rollback command restores the row that was inserted.
- C. The first rollback command leaves the table's 100 original rows locked.
- D. The first rollback command restores the 100 rows that were in the table originally.
- E. The first rollback command leaves the inserted row locked.
- F. The second rollback command restores the 100 rows that were in the table originally.
- G. The first RollBack command restores the row that was inserted.
Answer: A,B,G
NEW QUESTION # 84
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(ADD_MONTHS(hire_date, 6), 1) 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), 'MONDAY') FROM employees;
- D. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
Answer: C
NEW QUESTION # 85
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. Add a data file to DATA
- B. Set DEFERRED_SEGMENT_CREATION to TRUE
- C. Increase U1's quota sufficiently in DATA
- D. Set AUTOEXTEND ON for data files in DATA
- E. Grant UNLIMITED TABLESPACE to U1
- F. Drop other U1 objects in DATA
Answer: B,C,D
NEW QUESTION # 86
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
- A. the ability to prevent a password from ever being reused
- B. the number of days for which an account is locked after the configured number of login attempts has been reached
- C. the number of password changes required within a period of time before a password can be reused
- D. the number of hours for which an account is locked after the configured number of login attempts has been reached
- E. the maximum number of sessions permitted for a user before the account is locked
- F. the maximum amount of CPU time allowed for a user's sessions before their account is locked
- G. the number of days for which an account may be inactive before it is locked
Answer: A,B,C,D
NEW QUESTION # 87
Which two are true about shrinking a segment online? (Choose two.)
- A. It always eliminates all migrated rows if any exist in the table
- B. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- C. To shrink a table it must have a UNIQUE KEY constraint
- D. To shrink a table it must have a PRIMARY KEY constraint
- E. To shrink a table it must have row movement enabled
- F. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
Answer: D,E
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION # 88
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
- A. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- B. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- C. The CURRENT_TIMESTAMP function returns data without time zone information
- D. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
- E. A TIMESTAMP data type column contains information about year, month, and day
Answer: A,B,C
NEW QUESTION # 89
Which statement is true about aggregate functions?
- A. Aggregate functions can be nested to any number of levels
- B. The AVG function implicitly converts NULLS to zero
- C. Aggregate functions can be used in any clause of a SELECT statement
- D. The MAX and MIN functions can be used on columns with character data types
Answer: D
NEW QUESTION # 90
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)
- A. invoice_date = '15-march-2019' : uses implicit conversion
- B. qty_sold = `0554982' uses implicit conversion
- C. qty_sold BETWEEN `101' AND '110' : uses implicit conversion
- D. invoie_date > '01-02-2019' : uses implicit conversion
- E. CONCAT (qty_sold, invoice_date) : requires explicit conversion
Answer: A,C
NEW QUESTION # 91
Which two queries execute successfully?
- A. SELECT NULLIF(NULL, 100) FROM DUAL;
- B. SELECT COALESCE(100, NULL, 200) FROM DUAL;
- C. SELECT COALESCE (100, 'AM FROM DUAL;
- D. SELECT NULLIF(100,100) FROM DUAL;
- E. SELECT 2TOLLIF(100, 'A') FROM DUAL;
Answer: B
NEW QUESTION # 92
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)
- A. The online data files are opened
- B. The Oracle background processes are started
- C. The online redo logs are opened
- D. The initialization parameter file is read
- E. The control file is read
- F. The alert log records the execution details
Answer: B,E
NEW QUESTION # 93
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- B. Connect Time Failover requires the use of Transparent Application Failover (TAF)
- C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- D. Connect Time Failover requires the connect string to have two or more listener addresses configured
- E. Load Balancing requires the use of a name server
- F. Source Routing requires the use of a name server
Answer: C,D,F
Explanation:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
NEW QUESTION # 94
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)
- A. The online data files are opened
- B. The alert log records the execution details
- C. The online redo logs are opened
- D. The initialization parameter file is read
- E. The control file is read
- F. The Oracle background processes are started
Answer: B,E
Explanation:
http://facedba.blogspot.com/2014/07/oracle-database-startup-stages-and.html
NEW QUESTION # 95
Examine the description of the PROMOTIONS table:
You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
- A. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
- B. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
- C. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
- D. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
- E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
Answer: D,E
NEW QUESTION # 96
Your database instance is started with an SPFILE.
A PFILE is also available. You execute this command:
ALTER SYSTEM SET DB_CACHE_SIZE=100K;
Where Is the value changed?
- A. only in memory
- B. in the SPFILE and in memory
- C. in the SPFILE, SPFILE, and memory
- D. in the SPFILE and SPFILEc
- E. only In the SPFILE
Answer: D
NEW QUESTION # 97
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?
- A. It fails because the SCOPE clause is missing
- B. The value is changed only in the PFILE and takes effect at the next instance startup
- C. Change is applied to the current instance, but does not persist after instance restart
- D. The value is changed for the current instance and in the PFILE
Answer: C
Explanation:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
NEW QUESTION # 98
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 executes successfully and gives the required result
- B. It executes successfully but does not give the required result
- C. It gives an error because the GROUP BY clause is not valid
- D. It gives an error because the ALL keyword is not valid
Answer: A
NEW QUESTION # 99
Which two statements are true regarding a SAVEPOINT? (Choose two.)
- A. Only one SAVEPOINT may be issued in a transaction
- B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
- C. A SAVEPOINT does not issue a COMMIT
- D. Rolling back to a SAVEPOINT can undo a DELETE statement
- E. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
Answer: C,D
NEW QUESTION # 100
......
The Oracle 1Z1-082 (Oracle Database Administration I) Certification Exam is designed to test the knowledge and skills of database administrators who want to demonstrate their expertise in managing and maintaining an Oracle database. This exam is the first step towards becoming an Oracle Certified Associate (OCA) in database administration. The certification validates the candidate's knowledge in areas such as installation, configuration, and management of the Oracle database.
Authentic Best resources for 1Z1-082: https://gocertify.topexamcollection.com/1Z1-082-vce-collection.html
