[2023年06月] 合格させるOracle 1Z0-082テストエンジンPDFで完全版無料問題集
Oracle Database Administration I練習テスト2023年最新の1Z0-082ストレスなしで合格！
Oracle 1Z0-082 試験は、IT プロフェッショナルが認定された Oracle データベース管理者になることを目指す認定試験であり、基本的なデータベースの概念、Oracle データベースのインストールと設定、データベースインスタンスの管理、ストレージ構造とセキュリティ、バックアップとリカバリ、パフォーマンスチューニングの知識とスキルを評価します。これは、より高度な Oracle データベース管理認定の基礎となる試験です。
Oracle 1Z0-082 認定試験は、Oracleデータベース管理者になるために必要な資格です。この試験は幅広いトピックをカバーしており、試験に合格することで、候補者がOracleデータベース環境を管理する知識とスキルを持っていることが証明されます。この試験は複数の言語で利用可能であり、候補者はOracleのウェブサイトで試験に登録することができます。
質問 # 75
Which three statements are true about single-row functions? (Choose three.)
- A. They can be nested to any level
- B. They return a single result row per table
- C. They can be used only in the WHERE clause of a SELECT statement
- D. They can accept only one argument
- E. The data type returned can be different from the data type of the argument
- F. The argument can be a column name, variable, literal or an expression
正解：B、E、F
質問 # 76
Which two statements are true about the SET VERIFY ON command? (Choose two.)
- A. It displays values for variables created by the DEFINE command
- B. It can be used only in SQL*Plus
- C. It displays values for variables used only in the WHERE clause of a query
- D. It can be used in SQL Developer and SQL*Plus
- E. It displays values for variables prefixed with &&
正解：D、E
質問 # 77
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, leaving the inserted row still to be committed
- B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
- C. The second ROLLBACK command undoes the insert
- D. The second ROLLBACK command replays the delete
- E. The second ROLLBACK command does nothing
正解：B、C
質問 # 78
What two are benefits of Data Pump? (Choose two.)
- A. It can execute in parallel.
- B. It represents database metadata information as DDL statements in the dump file.
- C. It makes use of client system resources.
- D. It can restart failed export jobs.
- E. It can export data into sequential media, such as tapes.
正解：A、D
質問 # 79
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
- A. as SYS in both the databases
- B. as SCOTT in BOSTON_DB
- C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- D. as SCOTT in DALLAS_DB
- E. as SCOTT in both the databases
正解：B
解説：
https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085 Database links are either private or public. If they are private, then only the user who created the link has access; if they are public, then all database users have access.
https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205
質問 # 80
Which two statements are true about Enterprise Manager (EM) Express?
- A. EM Express uses a separate repository database to store target database metadata.
- B. You cannot start up a database instance using EM Express.
- C. You can use a single instance of EM Express to manage multiple database running on the same server.
- D. By default, EM express is available for a database after database creation using DBCA.
- E. You can shut down a database instance using EM Express.
正解：D、E
質問 # 81
Which two are true about complete recovery? (Choose two.)
- A. Uncommitted transactions will be rolled back after it completes.
- B. Only RMAN backupsets can be used to restore a database as part of it.
- C. It is possible only when the database is in MOUNT state
- D. The database must have FLASHBACK enabled in order to perform it.
- E. Incremental backups can be used to roll forward the database while performing it.
正解：C、D
質問 # 82
The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Andersen and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?
- A. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
- B. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
- C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;
- D. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
正解：A
質問 # 83
Examine this command:
Which two statements are true?
- A. Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
- B. It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.
- C. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- D. The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
- E. Tables with one or more extents in this data file may be queried during the execution of this command.
正解：C、E
質問 # 84
Examine the description of the PROMOTIONS table:
You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
- A. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
- B. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
- C. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;
- D. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
- E. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
正解：A、B
質問 # 85
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. Alter user KING to be IDENTIFIED EXTERNALLY
- B. Unset REMOTE_LOGIN_PASSWORDFILE
- C. Grant DBA to KING
- D. Have the OS administrator add KING to the OSDBA group
- E. Set OS_AUTHEN_PREFIX to OPS$
正解：B
質問 # 86
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- B. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
- C. SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
- D. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- E. SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
正解：A、D
質問 # 87
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
- A. receiving inbound requests from processes using shared server connections
- B. checking for outbound shared server responses on the common outbound response queue
- C. sending each connection input request to the appropriate shared server input queue
- D. sending shared server session responses back to requesters on the appropriate connection
- E. writing inbound request to the common request queue from all shared server connections
- F. broadcasting shared server session responses back to requesters on all connections
正解：A、C、E
質問 # 88
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. It continues to run in the background
- B. You can reattach to it and monitor it
- C. It is paused and can be resumed
- D. You can no longer monitor it
- E. It terminates
正解：B、C
解説：
Reference:
https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
質問 # 89
Which two statements are true about the DUAL table? (Choose two.)
- A. It can display multiple rows and columns
- B. It can display multiple rows but only a single column
- C. It can be accessed only by the SYS user
- D. It consists of a single row and single column of VARCHAR2 data type
- E. It can be used to display only constants or pseudo columns
- F. It can be accessed by any user who has the SELECT privilege in any schema
正解：C、D
解説：
Explanation/Reference: https://en.wikipedia.org/wiki/DUAL_table
質問 # 90
Examine the description of the members table:
Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?
- A. WHERE city IN (*%AN%')
- B. WHERE city = =%AN%'
- C. ORDER BY 1, LNAME DESC
- D. WHERE city LIKE *%AN%*
- E. ORDER BY 1, 2
- F. ORDER BY last_narae DESC, city ASC
正解：C、D
質問 # 91
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 TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
- B. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
- C. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
- D. SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
- E. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
正解：C、D
質問 # 92
......
Oracle 1Z0-082認定試験は、Oracleデータベースの管理における実践的な経験を持つことが求められる厳しい試験です。試験は80問の多肢選択問題で構成され、120分以内に解答する必要があります。この試験に合格すると、候補者はOracle Certified Professionalsとして認められ、就職市場で競争力を持つことができます。Oracle 1Z0-082認定は、Oracleデータベース管理の堅固な基盤を提供し、高度なデータベース認定を追求したい個人にとっては優れたステップアップの機会です。
時間限定！今すぐ無料アクセス1Z0-082練習試験用問題：https://drive.google.com/open?id=11JRx9tdO336I95MjMDdfxEOcsmK7Aphy
オンライン試験練習テストと詳細な解説付き！：https://jp.fast2test.com/1Z0-082-premium-file.html