Get instant access to 1Z0-082 Practice Tests 2021 Free Updated Today!
Welcome to download the newest PassLeader 1Z0-082 PDF dumps ( 118 Q&As)
NEW QUESTION 19
Examine this command:
Which two statements are true? (Choose two.)
- A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- C. The file is renamed and stored in the same location
- D. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
- E. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
Answer: A,D
NEW QUESTION 20
Which two functions are performed by a listener?
- A. connecting a user process to a server process
- B. verifying the service name in an incoming user request
- C. creating a user session in the System Global Area (SGA)
- D. maintaining the connection to a client's user process until the user request is completed
- E. returning the results of processing from the server process to the user process
- F. verifying a user's authentication credentials
Answer: A,E
NEW QUESTION 21
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
- A. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
- C. SYSDATE can be queried only from the DUAL table
- D. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- E. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
- F. CURRENT_DATE returns the current date and time as per the session time zone
Answer: C,F
NEW QUESTION 22
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_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;
- B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
- C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
- D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;
- E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;
Answer: D
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_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
- B. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
- C. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
- D. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
- E. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
Answer: B,C
NEW QUESTION 24
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, MAX(AVG(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, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
Answer: A
NEW QUESTION 25
A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?
- A. The command fails and reports an error because @ is used twice
- B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
- C. The command succeeds and HR will be connected to the orcl and abc.sql databases
- D. The command fails because the script must refer to the full path name
Answer: B
Explanation:
Explanation
NEW QUESTION 26
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 be the name of the database to whose instance HR wishes to connect
- C. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
- D. It must be the value of the SERVICE_NAMES parameter on the client side
- E. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
Answer: A
NEW QUESTION 27
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 uses the database buffer cache to load data
- C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- 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: B,D
NEW QUESTION 28
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
- A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- B. The SESSIONTIMEZONE 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 29
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 30
You execute this command:
During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)
- A. It terminates
- B. It continues to run in the background
- C. You can no longer monitor it
- D. You can reattach to it and monitor it
- E. It is paused and can be resumed
Answer: A,C
NEW QUESTION 31
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?
- A. It generates an error
- B. It returns the date for the first Monday of the next month
- C. It executes successfully but does not return any result
- D. It returns the date for the last Monday of the current month
Answer: B
NEW QUESTION 32
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. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- E. To shrink a table it must have a PRIMARY KEY constraint
- F. To shrink a table it must have row movement enabled
Answer: E,F
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION 33
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 written undo block of UNDOTBS1 is overwritten by the generated undo.
- B. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- C. It succeeds and the generated undo is stored in SYSAUX.
- 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: A
Explanation:
Explanation
NEW QUESTION 34
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
- A. NULLS are not ignored during duplicate checking
- B. The output is sorted by the UNION ALL operator
- C. The number of columns selected in each SELECT statement must be identical
- D. The names of columns selected in each SELECT statement must be identical
- E. Duplicates are eliminated automatically by the UNION ALL operator
Answer: A,C
NEW QUESTION 35
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 REDO
- C. DML modifies Oracle database objects and only generates UNDO
- D. The generation of UNDO generates REDO
Answer: A,D
NEW QUESTION 36
......
Oct-2021 Latest ITExamDownload 1Z0-082 Exam Dumps with PDF and Exam Engine: https://www.itexamdownload.com/1Z0-082-valid-questions.html
Premium Quality Oracle 1Z0-082 Online dumps: https://drive.google.com/open?id=1B2b9zXnH7f-8YFwXOv0J-fJlAEtOrcsG