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

出題：1

Which two statements are true about Enterprise Manager (EM) Express?

A. You can use a single instance of EM Express to manage multiple database running on the same server.

B. You cannot start up a database instance using EM Express.

C. By default, EM express is available for a database after database creation using DBCA.

D. You can shut down a database instance using EM Express.

E. EM Express uses a separate repository database to store target database metadata.

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

出題：2

Which three statements are true regarding indexes? (Choose three.)

A. An update to a table can result in updates to any or all of the table's indexes

B. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

C. A UNIQUE index can be altered to be non-unique

D. A table belonging to one user can have an index that belongs to a different user

E. A SELECT statement can access one or more indices without accessing any tables

F. An update to a table can result in no updates to any of the table's indexes

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

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

出題：3

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 second ROLLBACK command replays the delete

C. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

D. The second ROLLBACK command does nothing

E. The second ROLLBACK command undoes the insert

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

出題：4

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.

B. The number, but not names, of columns must be identical for all SELECT statements in the query.

C. The names and number of columns must be identical for all SELECT statements in the query.

D. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.

E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

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

出題：5

You must create a tablespace of non-standard block size in a new file system and plan to use this command:

The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?

A. db_32r_cache_si2e must be less than db_ca=he_size.

B. d3_32k_cache_size should be set to a value greater than db_cache_size.

C. The /u02 file system must have at least lOOg space for the datafile.

D. db_32k_cache_size must be set to a value that can be accommodated in the SGA.

E. The operating system must use a 32k block size.

F. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

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

出題：6

Which two statements are true about undo and undo tablespaces?

A. undo segments are owned by SYSTEM.

B. An instance will crash if the active undo tablespace is lost.

C. An undo tablespace may be owned by only one instance.

D. There can be only one undo tablespace created in a database.

E. undo segments are owned by SYSBACKUP.

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

出題：7

Which two statements are true about the SET VERIFY ON command? (Choose two.)

A. It displays values for variables prefixed with &&

B. It displays values for variables used only in the WHERE clause of a query

C. It can be used only in SQL*Plus

D. It can be used in SQL Developer and SQL*Plus

E. It displays values for variables created by the DEFINE command

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

出題：8

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

A. Two RAC databases can share their instances.

B. A RAC database can have instances on separate servers.

C. A RAC database must have two or more instances.

D. A RAC database must have three or more Instances.

E. A RAC database can have one Instance.

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

出題：9

The stores table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which where clause can be used?

A. WHERE TO_XUMBER(start_date - SYSDATE) <= 25

B. WHERE MON'THS_BETWEEN (SYSDATE, start_date) <= 25

C. WHERE MON'THS_BETWEEN (start_date, SYSDATE) <= 25

D. WHERE ADD_MONTHS<start_date, 25) <= SYSDATE

正解：C 解答を投票する

出題：10

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query

B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns

C. The WHERE clause can be used to exclude rows before dividing them into groups

D. The WHERE clause can be used to exclude rows after dividing them into groups

E. The HAVING clause can be used with aggregating functions in subqueries

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

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