Oracle 1Z0-082 Cert Guide PDF 100% Cover Real Exam Questions
Pass 1Z0-082 Exam - Real Questions and Answers
NEW QUESTION # 36
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 space allocation occurs at session start.
- C. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- D. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- E. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
Answer: C,D,F
NEW QUESTION # 37
Which two statements are true about single row functions? (Choose two.)
- A. CEIL : can be used for positive and negative numbers
- B. TRUNC : can be used with NUMBERand DATEvalues
- C. FLOOR : returns the smallest integer greater than or equal to a specified number
- D. CONCAT : can be used to combine any number of values
- E. MOD : returns the quotient of a division operation
Answer: B,E
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C
NEW QUESTION # 38
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. You can reattach to it and monitor it
- B. It continues to run in the background
- C. You can no longer monitor it
- D. It is paused and can be resumed
- E. It terminates
Answer: A,D
NEW QUESTION # 39
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
- A. Increase U1's quota sufficiently in DATA
- B. Set AUTOEXTEND ON for data files in DATA
- C. Drop other U1 objects in DATA
- D. Add a data file to DATA
- E. Set DEFERRED_SEGMENT_CREATION to TRUE
- F. Grant UNLIMITED TABLESPACE to U1
Answer: A,C,F
NEW QUESTION # 40
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 resolve to a valid connect descriptor in the server's tnsnames.ora file
- B. It must be the value of the SERVICE_NAMES parameter on the client side
- C. It must be the name of the database to whose instance HR wishes to connect
- D. It must be the name of the server running the database to whose instance HR wishes to connect
- E. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
Answer: D
NEW QUESTION # 41
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- B. 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
- C. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- D. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
Answer: B,C
NEW QUESTION # 42
Your database instance is started with a PFILE.
Examine these parameters:
You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?
- A. Change is applied to the current instance, but does not persist after instance restart
- B. It fails because the SCOPE clause is missing
- C. The value is changed for the current instance and in the PFILE
- D. The value is changed only in the PFILE and takes effect at the next instance startup
Answer: A
Explanation:
Reference:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
NEW QUESTION # 43
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. It can be used to perform database recovery
- B. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- C. The same port number can be used for Database Express configurations for databases on different hosts
- D. It can be used to switch a database into ARCHIVELOGMODE
- E. It is available only when the database is open
Answer: C,E
NEW QUESTION # 44
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. To shrink a table it must have a UNIQUE KEY constraint
- D. To shrink a table it must have row movement enabled
- E. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
Answer: D,F
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION # 45
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)
- A. Additional data files may not be added
- B. It will be a dictionary-managed tablespace by default
- C. AUTOEXTEND is possible for the datafile
- D. It will always have a 32K blocksize
- E. It must be bigger than the largest SMALLFILE tablespace
Answer: C,E
NEW QUESTION # 46
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
- A. TIMESTAMP WITH TIMEZONE
- B. TIMESTAMP
- C. INTERVAL YEAR TO MONTH
- D. INTERVAL DAY TO SECOND
- E. TIMESTAMP WITH LOCAL TIMEZONE
Answer: D
NEW QUESTION # 47
Which statement is true about the INTERSECT operator used in compound queries?
- A. It processes NULLs in the selected columns
- B. INTERSECT is of lower precedence than UNION or UNION ALL
- C. It ignores NULLs
- D. Multiple INTERSECT operators are not possible in the same SQL statement
Answer: A
NEW QUESTION # 48
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 executes successfully but does not give the required result
- B. It executes successfully and gives the required result
- C. It gives an error because the ALL keyword is not valid
- D. It gives an error because the GROUP BY clause is not valid
Answer: B
NEW QUESTION # 49
Which two statements are true about the PMON background process? (Choose two.)
- A. It frees resources held by abnormally terminated processes
- B. It registers database services with all local and remote listeners known to the database instance
- C. It kills sessions that exceed idle time
- D. It frees unused temporary segments
- E. It records checkpoint information in the control file
Answer: A,C
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
* Performs process recovery when a user process fails - Cleans up the database buffer cache - Frees resources that are used by the user process * Monitors sessions for idle session timeout
NEW QUESTION # 50
Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
- A. Add the NOLOGGING clause
- B. Set UNDO_TABLESPACE to UNDOTBS01
- C. Add the SEGMENT SPACE MANAGEMENT AUTO clause
- D. Add the ONLINE clause
- E. Make certain that the database operates in automatic undo management mode
Answer: B,E
NEW QUESTION # 51
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 ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
- B. SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;
- C. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;
- D. SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
- E. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
Answer: A,C
NEW QUESTION # 52
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
- A. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
- B. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
- C. Partition key columns cannot be dropped.
- D. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
- E. A DROP COLUMN command can be rolled back
- F. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
Answer: A,C,D
NEW QUESTION # 53
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 SYSAUX tablespace
- B. in the PGA
- C. in the SGA
- D. in the temporary tablespace
- E. in the undo tablespace
Answer: E
NEW QUESTION # 54
Which three statements are true about roles?
- A. The SET ROLE statement can disable one or more roles for a session.
- B. The SET ROLE statement can enable one or more roles for a session.
- C. Roles may be granted to roles.
- D. Roles must be password protected.
- E. All roles granted to a user are set on by default when the user logs in,
- F. Object privileges may not be granted to roles.
Answer: A,C,F
NEW QUESTION # 55
Which two statements are true about the rules of precedence for operators? (Choose two.)
- A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
- B. Multiple parentheses can be used to override the default precedence of operators in an expression
- C. The + binary operator has the highest precedence in an expression in a SQL statement
- D. NULLS influence the precedence of operators in an expression
- E. Arithmetic operators with equal precedence are evaluated from left to right within an expression
Answer: B,E
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.
NEW QUESTION # 56
......
100% Free 1Z0-082 Daily Practice Exam With 145 Questions: https://braindumps.actual4exams.com/1Z0-082-real-braindumps.html