[2022年09月13日] 最新1Z0-082のPDF問題集リアル無料テスト本日更新です
1Z0-082問題集には100%厳密検証された問題と解答で合格保証もしくは全額返金
質問 71
Which three statements are true about using SQL*Plus?
- A. It has its own commands that are separate from any SQL statements.
- B. It must be downloaded from the Oracle Technology Network (OTN).
- C. It has both command-line and graphical user interfaces (GUI).
- D. It can run Recovery Manager (RMAN) commands.
- E. It can run scripts entered at the SQL prompt.
- F. It can run scripts passed to it by a shell script.
正解: A,B,E
質問 72
Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)
- A. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
- B. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
- C. The second ROLLBACK command replays the delete
- D. The second ROLLBACK command does nothing
- E. The second ROLLBACK command undoes the insert
正解: B,E
質問 73
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)
- A. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
- B. The WHERE clause can be used to exclude rows before dividing them into groups
- 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 after dividing them into groups
- E. The HAVING clause can be used with aggregating functions in subqueries
正解: B,E
質問 74
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. The value is changed only in the PFILE and takes effect at the next instance startup
- B. It fails because the SCOPE clause is missing
- C. The value is changed for the current instance and in the PFILE
- D. Change is applied to the current instance, but does not persist after instance restart
正解: D
解説:
Explanation/Reference: https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
質問 75
What is true about non-equijoin statement performance? (Choose two.)
- A. The join syntax used makes no difference to performance
- B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
- C. The BETWEEN condition always performs better than using the >= and <= conditions
- D. Table aliases can improve performance
- E. The BETWEEN condition always performs less well than using the >= and <= conditions
正解: B,D
解説:
https://stackoverflow.com/questions/58476906/1z0-071-oracle-exam-question-which-answers-is-correc
質問 76
What is true about non-equijoin statement performance? (Choose two.)
- A. The join syntax used makes no difference to performance
- B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
- C. The BETWEEN condition always performs better than using the >= and <= conditions
- D. Table aliases can improve performance
- E. The BETWEEN condition always performs less well than using the >= and <= conditions
正解: B,D
解説:
Explanation
質問 77
Which two statements are true about UNDO and REDO? (Choose two.)
- A. The generation of UNDO generates REDO
- B. DML modifies Oracle database objects and only generates REDO
- C. DML modifies Oracle database objects and only generates UNDO
- D. The generation of REDO generates UNDO
正解: A,D
質問 78
An Oracle database session has an uncommitted transaction in progress which updated 5000 rows in a table.
Which three situations does the transaction complete thereby committing the updates?
- A. when a CREATE INDEX statement is executed successfully in the same session
- B. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
- C. when the session logs out successfully
- D. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session
- E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
- F. when a COMMIT statement is issued by the same user from another session in the same database instance
正解: A,B,C
質問 79
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
- A. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
- B. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
- C. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
- D. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
- E. A block will always be eligible for inserts if the row is short enough to fit into the block
正解: B,E
質問 80
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
- A. They can be written by server processes
- B. All trace files contain error information that require contacting Oracle Support
- C. Trace file names are based on the database name concatenated with a sequential number
- D. Trace files are written to the Fast Recovery Area (FRA)
- E. They can be written by background processes
正解: A,E
解説:
Reference:
https://docs.oracle.com/html/E25494_01/monitoring001.htm
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 applications and instances.
質問 81
Which three statements are true about a self join? (Choose three.)
- A. It must be an equijoin
- B. The ON clause must be used
- C. The ON clause can be used
- D. It can be an outer join
- E. The query must use two different aliases for the table
- F. It must be an inner join
正解: C,D,E
質問 82
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and 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 1 returns only one row of output.
- B. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- C. Both the statements give the same output.
- D. Statement 2 returns only one row of output.
- E. Statement 2 may return multiple rows of output.
正解: A,E
解説:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj27781.html
The Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in data type. You can therefore call methods that evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.
質問 83
Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)
- A. Unexpired UNDO is always retained.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
- C. Active UNDO is always retained.
- D. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
- E. UNDO_RETENTION specifies how long all types of UNDO are retained.
正解: A,D
質問 84
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. The value is changed only in the PFILE and takes effect at the next instance startup
- B. It fails because the SCOPE clause is missing
- C. The value is changed for the current instance and in the PFILE
- D. Change is applied to the current instance, but does not persist after instance restart
正解: D
解説:
Explanation/Reference: https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
質問 85
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?
- A. no segments are created
- B. T1 and an index segment created for the primary key only
- C. T1, an index segment for the primary key, and a LOB segment only
- D. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- E. T1 only
正解: E
解説:
Explanation/Reference:
質問 86
Examine the description of the product_details table:
Which two statements are true?
- A. PRODUCT_NAKE cannot contain duplicate values.
- B. PRODUCT _ic can be assigned the PRIMARY KEY constraint.
- C. EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.
- D. PRODUCT _price contains the value zero by default if no value is assigned to it.
- E. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.
- F. EXPIRY_ DATE cannot be used in arithmetic expressions.
正解: B,E
質問 87
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
正解: C,E
解説:
Explanation/Reference: https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
質問 88
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
- A. The CURRENT_TIMESTAMP function returns data without time zone information
- B. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- C. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- D. A TIMESTAMP data type column contains information about year, month, and day
- E. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
正解: B,C,E
質問 89
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. INTERVAL YEAR TO MONTH
- B. INTERVAL DAY TO SECOND
- C. TIMESTAMP WITH TIMEZONE
- D. TIMESTAMP
- E. TIMESTAMP WITH LOCAL TIMEZONE
正解: B
質問 90
......
Oracle 1Z0-082 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
| トピック 12 |
|
| トピック 13 |
|
| トピック 14 |
|
| トピック 15 |
|
2022年最新の有効な1Z0-082テスト解答Oracle試験PDF：https://jp.fast2test.com/1Z0-082-premium-file.html
合格させるOracle 1Z0-082試験には練習テスト問題集豪華お試しセット：https://drive.google.com/open?id=11JRx9tdO336I95MjMDdfxEOcsmK7Aphy