Valid 1Z0-082 Exam Q&A PDF 1Z0-082 Dump is Ready (Updated 118 Questions)
Exam Questions and Answers for 1Z0-082 Study Guide
NEW QUESTION 18
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 19
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 20
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, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- C. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
Answer: B
NEW QUESTION 21
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. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
- E. Unexpired UNDO is always retained.
Answer: D,E
NEW QUESTION 22
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 23
You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)
- A. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
- B. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;
- C. SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
- D. SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;
- E. SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
Answer: B,E
NEW QUESTION 24
Which two tasks can be performed in the NOMOUNT state? (Choose two.)
- A. full database recovery
- B. re-creating control files
- C. enabling online redo log archiving
- D. renaming data files
- E. creating a database
Answer: B,E
NEW QUESTION 25
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. Log in to the database instance
- B. Execute DML statements in the HR schema
- C. Revoke the CREATE SESSION privilege from user HR
- D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
- E. Revoke the CREATE SESSION privilege from other users
- F. Execute DDL statements in the HR schema
Answer: A,D,E
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224
NEW QUESTION 26
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 27
Which three activities are recorded in the database alert log? (Choose three.)
- A. non-default database parameters
- B. Data Definition Language (DDL) statements
- C. deadlock errors
- D. block corruption errors
- E. session logins and logouts
Answer: A,C,D
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION 28
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 temporary tablespace
- B. in the SGA
- C. in the SYSAUX tablespace
- D. in the PGA
- E. in the undo tablespace
Answer: A
Explanation:
http://www.dba-oracle.com/t_temp_undo_enabled.htm
NEW QUESTION 29
Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?
- A. Statement 2 returns only one row of output.
- B. Statement 2 may return multiple rows of output.
- C. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- D. Both the statements give the same output.
- E. Statement 1 returns only one row of output.
Answer: B,C
NEW QUESTION 30
Which three statements are true about a self join? (Choose three.)
- A. It must be an equijoin
- B. It can be an outer join
- C. The query must use two different aliases for the table
- D. It must be an inner join
- E. The ON clause must be used
- F. The ON clause can be used
Answer: B,C,F
NEW QUESTION 31
Which three statements are true concerning logical and physical database structures? (Choose three.)
- A. Segments can span multiple tablespaces
- B. All tablespaces may have one or more data files
- C. A segment might have only one extent
- D. A segment can span multiple data files in some tablespaces
- E. A smallfile tablespace might be bigger than a bigfile tablespace
- F. A segment's blocks can be of different sizes
- G. The extents of a segment must always reside in the same datafile
Answer: A,C,E
NEW QUESTION 32
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_linit * .15, 'Not Available') FROM customers;
- B. SELECT NVL2(cust_credit_linit * .15, 'Not Available') FROM customers;
- C. SELECT NVL2(cust_credit_limit, TO_CHAR(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 33
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. The same port number can be used for Database Express configurations for databases on different hosts
- B. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- C. It can be used to perform database recovery
- D. It is available only when the database is open
- E. It can be used to switch a database into ARCHIVELOGMODE
Answer: B,E
NEW QUESTION 34
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. Log in to the database instance
- B. Execute DML statements in the HR schema
- C. Revoke the CREATE SESSION privilege from user HR
- D. Execute DDL statements in the HR schema
- E. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
- F. Revoke the CREATE SESSION privilege from other users
Answer: D,E,F
NEW QUESTION 35
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
- A. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
- B. Primary key and foreign key constraints can be defined at both the column and table level
- C. A table can have only one primary key but multiple foreign keys
- D. The foreign key columns and parent table primary key columns must have the same names
- E. Only the primary key can be defined at the column and table level
- F. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
- G. A table can have only one primary key and one foreign key
Answer: A,B,C,D
NEW QUESTION 36
Which three statements are true about single-row functions? (Choose three.)
- A. The data type returned can be different from the data type of the argument
- B. They return a single result row per table
- C. They can be nested to any level
- D. They can be used only in the WHERE clause of a SELECT statement
- E. They can accept only one argument
- F. The argument can be a column name, variable, literal or an expression
Answer: A,B,F
Explanation:
https://www.folkstalk.com/2012/01/oracle-single-row-functions-examples.html
NEW QUESTION 37
In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?
- A. It must be the name of the server running the database to whose instance HR wishes to connect
- B. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
- C. It must be the name of the database to whose instance HR wishes to connect
- D. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
- E. It must be the value of the SERVICE_NAMES parameter on the client side
Answer: B
NEW QUESTION 38
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 39
......
Certification dumps - Oracle Database 19c 1Z0-082 guides - 100% valid: https://www.dumpexams.com/1Z0-082-real-answers.html
100% Pass Your 1Z0-082 Oracle Database Administration I at First Attempt with Dumpexams: https://drive.google.com/open?id=1f5OOim3_qxgVMdeXr7Bq5Ueu12rforqb