Pass Your Oracle Database 19c 1Z0-082 Exam Easily with Accurate PDF Questions [Oct 29, 2022]
1Z0-082 Certification Exam Dumps Questions in here
Who should take the Oracle 1z0-082: Oracle Database Administration I Exam
This course is designed for Database Administrators and Database production Systems Administrators.
What is the duration, language, and format of Oracle 1z0-082: Oracle Database Administration I Exam
- This exam is offered in only English.
- Section 2: 45%
- Certification Validity period : 3 years.
- This exam consists of 90 questions.
- There is a time limit of 140 minutes for the exam.
Oracle database certifications require periodic recertification. To hold your certification inactive condition, you must update to the new edition within 1 year of Oracle's credential withdrawal.
NEW QUESTION 79
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 generated undo is stored in SYSTEM.
- B. It succeeds and the generated undo is stored in SYSAUX.
- 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 least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
Answer: C
NEW QUESTION 80
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
- A. Revoke the CREATE SESSION privilege from user HR
- B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
- C. Execute DML statements in the HR schema
- D. Execute DDL statements in the HR schema
- E. Log in to the database instance
- F. Revoke the CREATE SESSION privilege from other users
Answer: B,E,F
NEW QUESTION 81
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
- A. Revoke the CREATE SESSION privilege from user HR
- B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
- C. Execute DML statements in the HR schema
- D. Execute DDL statements in the HR schema
- E. Log in to the database instance
- F. Revoke the CREATE SESSION privilege from other users
Answer: B,D,F
Explanation:
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224
NEW QUESTION 82
You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?
- A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
- B. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- C. ROW STORE COMPRESS ADVANCED
- D. ROW STORE COMPRESS BASIC
- E. COLUMN STORE COMPRESS FOR QUERY LOW
Answer: C
Explanation:
Reference:
https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf
NEW QUESTION 83
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
- A. All trace files contain error information that require contacting Oracle Support
- B. Trace file names are based on the database name concatenated with a sequential number
- C. They can be written by background processes
- D. Trace files are written to the Fast Recovery Area (FRA)
- E. They can be written by server processes
Answer: C,E
Explanation:
Explanation/Reference: https://gerardnico.com/db/oracle/trace_file
NEW QUESTION 84
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
- A. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
- B. The Oracle Net Configuration Assistant is only used when running the Oracle installer
- C. The lsnrctl utility requires a listener.ora file to exist before it is started
- D. Oracle Net Manager can be used to locally configure naming methods on a database server
- E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
- F. Oracle Net Manager can be used to centrally configure listeners on any database server target
Answer: D,E,F
NEW QUESTION 85
View the Exhibit and examine the description of the tables.
You execute this SQL statement:
Which three statements are true?
- A. The statement will fall if a row already exists in the sales table for product 23.
- B. The sales table has five foreign keys.
- C. The statement will fail because a subquery may not be contained in a values clause.
- D. A product can have a different unit price at different times.
- E. The statement will execute successfully and a new row will be inserted into the sales table.
- F. A customer can exist in many countries.
Answer: B,D,E
NEW QUESTION 86
Which two statements are true about the results of using the INTERSECT operator in compound queries?
(Choose two.)
- A. Column names in each SELECT in the compound query can be different
- B. The number of columns in each SELECT in the compound query can be different
- C. INTERSECT returns rows common to both sides of the compound query
- D. INTERSECT ignores NULLs
- E. Reversing the order of the intersected tables can sometimes affect the output
Answer: A,D
NEW QUESTION 87
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_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND due_amount IS NOT NULL; - B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL; - C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount != NULL; - D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL; - E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL;
Answer: D
NEW QUESTION 88
Which three statements are true about single-row functions? (Choose three.)
- A. They return a single result row per table
- B. They can be used only in the WHERE clause of a SELECT statement
- C. The argument can be a column name, variable, literal or an expression
- D. They can accept only one argument
- E. They can be nested to any level
- F. The data type returned can be different from the data type of the argument
Answer: C,E,F
NEW QUESTION 89
Which three statements are true about the DESCRIBE command? (Choose three.)
- A. It can be used to display the structure of an existing view
- B. It displays all constraints that are defined for each column
- C. It can be used only from SQL *Plus
- D. It displays the NOT NULL constraint for any columns that have that constraint
- E. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
- F. It can be used from SQL Developer
Answer: A,C,D
NEW QUESTION 90
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)
- A. AUTOEXTEND is possible for the datafile
- B. It will be a dictionary-managed tablespace by default
- C. It will always have a 32K blocksize
- D. It must be bigger than the largest SMALLFILE tablespace
- E. Additional data files may not be added
Answer: A,D
NEW QUESTION 91
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. qty_sold = `0554982' uses implicit conversion
- B. invoice_date = '15-march-2019' : uses implicit conversion
- C. qty_sold BETWEEN `101' AND '110' : uses implicit conversion
- D. CONCAT (qty_sold, invoice_date) : requires explicit conversion
- E. invoie_date > '01-02-2019' : uses implicit conversion
Answer: B,C
NEW QUESTION 92
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
- A. Oracle Managed Files (OMF)
- B. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
- C. Online index segment shrink
- D. Automatic data file extension (AUTOEXTEND)
- E. Online table segment shrink
Answer: A,B,D
Explanation:
Explanation
NEW QUESTION 93
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- 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. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- E. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- F. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
Answer: C,D,E
Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html
NEW QUESTION 94
Which two statements are true?
- A. SALES1 is created with 55,000 rows.
- B. SALES1 is created with 1 row.
- C. SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.
- D. SALES1 is created with no rows.
- E. SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.
Answer: A,E
NEW QUESTION 95
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 generated undo is stored in SYSTEM.
- B. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' ".
- C. It succeeds and the generated undo is stored in SYSAUX.
- D. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- E. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
Answer: D
NEW QUESTION 96
Which compression method is recommended for Direct-Path Insert operations?
- A. ROW STORE COMPRESS ADVANCED
- B. COLUMN STORE COMPRESS ADVANCED
- C. COLUMN STORE COMPRESS BASIC
- D. RON STORE COMPRESS BASIC
Answer: D
NEW QUESTION 97
Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)
- A. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
- B. External table files can be used for other external tables in a different database
- C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
- D. They cannot be partitioned
- E. They support UPDATEs but not INSERTs and DELETEs
- F. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
Answer: A,B,E
NEW QUESTION 98
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(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, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
Answer: C
NEW QUESTION 99
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Change the standard block size of an existing database
- B. Configure incremental backups for a new database
- C. Register a new database with an available Enterprise Manager Management server
- D. Enable flashback database for an existing database
- E. Configure a nonstandard block size for a new database
Answer: C,E
Explanation:
Reference:
https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 100
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
- A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
- B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
- C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100
"DUES AMOUNT" FROM transactions; - D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
- E. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
Answer: B,D
NEW QUESTION 101
Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)
- A. Active UNDO is always retained.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
- C. UNDO_RETENTION specifies how long all types of UNDO are retained.
- D. Unexpired UNDO is always retained.
- E. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
Answer: D,E
NEW QUESTION 102
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_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND due_amount IS NOT NULL; - B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL; - C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount != NULL; - D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL; - E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL;
Answer: D
NEW QUESTION 103
Which three statements are true about views in an Oracle database? (Choose three.)
- A. Data Manipulation Language (DML) can always be used on views
- B. Tables in the defining query of a view must always exist in order to create the view
- C. Views can be updated without the need to re-grant privileges on the view
- D. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- E. The WITH CHECK clause prevents certain rows from being updated or inserted
- F. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- G. The WITH CHECK clause prevents certain rows from being displayed when querying the view
Answer: C,D,F
NEW QUESTION 104
......
Updated 1Z0-082 Exam Practice Test Questions: https://dumpsninja.surepassexams.com/1Z0-082-exam-bootcamp.html