1Z0-082試験無料問題集（145題）「Oracle Database Administration I 認定」

出題：1

Which two statements are true about User Authentication in an Oracle Database?

A. Operating System authentication may be used for system-privileged administrative users.

B. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.

C. Password authentication must be used for system-privileged administrative users.

D. Password File authentication is supported for any type of database user.

E. Password File authentication must be used for system-privileged administrative users.

正解：A,C 解答を投票する

出題：2

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 DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

B. when a COMMIT statement is issued by the same user from another session in the same database instance

C. when a CREATE INDEX statement is executed successfully in the same session

D. when the session logs out successfully

E. when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

F. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

正解：A,C,D 解答を投票する

出題：3

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

A. Trace files are written to the Fast Recovery Area (FRA)

B. They can be written by background processes

C. They can be written by server processes

D. Trace file names are based on the database name concatenated with a sequential number

E. All trace files contain error information that require contacting Oracle Support

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which three statements are true about inner and outer joins? (Choose three.)

A. A left or right outer join returns only unmatched rows

B. Outer joins can be used when there are multiple join conditions on two tables

C. Outer joins can only be used between two tables per query

D. An inner join returns matched rows

E. A full outer join returns matched and unmatched rows

F. A full outer join must use Oracle syntax

正解：A,D,E 解答を投票する

出題：5

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

A. V$TABLESPACE displays information about tablespaces contained in the data dictionary

B. Tablespace free space can be viewed in DBA_TABLESPACES

C. V$TABLESPACE displays information that is contained in the controlfile about tablespaces

D. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

E. Tablespace free space can be viewed in V$TABLESPACE

正解：C,D 解答を投票する

出題：6

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. 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 DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

D. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

E. A TIMESTAMP data type column contains information about year, month, and day

正解：B,C,D 解答を投票する

出題：7

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
Be stored in a format supporting date arithmetic without using conversion functions Store a loan period of up to 10 years 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. TIMESTAMP WITH TIMEZONE

C. TIMESTAMP WITH LOCAL TIMEZONE

D. TIMESTAMP

E. INTERVAL DAY TO SECOND

正解：E 解答を投票する

出題：8

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. 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

C. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

D. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS

E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

正解：A,B 解答を投票する

出題：9

Examine these commands:

Which two statements are true about the sqiidr execution?

A. It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

B. It overwrites all data in emp with data from emp.dat.

C. It appends data from EMP.DAT TO EMP.

D. It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

E. It overwrites the data for Alan and adds data for Curl and Bob

正解：C,D 解答を投票する

出題：10

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

A. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table

B. External table files can be used for other external tables in a different database

C. They support UPDATEs but not INSERTs and DELETEs

D. The ORACLE_LOADER access driver can be used to unload data from a database into an external table

E. They cannot be partitioned

F. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

正解：B,D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1Z0-082試験無料問題集「Oracle Database Administration I 認定」