1Z0-042試験無料問題集（185題）「Oracle database 10g:Administration I 認定」

出題：1

In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)

A. The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

B. The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

C. The database operation temporarily halts till the member becomes available.

D. The database instance aborts.

E. Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.

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

出題：2

Which statement is true when you run the SQL Tuning Advisor with limited scope?

A. SQL structure analysis is not performed for the SQL statements.

B. The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

C. SQL Profile recommendations are not generated for the SQL statements.

D. Access path analysis is not performed for the SQL statements.

正解：C 解答を投票する

出題：3

Which three statements are true about the stages of database startup? (Choose three.)

A. Control files are required to bring the database to the NOMOUNT stage.

B. Data files and redo log files are made available to users at the OPEN stage.

C. Data files and online redo log files are checked for consistency while opening the database.

D. Data files and redo log files can be renamed at the MOUNT stage.

E. Control files are read at the OPEN stage for the location of data files.

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

出題：4

A user complains about getting this error after issuing a certain SQL statement: ORA-02393: exceeded call limit on CPU usage Because of the error, the SQL statement gets aborted. What action would you take to
increase the CPU usage limit in the subsequent sessions of the user?

A. Increase the value of the SESSION_CACHED_CURSORS initialization parameter.

B. Set the RESOURCE_LIMIT initialization parameter to FALSE.

C. Increase the value of the SESSION_MAX_OPEN_FILES initialization parameter.

D. Modify the resource limit in the profile used by the user.

正解：D 解答を投票する

出題：5

User SCOTT wants to export his objects using Oracle Data Pump and executes the following command:
$ expdp scott/tiger
directory = EXPORT_DIR
dumpfile = scott.dmp
include = table
include = view:"like '%DEPARTMENTS%'"
content = DATA_ONLY
Which task would the command accomplish?

A. Oracle Data Pump would export all of the table structures and the view definitions with data where view name contains a string named DEPARTMENTS.

B. Oracle Data Pump would export only the data of all of the tables and views.

C. Oracle Data Pump would export the table data and the view definitions with data where view name contains a string named DEPARTMENTS.

D. Oracle Data Pump would export the table data and the view definitions where the view name contains a string named DEPARTMENTS.

E. Oracle Data Pump would export all of the table structures along with data and all the views.

正解：D 解答を投票する

出題：6

You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to, in order to confirm that the alert has been raised due the event?

A. the Database Control performance page

B. the Database Control Home page

C. the Database Control Maintenance page

D. the alert.log file

E. the DBA_ALERTS view

正解：B 解答を投票する

出題：7

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario? (Choose two.)

A. The database can be restored till the point of the last closed whole database backup.

B. The instance aborts.

C. The database cannot be recovered.

D. The database can be recovered by restoring the control files from the backup.

E. The database remains opened and you have to shut it down with the ABORT option.

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

出題：8

Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)

A. configuring the database in ARCHIVELOG mode

B. renaming of control files

C. dropping the database user

D. renaming of data files

E. multiplexing of control files

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

出題：9

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view. After 30 minutes, you executed the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE
Tablespace [TEST] is [28 perce 28.125 nt] full
What could be the two reasons for the elimination of the other rows in the output? (Choose two.)

A. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

B. The threshold alert conditions are cleared.

C. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

D. The threshold alerts are transferred to DBA_ALERT_HISTORY.

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

出題：10

Users of HR schema complain about slower-than-normal performance. On investigation the DBA found that maintenance was recently performed on some of the tables. The DBA traced the query that takes longer than normal to execute.
View the Exhibit exhibit_before.
After the DBA resolves the problem, the query performs normally.
View the Exhibit exhibit_after.
What action would the DBA have taken to resolve the performance problem?

A. moved the EMPLOYEES table to another location in the same tablespace

B. moved the EMPLOYEES table in to a locally managed tablespace

C. analyzed the EMPLOYEES table to collect the current statistics

D. reorganized the associated indexes for the EMPLOYEES table that were in an unusable state

E. moved the indexes associated with the EMPLOYEES table to the same tablespace where the EMPLOYEES table exists

正解：D 解答を投票する

出題：11

You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A. One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

B. One audit record is created for every session when any user successfully drops a table owned by SCOTT.

C. One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

D. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

E. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

正解：E 解答を投票する

出題：12

Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:
LSNRCTL> STOP
What would happen to the sessions that are presently connected to the database instance?

A. The sessions are not affected and continue to function normally.

B. The active transactions are rolled back and the sessions get terminated.

C. The sessions are not allowed to perform any operations till the listener is started.

D. The sessions are able to perform only queries.

正解：A 解答を投票する

出題：13

View the Exhibit.
Which statement regarding the dept and emp tables is true?

A. When you delete a row from the dept table, automatically the corresponding rows are updated with null values in the emp table.

B. When you delete a row from the emp table, you would receive a constraint violation error.

C. When you delete a row from the emp table, automatically the corresponding rows are deleted from the dept table.

D. When you delete a row from the emp table, automatically the corresponding rows are updated with null values in the dept table.

E. When you delete a row from the dept table, you would receive a constraint violation error.

F. When you delete a row from the dept table, automatically the corresponding rows are deleted from the emp table.

正解：F 解答を投票する

1Z0-042試験無料問題集「Oracle database 10g:Administration I 認定」