[2022年04月] 無料1Z0-082試験問題集試験点数を伸ばそう
2022年最新の1Z0-082実際問題集には試験のコツがあるPDF試験材料
Oracle 1Z0-082 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
| トピック 12 |
|
| トピック 13 |
|
| トピック 14 |
|
| トピック 15 |
|
| トピック 16 |
|
| トピック 17 |
|
| トピック 18 |
|
| トピック 19 |
|
質問 34
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
- A. Undo segments must be stored in a SMALLFILE tablespace
- B. Undo segments must be stored in a BIGFILE tablespace
- C. Undo segments can extend when a transaction fills the last extent of the undo segment
- D. A single transaction may use multiple undo segments simultaneously
- E. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
- F. Undo segments have a minimum of three extents
- G. An undo segment may be used by multiple transactions simultaneously
正解: A,C,G
質問 35
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:
What must you do so that KING is authenticated by the OS when connecting to the database instance?
- A. Set OS_AUTHENT_PREFIX to OPS$
- B. Have the OS administrator add KING to the OSDBA group
- C. Alter user KING to be IDENTIFIED EXTERNALLY
- D. Unset REMOTE_LOGIN_PASSWORDFILE
- E. Grant DBA to KING
正解: D
質問 36
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. Arithmetic operators with equal precedence are evaluated from left to right within 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. The concatenation operator | | is always evaluated before addition and subtraction in an expression
正解: A,B
解説:
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.
質問 37
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
- A. Free space is managed using freelists
- B. It uses the database default blocksize
- C. Any data files added to the tablespace must have a size of 5 gigabytes
- D. It must be smaller than the smallest BIGFILE tablespace
- E. It is a locally managed tablespace
正解: B,E
質問 38
Examine the description of the CUSTOMERS table:
You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?
- A. SELECT * FROM customers WHERE city = 'D_%';
- B. SELECT * FROM customers WHERE city = '%D_';
- C. SELECT * FROM customers WHERE city LIKE 'D_%';
- D. SELECT * FROM customers WHERE city LIKE 'D_';
正解: C
質問 39
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
- B. TIMESTAMP WITH TIMEZONE
- C. INTERVAL YEAR TO MONTH
- D. INTERVAL DAY TO SECOND
- E. TIMESTAMP WITH LOCAL TIMEZONE
正解: D
質問 40
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 ignores NULLs
- C. Reversing the order of the intersected tables can sometimes affect the output
- D. Column names in each SELECT in the compound query can be different
- E. INTERSECT returns rows common to both sides of the compound query
正解: B,D
質問 41
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 for the current instance and in the PFILE
- B. The value is changed only in the PFILE and takes effect at the next instance startup
- C. It fails because the SCOPE clause is missing
- D. Change is applied to the current instance, but does not persist after instance restart
正解: D
解説:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
質問 42
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Multiple row pieces from the same row may be stored in different database blocks
- B. Data block headers contain their own Data Block Address (DBA)
- C. Data block free space is always contiguous in the middle of the block
- D. A table row piece can be chained across several database blocks
- E. Index block free space is always contiguous in the middle of the block
- F. Multiple row pieces from the same row may be stored in the same block
正解: A,C,D
解説:
Explanation/Reference: https://books.google.com.pk/books?id=lNtVjrmbzckC&pg=PA267&lpg=PA267&dq=Multiple+row
+pieces+from+the+same+row+may+be+stored+in+different+database
+blocks&source=bl&ots=lEIhFe2Q52&sig=ACfU3U1TETJPy194pARxfIJ5ROaQdySCMQ&hl=en&sa=X&ved=2 ahUKEwivveLa97_mAhWOzaQKHahYAVEQ6AEwAnoECAoQAQ#v=onepage&q=Multiple%20row%20pieces
%20from%20the%20same%20row%20may%20be%20stored%20in%20different%20database%
20blocks&f=false
質問 43
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 cycles back to 1 after every 5000 numbers and can cycle 20 times
- C. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- D. 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
- E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
正解: A,E
質問 44
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. The ADR base defaults to $ORACLE_HOME/rdbms/admin if
neither DIAGNOSTIC_DEST nor ORACLE_BASE is set - B. It is held inside an Oracle database schema
- C. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- D. It supports diagnostics for Oracle Clusterware
- E. It supports diagnostics for Automatic Storage Management (ASM)
正解: A,B
解説:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
質問 45
Which two statements are true about the PMON background process? (Choose two.)
- A. It kills sessions that exceed idle time
- B. It frees resources held by abnormally terminated processes
- C. It records checkpoint information in the control file
- D. It frees unused temporary segments
- E. It registers database services with all local and remote listeners known to the database instance
正解: B,E
解説:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
質問 46
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- B. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- C. SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
- D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
- E. SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
正解: A,B
質問 47
Which three activities are recorded in the database alert log? (Choose three.)
- A. deadlock errors
- B. non-default database parameters
- C. block corruption errors
- D. Data Definition Language (DDL) statements
- E. session logins and logouts
正解: A,B,C
解説:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
質問 48
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, join_date;
- 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;
- D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
正解: A
質問 49
......
心強い1Z0-082のPDF問題集は1Z0-082問題：https://jp.fast2test.com/1Z0-082-premium-file.html
正真正銘の1Z0-082問題集で無料PDF問題で合格させる：https://drive.google.com/open?id=11JRx9tdO336I95MjMDdfxEOcsmK7Aphy