申し込みから学習開始まで待ちたくない方に、JPNTestの1Z1-082問題集は即時ダウンロードに対応しています。お支払い完了後すぐにOracle Database Administration Iの165の練習問題を入手でき、思い立ったその日から学習を始められます。

Oracle 1Z1-082 試験概要:

Oracle 1Z1-082 試験シラバストピック:

1Z1-082試験についてよくあるご質問

Oracle Database Administration I 認定 1Z1-082 試験問題：

問題 #1

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

A. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
B. The Oracle Net Configuration Assistant is only used when running the Oracle installer
C. Oracle Net Manager can be used to locally configure naming methods on a database server
D. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
E. Oracle Net Manager can be used to centrally configure listeners on any database server target
F. The lsnrctl utility requires a listener.ora file to exist before it is started

問題 #2

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

A. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
B. Online table segment shrink
C. Automatic data file extension (AUTOEXTEND)
D. Oracle Managed Files (OMF)
E. Online index segment shrink

問題 #3

A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

A. The command fails because the script must refer to the full path name
B. The command succeeds and HR will be connected to the orcl and abc.sql databases
C. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
D. The command fails and reports an error because @ is used twice

問題 #4

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 SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
B. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
C. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;
D. SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
E. SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;

問題 #5

Which three statements are true concerning logical and physical database structures? (Choose three.)

A. A segment might have only one extent
B. A smallfile tablespace might be bigger than a bigfile tablespace
C. A segment's blocks can be of different sizes
D. The extents of a segment must always reside in the same datafile
E. A segment can span multiple data files in some tablespaces
F. Segments can span multiple tablespaces
G. All tablespaces may have one or more data files

解説：