Updated Sep-2021 Test Engine or PDF for the Oracle 1Z0-082 test to help you quickly prepare for the Oracle exam!
Full 1Z0-082 Practice Test and 118 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 54
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)
- A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- C. 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
- D. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
Answer: A,B
NEW QUESTION 55
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
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224
NEW QUESTION 56
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 200 will have SALARY set to the same value as the SALARY of employee 100
- B. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
- C. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- D. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- E. Employees 100 and 200 will have the same JOB_ID as before the update command
- F. Employees 100 and 200 will have the same SALARY as before the update command
Answer: B,D
NEW QUESTION 57
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 58
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:
Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
- A. The sales user must have a quota on the TEMP tablespace
- B. The sales user must have been granted the CREATE TABLE privilege
- C. The sales user must have been granted the CREATE SESSION privilege
- D. The sales user must have their quota on the users tablespace removed
- E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
- F. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
Answer: B,D,F
NEW QUESTION 59
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. It supports diagnostics for Oracle Clusterware
- B. It supports diagnostics for Automatic Storage Management (ASM)
- C. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- D. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
- E. It is held inside an Oracle database schema
Answer: D,E
Explanation:
https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
NEW QUESTION 60
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 61
Examine this command and some partial output:
Why does the DB01.abc.com service show unknown status?
- A. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- B. The service DB01.abc.com is statically registered
- C. The service DB01.abc.com is dynamically registered
- D. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
- E. The listener is not listening on the default port 1521
Answer: B
NEW QUESTION 62
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- B. A synonym can be available to all users
- C. A SEQUENCE can have a synonym
- D. A synonym created by one user can refer to an object belonging to another user
- E. A synonym cannot be created for a PL/SQL package
Answer: B,C,D
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION 63
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 64
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 Oracle background processes are started
- B. The online redo logs are opened
- C. The control file is read
- D. The alert log records the execution details
- E. The initialization parameter file is read
- F. The online data files are opened
Answer: A,C
NEW QUESTION 65
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. They can be written by server processes
- C. They can be written by background processes
- D. Trace file names are based on the database name concatenated with a sequential number
- E. Trace files are written to the Fast Recovery Area (FRA)
Answer: B,C
Explanation:
Explanation/Reference: https://gerardnico.com/db/oracle/trace_file
NEW QUESTION 66
Which two statements are true about the rules of precedence for operators? (Choose two.)
- A. Multiple parentheses can be used to override the default precedence of operators in an expression
- B. NULLS influence the precedence of operators in an expression
- C. The concatenation operator | | is always evaluated before addition and subtraction in an expression
- D. The + binary operator has the highest precedence in an expression in a SQL statement
- E. Arithmetic operators with equal precedence are evaluated from left to right within an expression
Answer: A,D
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
NEW QUESTION 67
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- A. The number of columns in each SELECT in the compound query can be different
- B. Reversing the order of the intersected tables can sometimes affect the output
- C. Column names in each SELECT in the compound query can be different
- D. INTERSECT ignores NULLs
- E. INTERSECT returns rows common to both sides of the compound query
Answer: C,D
NEW QUESTION 68
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. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
- C. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
- 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 69
......
Get Latest 1Z0-082 Dumps Exam Questions: https://drive.google.com/open?id=1mp1-7BALa8UY5VYqMqreSEnWZTA5O2Ck
Full 1Z0-082 Practice Test and 118 unique questions with explanations waiting just for you, get it now: https://www.topexamcollection.com/1Z0-082-vce-collection.html
