최신 9i DBA 1Z0-035 무료샘플문제:

1. Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?

A) You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
B) Data blocks have to be written more frequently by DBWR.
C) Redo blocks have to be written more frequently by LGWR.
D) You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.

2. You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger. This causes a statement that requires space beyond a user's quota _____.

A) to fail because quota limits do not activate the resumable space allocation feature
B) to invoke the default trigger that resets user quota, if there is free space in the related tablespace
C) to wait in a suspended state until the quota is increased or until the timeout value is reached
D) to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space allocation problems.

3. What does the Character Set Scanner command line utility do?

A) performs character set conversions to the new specified character set
B) checks for any character definitions that will fail conversion to the new character set
C) reports only on any Unicode character conversions required
D) scans on any character set conversion required, then converts the data

4. Examine this statement:
SELECT *
FROM ( SELECT class_id, crs_id
FROM classes
ORDER BY start_date DESC)
WHERE ROWNUM < 11;
What will happen when this executes?

A) The ten rows with the latest start date will be returned.
B) An error is returned citing an ORDER BY clause reference to a column that is not selected.
C) The ten rows with the earliest start date will be returned.
D) An error is returned citing an ORDER BY clause embedded within a subquery.

5. Examine the statement:
DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES;
What is the result of the statement?

A) The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files (OMF) or if the database was created using OMF.
B) The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF) data files.
C) The contents and data files belonging to the IND2 tablespace are dropped.
D) The contents of the tablespace are dropped along with all its data files except those identified with the Oracle-Managed Files (OMF) naming convention.

질문과 대답: