[2026] Oracle Database Administration I - 1Z1-082 무료 시험 문제

문제1

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

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

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

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

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

E. Tablespace free space can be viewed in DBA_TABLESPACES

정답: A,B

문제2

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A. SELECT * FROM customers WHERE city = `%D_';

B. SELECT * FROM customers WHERE city LIKE `D_%';

C. SELECT * FROM customers WHERE city = `D_%';

D. SELECT * FROM customers WHERE city LIKE `D_';

정답: B

문제3

Which three statements are true about Deferred Segment Creation in Oracle databases?

A. Sessions may dynamically switch back and forth from deferred to immediate segment creation.

B. It Is the default behavior for tables and indexes.

C. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

D. It is supported for SYS-owned tables contained in locally managed tablespaces.

E. Indexes inherit the deferred or immediate segment creation attribute from their parent table

정답: A,B,E

문제4

Which three statements are true about the DESCRIBE command? (Choose three.)

A. It displays the NOT NULL constraint for any columns that have that constraint

B. It can be used from SQL Developer

C. It can be used only from SQL*Plus

D. It can be used to display the structure of an existing view

E. It displays all constraints that are defined for each column

F. It displays the PRIMARY KEY constraint for any column or columns that have that constraint

정답: A,C,D

문제5

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

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

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

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

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.

정답: C,D

문제6

The ORCL database has RESUMABLE__TIMEOUT = 7200 and
DEFERRED_SEGMENT_CREATION = FALSE
User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session 'User U1(136), Session 1, Instance 1'
was suspended due to ORA-01536: space quota exceeded for tablespace
'DATA'
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A. Set DEFERRED_SEGMENT_CREATION to TRUE

B. Set AUTOEXTEND ON for data files in DATA

C. Drop other U1 objects in DATA

D. Add a data file to DATA

E. Grant UNLIMITED TABLESPACE to U1

F. Increase U1's quota sufficiently in DATA

정답: A,B,F

문제7

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

A. CURRENT_DATE returns the current date and time as per the session time zone

B. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

C. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

D. SYSDATE can be queried only from the DUAL table

E. SYSDATE can be used in expressions only if the default date format is DD-MON-RR

F. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

정답: A,D

문제8

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?

A. Statement 1 returns only one row of output.

B. Statement 2 returns only one row of output.

C. Both the statements give the same output.

D. Statement 2 may return multiple rows of output.

E. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

정답: D,E

문제9

In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR.
h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?

A. to_numberipromo_begin_date) - s will return a number.

B. PROMO_ BEGIN_DATE - sysdate will return a number.

C. PROMO_ BEGIN_DATE - 5 will return a date.

D. PROMO_ BEGIN_DATE - sysdate will return an error.

E. TO_date(PROMO_ BEGIN_DATE * 5| will return a date.

정답: C,D

문제10

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

C. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

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,B,D

문제11

Which two functions are performed by a listener?

A. verifying the service name in an incoming user request

B. connecting a user process to a server process

C. creating a user session in the System Global Area (SGA)

D. verifying a user's authentication credentials

E. returning the results of processing from the server process to the user process

F. maintaining the connection to a client's user process until the user request is completed

정답: B,E

문제12

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. Password authentication must be used for system-privileged administrative users.

C. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes 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,B

문제13

You currently have an active transaction in your session and have been granted select access to vstransaction.

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

A. after successfully executing a DML statement following a failed DML statement

B. after successfully executing a commit or rollback followed by a select statement

C. after successfully executing a create table as select statement followed by a select for update statement

D. after successfully executing a create table statement followed by a create index statement

E. after successfully executing a truncate statement followed by a DML statement

F. after successfully executing a commit or rollback followed by a DML statement

정답: C,E,F

Oracle Database Administration I - 1Z1-082무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트