Oracle Database Administration I (1Z0-082) Exam Dumps 2024
Oracle Database Administration I (1Z0-082) Exam Dumps 2024
Visit Official SkillCertPro Website :-
For a full set of 420+ questions. Go to
https://skillcertpro.com/product/oracle-database-administration-i-1z0-082-exam-questions/
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.
Question 1:
Which three statements are true about GLOBAL TEMPORARY TABLES?
(Choose three.)
A. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
B. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
C. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
E. A GLOBAL TEMPORARY TABLE‘S definition is available to multiple sessions.
F. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
Answer: D, E, F
Explanation:
Specify GLOBAL TEMPORARY to create a temporary table, whose definition is visible to all sessions with appropriate privileges. The data in a temporary table is visible only to the session that inserts the data into the table.
When you first create a temporary table, its metadata is stored in the data dictionary, but no space is allocated for table data. Space is allocated for the table segment at the time of the first DML operation on the table.
Question 2:
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
A. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
B. Each SELECT statement in the compound query must have its own ORDER BY clause
C. Each SELECT statement in the compound query can have its own ORDER BY clause
D. Only column names from the first SELECT statement in the compound query are recognized
E. Column positions must be used in the ORDER BY clause
Answer: A, D
Explanation:
You can use the column name or position in the ORDER BY clause.
For a compound query, the output will show column names from the first SELECT.
The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause - True
To remove duplicate rows when using UNION, Oracle does sort based on first column.
SELECTs in a compound query cannot have individual ORDER BY clause, only at the end.
Question 3:
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 no longer monitor it
B. It terminates
C. It continues to run in the background
D. You can reattach to it and monitor it
E. It is paused and can be resumed
Answer: D, E
Explanation:
You can reattach to it and monitor it – True
it is paused and can be resumed – True
The Oracle Data Pump Export interactive command mode STOP_JOB parameter stops the current job. It stops the job either immediately, or after an orderly shutdown, and exits Export.
Purpose
Stops the current job, either immediately, or after an orderly shutdown, and exits Export.
If the Data Pump control job table and dump file set are not disturbed when or after the STOP_JOB command is issued, then the job can be attached to and restarted at a later time with the START_JOB command.
To perform an orderly shutdown, use STOP_JOB (without any associated value). A warning requiring confirmation will be issued. An orderly shutdown stops the job after worker processes have finished their current tasks.
Question 4:
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 can accept only one argument
C. They can be nested to any level
D. They return a single result row per table
E. The argument can be a column name, variable, literal or an expression
F. They can be used only in the WHERE clause of a SELECT statement
Answer: A, C, E
Explanation:
Single-row functions like DECODE, ROUND etc can be used in SELECT as well as WHERE clauses of a SQL.
The argument can be a column, variable, literal or expression.
Example:
select DECODE(COALESCE(NVL(ROUND(TRUNC(5)),4),3),2)1) from dual;
Many functions accept more than one argument like DECODE.
For a table, these functions can return as many results as the number of rows in the table like ROUND() or just one results like SUM or anything else too like SUM combined with GROUP BY.
Question 5:
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?
A. INTERSECT
B. MINUS
C. SUBTRACT
D. UNION ALL
E. UNION
Answer: B
Explanation:
The operator MINUS is used to subtract the result set of one query from another’s.
For a full set of 420+ questions. Go to
https://skillcertpro.com/product/oracle-database-administration-i-1z0-082-exam-questions/
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.
Question 6:
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. INTERSECT returns rows common to both sides of the compound query
C. INTERSECT ignores NULLs
D. Reversing the order of the intersected tables can sometimes affect the output
E. Column names in each SELECT in the compound query can be different
Answer: B, E
Explanation:
Each SELECT can have different column names but data type and number of columns should be same. Output will show column names of the first SELECT.
INTERSECT returns rows common to both sides.
Question 7:
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
which compression option is best suited for this?
A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
B. ROW STORE COMPRESS ADVANCED
C. ROW STORE COMPRESS BASIC
D. COLUMN STORE COMPRESS FOR QUERY LOW
E. COLUMN STORE COMPRESS FOR ARCHIVE LOW
Answer: B
Explanation:
Advanced row compression caused minimum CPU Overload and is good for OLTP/DSS.
Question 8:
You execute this command:
A. It must be bigger than the largest SMALLFILE tablespace
B. It will always have a 32K blocksize
C. It will be a dictionary-managed tablespace by default
D. AUTOEXTEND is possible for the datafile
E. Additional data files may not be added
Answer: A, D
Explanation:
AUTOEXTEND is possible for any datafile. You cannot add a datafile to BIGFILE tablespaces.
Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment space management, with three exceptions: locally managed undo tablespaces, temporary tablespaces, and the SYSTEM tablespace.
Question 9:
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
A. Trace files are written to the Fast Recovery Area (FRA)
B. They can be written by server processes
C. They can be written by background processes
D. All trace files contain error information that require contacting Oracle Support
E. Trace file names are based on the database name concatenated with a sequential number
Answer: B, C
Explanation:
The trace file and alert log contain information about errors.
Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, and other information is for Oracle Support Services. Trace file information is also used to tune application and instances.
Question 10:
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 file is renamed and stored in the same location
C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
D. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
E. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
Answer: A, B
Explanation:
Ø Due to REUSE clause, the file will be renamed in same place.
Ø When you run the ALTER DATABASE MOVE DATAFILE statement and a file with the same name exists in the destination location, you can specify the REUSE option to overwrite the existing file. When REUSE is not specified, and a file with the same name exists in the destination location, the existing file is not overwritten, and the statement returns an error.
For a full set of 420+ questions. Go to
https://skillcertpro.com/product/oracle-database-administration-i-1z0-082-exam-questions/
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.