1Z0-082 exam questions for practice in 2023 Updated 145 Questions
Updated Jul-2023 Premium 1Z0-082 Exam Engine pdf - Download Free Updated 145 Questions
The exam is designed to test your knowledge of various Oracle concepts, including backup and recovery operations, schema management, data dictionary management, and user management. This exam is designed to test the practical and theoretical knowledge of the candidate. You should have at least six months of experience in database administration and a solid understanding of database concepts to pass the exam.
NEW QUESTION # 69
Which statement is true about aggregate functions?
- A. Aggregate functions can be used in any clause of a SELECT statement
- B. The MAX and MIN functions can be used on columns with character data types
- C. Aggregate functions can be nested to any number of levels
- D. The AVG function implicitly converts NULLS to zero
Answer: C
NEW QUESTION # 70
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
- A. It uses the database default blocksize
- B. It is a locally managed tablespace
- C. It must be smaller than the smallest BIGFILE tablespace
- D. Any data files added to the tablespace must have a size of 5 gigabytes
- E. Free space is managed using freelists
Answer: A,B
NEW QUESTION # 71
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 generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- C. It uses the database buffer cache to load data
- 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: C,D
NEW QUESTION # 72
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)
- A. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
- B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- C. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- D. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- E. 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
Answer: B,D
NEW QUESTION # 73
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 NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
- C. SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
- D. SELECT NVL(TO_CHAR(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: D,E
NEW QUESTION # 74
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 DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
- C. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
- D. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
- E. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
Answer: B,C
NEW QUESTION # 75
Which two statements are true about the DUAL table? (Choose two.)
- A. It can be accessed only by the SYS user
- B. It can display multiple rows but only a single column
- C. It can display multiple rows and columns
- D. It can be accessed by any user who has the SELECT privilege in any schema
- E. It can be used to display only constants or pseudo columns
- F. It consists of a single row and single column of VARCHAR2 data type
Answer: A,F
Explanation:
https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION # 76
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 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 generated undo is stored in SYSTEM.
Answer: C
Explanation:
Explanation
NEW QUESTION # 77
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 only by the SYS user
- C. It can display multiple rows and columns
- D. It can be accessed by any user who has the SELECT privilege in any schema
- E. It can be used to display only constants or pseudo columns
- F. It consists of a single row and single column of VARCHAR2 data type
Answer: C,F
NEW QUESTION # 78
Which three statements are true concerning logical and physical database structures? (Choose three.)
- A. A segment's blocks can be of different sizes
- B. A segment can span multiple data files in some tablespaces
- C. A segment might have only one extent
- D. The extents of a segment must always reside in the same datafile
- E. A smallfile tablespace might be bigger than a bigfile tablespace
- F. Segments can span multiple tablespsaces
- G. All tablespaces may have one or more data files
Answer: C,E,F
NEW QUESTION # 79
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_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
- C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
- D. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
- E. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
Answer: B,C
NEW QUESTION # 80
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 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- B. Employees 100 and 200 will have the same SALARY as before the update command
- C. Employee 100 will have SALARY set to the same value as the SALARY 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 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
Answer: C,F
NEW QUESTION # 81
Which two are true about shrinking a segment online? (Choose two.)
- A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- B. To shrink a table it must have row movement enabled
- C. To shrink a table it must have a UNIQUE KEY constraint
- D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- E. To shrink a table it must have a PRIMARY KEY constraint
- F. It always eliminates all migrated rows if any exist in the table
Answer: B,E
NEW QUESTION # 82
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, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
Answer: A
NEW QUESTION # 83
Which two statements are true about single row functions? (Choose two.)
- A. FLOOR : returns the smallest integer greater than or equal to a specified number
- B. MOD : returns the quotient of a division operation
- C. CONCAT : can be used to combine any number of values
- D. TRUNC : can be used to combine any number of values
- E. CEIL : can be used for positive and negative numbers
Answer: B,D
NEW QUESTION # 84
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 != NULL AND cust_credit_level !=NULL;
- B. 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;
- C. 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;
- D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;
- E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;
Answer: B
NEW QUESTION # 85
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Register a new database with an available Enterprise Manager Management server
- C. Configure a nonstandard block size for a new database
- D. Change the standard block size of an existing database
- E. Enable flashback database for an existing database
Answer: B,D
Explanation:
https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION # 86
Examine these commands:
Which two statements are true about the sqlldrexecution? (Choose two.)
- A. It appends data from EMP.DAT to EMP
- B. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- C. It uses the database buffer cache to load data
- 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: C,D
NEW QUESTION # 87
......
Authentic 1Z0-082 Dumps With 100% Passing Rate Practice Tests Dumps: https://www.exams4collection.com/1Z0-082-latest-braindumps.html
Oracle 1Z0-082 Real Exam Questions Guaranteed Updated Dump from Exams4Collection: https://drive.google.com/open?id=183_z1HPPDXkwsrDsu1VJvcP4K9a4qAyO
