最新的Oracle 1Z1-082免費考試真題

問題1

Which three statements are true about views in an Oracle database? (Choose three.)

A. The WITH CHECK clause prevents certain rows from being updated or inserted

B. Data Manipulation Language (DML) can always be used on views

C. Tables in the defining query of a view must always exist in order to create the view

D. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

E. The WITH CHECK clause prevents certain rows from being displayed when querying the view

F. Views can be updated without the need to re-grant privileges on the view

G. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error

正確答案: B,C,D

問題2

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. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

B. Both the statements give the same output.

C. Statement 1 returns only one row of output.

D. Statement 2 returns only one row of output.

E. Statement 2 may return multiple rows of output.

正確答案: A,E

問題3

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

A. The extents of a segment must always reside in the same datafile

B. A segment can span multiple data files in some tablespaces

C. A segment might have only one extent

D. Segments can span multiple tablespaces

E. A smallfile tablespace might be bigger than a bigfile tablespace

F. A segment's blocks can be of different sizes

G. All tablespaces may have one or more data files

正確答案: C,D,E

問題4

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 promo_cost, promo_category FROM promotions ORDER BY by 1;

B. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

C. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

E. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

正確答案: B,D

問題5

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 terminates

B. You can no longer monitor it

C. It is paused and can be resumed

D. It continues to run in the background

E. You can reattach to it and monitor it

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題6

Which three statements are true about using SQL*Plus?

A. It can run scripts passed to it by a shell script.

B. It can run Recovery Manager (RMAN) commands.

C. It must be downloaded from the Oracle Technology Network (OTN).

D. It has its own commands that are separate from any SQL statements.

E. It has both command-line and graphical user interfaces (GUI).

F. It can run scripts entered at the SQL prompt.

正確答案: C,D,F

問題7

A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

A. in the SYSAUX tablespace

B. in the SGA

C. in the undo tablespace

D. in the temporary tablespace

E. in the PGA

正確答案: C

說明：（僅 Fast2test 成員可見）

問題8

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A. It fails because the SCOPE clause is missing

B. Change is applied to the current instance, but does not persist after instance restart

C. The value is changed only in the PFILE and takes effect at the next instance startup

D. The value is changed for the current instance and in the PFILE

正確答案: B

說明：（僅 Fast2test 成員可見）

問題9

Which three are true about the Oracle Optimizer? (Choose three.)

A. It will only generate SQL Plan Directives specific to a given SQL statement.

B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

C. It can re-optimize execution plans after previous executions detect suboptimal plans.

D. It updates stale object statistics in the Data Dictionary.

E. It determines the optimal table join order and method.

F. It can optimize only SELECT statements.

正確答案: B,E,F

問題10

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. PROMO_ BEGIN_DATE - 5 will return a date.

B. PROMO_ BEGIN_DATE - sysdate will return an error.

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

D. to_numberipromo_begin_date) - s will return a number.

E. PROMO_ BEGIN_DATE - sysdate will return a number.

正確答案: A,B

問題11

Which three statements are true about roles?

A. The SET ROLE statement can disable one or more roles for a session.

B. The SET ROLE statement can enable one or more roles for a session.

C. Object privileges may not be granted to roles.

D. Roles may be granted to roles.

E. All roles granted to a user are set on by default when the user logs in,

F. Roles must be password protected.

正確答案: A,C,D

問題12

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

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

B. They can be written by server processes

C. They can be written by background processes

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

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

正確答案: B,C

說明：（僅 Fast2test 成員可見）

問題13

In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

A. Revoke the CREATE SESSION privilege from user HR

B. Execute DDL statements in the HR schema

C. Log in to the database instance

D. Execute DML statements in the HR schema

E. Revoke the CREATE SESSION privilege from other users

F. Grant the CREATE SESSION privilege with ADMIN OPTION to other users

正確答案: B,E,F

說明：（僅 Fast2test 成員可見）

最新的Oracle Database Administration I - 1Z1-082免費考試真題

聯系我們

站內鏈接

最新更新