[2024年03月29日] 1Z0-082のPDFで最近更新された問題です集試験点数を伸ばそう
1Z0-082完全版問題集には無料PDF問題で合格させる
質問 # 39
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. It supports diagnostics for Automatic Storage Management (ASM)
- B. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
- 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 is held inside an Oracle database schema
正解：B、E
解説：
https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
質問 # 40
Which statement is true about database links?
- A. A public database link can be created only by sys.
- B. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.
- C. A database link can be created only between two Oracle databases.
- D. Private database link creation requires the same user to exist in both the local and the remote databases.
- E. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
正解：E
質問 # 41
Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true?
- A. Queries and DML statements are allowed on ORDERS while the shrink is executing.
- B. Dependent indexes become UNUSABLE.
- C. The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
- D. The high-water mark (HWM) of orders is adjusted.
- E. Only queries are allowed on ORDERS while the shrink is executing.
- F. The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.
正解：A、C
質問 # 42
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- 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;
正解：C
質問 # 43
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, join_date, SUM(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;
正解：C
質問 # 44
Which statement is true about aggregate functions?
- A. Aggregate functions can be nested to any number of levels
- B. Aggregate functions can be used in any clause of a SELECT statement
- C. The MAX and MIN functions can be used on columns with character data types
- D. The AVG function implicitly converts NULLS to zero
正解：A
質問 # 45
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. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
- C. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- D. The CURRENT_TIMESTAMP function returns data without time zone information
- E. A TIMESTAMP data type column contains information about year, month, and day
正解：A、C、D
質問 # 46
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 generated undo is stored in SYSAUX.
- B. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- C. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- D. It succeeds and the generated undo is stored in SYSTEM.
- E. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
正解：E
解説：
To guarantee the success of long-running queries or Oracle Flashback operations, you can enable retention guarantee. If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system. This option is disabled by default.
質問 # 47
Examine the description of the BOOKS_TRANSACTIONS table:
- A. WHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101', 'A102');
- B. WHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR member_id = 'A102');
- C. WHERE borrowed_date = SYSDATE AND {transaction_type = 'RM* AND (raeraber_id = 'A101' OR member_id = 'A102));
- D. WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101', 'A102'));
正解：A、D
解説：
E, WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');
質問 # 48
Examine this command and some partial output:
Why does the DB01.abc.comservice show unknown status?
- A. The service DB01.abc.com is dynamically registered
- B. The listener is not listening on the default port 1521
- C. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
- D. The service DB01.abc.com is statically registered
- E. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
正解：E
質問 # 49
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 NVL(cust_credit_limit * .15, `Not Available') FROM customers;
- C. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- D. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
- E. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
正解：A、D
質問 # 50
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.
Which query can be used?
- A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
- B. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
- C. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
- D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;
正解：D
質問 # 51
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)
- A. one instance on one server associated with one database
- B. two or more instances on separate servers all associated with one database
- C. one instance on one server not associated with any database
- D. one instance on one server associated with two or more databases on separate servers
- E. one instance on one server associated with two or more databases on the same server
正解：A、B、C
質問 # 52
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. It supports diagnostics for Oracle Clusterware
- B. It supports diagnostics for Automatic Storage Management (ASM)
- 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 is held inside an Oracle database schema
- E. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
正解：A、B
解説：
The database, Oracle Automatic Storage Management (Oracle ASM), the listener, Oracle Clusterware, and other Oracle products or components store all diagnostic data in the ADR. https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11260
質問 # 53
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
正解：A、B
解説：
Explanation/Reference: https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
質問 # 54
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 second ROLLBACK command does nothing
- B. The second ROLLBACK command undoes the insert
- C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
- D. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
- E. The second ROLLBACK command replays the delete
正解：B、D
質問 # 55
Which three failures require intervention for recovery? (Choose three.)
- A. statement failure
- B. network interface card (NIC) failure
- C. user process failure
- D. media failure
- E. a user error such as dropping the wrong table
正解：C、D、E
質問 # 56
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 gives an error because the GROUP BY clause is not valid
- B. It executes successfully and gives the required result
- C. It gives an error because the ALL keyword is not valid
- D. It executes successfully but does not give the required result
正解：B
質問 # 57
Which two statements are true about the results of using the INTERSECT operator in compound queries?
(Choose two.)
- A. INTERSECT ignores NULLs
- B. INTERSECT returns rows common to both sides of the compound query
- C. Reversing the order of the intersected tables can sometimes affect the output
- D. The number of columns in each SELECT in the compound query can be different
- E. Column names in each SELECT in the compound query can be different
正解：A、E
質問 # 58
Which two actions can you perform using DBCA for an existing database?
- A. Change the character set.
- B. Create an additional listener.
- C. Create a template that can be used to clone the database.
- D. Create nonstandard block size tablespaces.
- E. Change the server mode from dedicated to shared, and vice versa.
正解：A、E
質問 # 59
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 LOCAL TIMEZONE
- C. INTERVAL DAY TO SECOND
- D. INTERVAL YEAR TO MONTH
- E. TIMESTAMP WITH TIMEZONE
正解：C
質問 # 60
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)
- A. CONCAT (qty_sold, invoice_date) : requires explicit conversion
- B. qty_sold = '0554982' uses implicit conversion
- C. qty_sold BETWEEN '101' AND '110' : uses implicit conversion
- D. invoie_date > '01-02-2019' : uses implicit conversion
- E. invoice_date = '15-march-2019' : uses implicit conversion
正解：C、E
質問 # 61
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
- A. Usernames of all users including database administrators are stored in the data dictionary
- B. It is owned by the SYSTEM user
- C. The data dictionary is created and maintained by the database administrator
- D. Base tables can be queried directly
- E. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
- F. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
正解：A、D、E
質問 # 62
Which two are true about the roles? (Choose two.)
- A. All privileges and roles granted to a user are enabled by default when the user logs in.
- B. The SET ROLE statement can be used once per session.
- C. The SET ROLE statement enables as well as disables roles in a session.
- D. The ALTER USER statement must be used to set specific default roles for a user.
- E. A role must be disabled before it can be revoked from a user.
正解：A、C
質問 # 63
......
Oracle 1Z1-082試験を受験するには、データベース管理の概念に堅固な理解を持ち、Oracleデータベースでの作業経験が必要です。この試験は80問の多肢選択問題から成り、2時間以内に完了する必要があります。試験の合格基準は63％であり、試験に合格した候補者はOracle Database Administration I認定を受け取ります。全体的に、Oracle 1Z1-082試験は、データベース管理者志望者がOracleデータベースの管理に関する知識とスキルを証明し、この分野でのキャリアを発展させるための素晴らしい方法です。
Oracle 1Z1-082試験は、80の複数選択の質問で構成される2時間のテストです。これは、承認されたテストセンターまたはオンラインで撮影できる提案された試験です。試験に合格するには、候補者は少なくとも63％を獲得し、データベース管理のさまざまな分野で習熟度を実証する必要があります。試験の正常に完了すると、Oracle Database Administration I認定につながります。これは、世界中で認識されており、専門家がIT業界でキャリアを進めるのに役立ちます。
100%更新されたのはOracle 1Z0-082限定版PDF問題集：https://jp.fast2test.com/1Z0-082-premium-file.html
無料Oracle Database 19c 1Z0-082公式認定ガイドPDFダウンロード：https://drive.google.com/open?id=1u6nM0LqLtUrKm8issuHYK5c67Idvp-QL