Oracle database 10g:Administration I 認定 1Z0-042 試験問題:

1. Which two operations can be flashed back using the Flashback technology? (Choose two.)

A) ALTER TABLE SALES_REP DROP PARTITION P1;
B) DROP TABLE EMPLOYEES;
C) ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
D) DROP TABLESPACE USERS;
E) DROP USER SMITH;

2. A user complains that he gets the following error message repeatedly after executing some
SQL statements. The error message forces the user to log off from and log on to the database to continue his work.
ORA-02392: exceeded session limit on CPU usage, you are being logged off
Which action would you take to increase the session limit on CPU usage?

A) Modify the roles assigned to the users.
B) Modify the system privileges assigned to the users.
C) Modify the profile assigned to the user.
D) Modify the object privileges assigned to the user.
E) Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

3. You executed the following command to start the database:
SQL> STARTUP ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size
789000 bytes
Variable Size
229635576 bytes
Database Buffers
50331648 bytes
Redo Buffers
262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
Which view would you query at this stage to investigate this missing control file?

A) V$INSTANCE
B) V$CONTROLFILE
C) V$DATABASE_PROPERTIES
D) DBA_CONTROL_FILES
E) V$CONTROLFILE_RECORD_SECTION

4. Which two statements are true regarding the database in ARCHIVELOG mode? (Choose two.)

A) You can perform complete database backups without closing the database.
B) You have to shut down the database to perform the backups.
C) Archiving information is written to the data files and redo log files.
D) Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
E) All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

5. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?

A) The user must be granted the database administrator (DBA) privilege.
B) Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba role to the user.
C) The user must be listed in the password file for the authentication.
D) No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

質問と回答：