1. You are in the process of installing Oracle Database on your client computer. You have set the value for environment variable ORACLE_HOME to /oracle/ora9i .
What does this value specify?
1the directory location for the base of OFA
2the directory location where the Oracle software is installed
3the directory location where the script files of the database are stored
4the directory location where the operating system searches for Oracle executables, such as SQL*Plus
2. While installing the Oracle database, you have set the NLS_LANG environment variable to AMERICAN_AMERICA.WE8IS08859P1.
What will be the default date format assigned to the Oracle database?
1DDMMYY 2DD-MM-YY
3DD-MON-YY 4DD-MONTH-YYYY
3. Your Oracle server is running on a Linux platform. You create a new database NEWDB on this server.
Which file is updated with the Oracle system identifiers (SIDs) when this new Oracle database, NEWDB, is created?
1oratab 2crontab
3catexp.sql 4orainstRoot.sh
4. Your database is running in the shared server mode. You want to ensure that the memory allocated to the shared pool is completely used by the application users and not by RMAN processes or any other I/O server processes.
Which component of the Shared Global Area (SGA) should be allocated memory to achieve the objective?
1java pool 2log buffer
3large pool 4buffer cache
5. Which background process and associated database component guarantees that committed data is saved even when the
changes have not been recorded in the datafiles?
1CKPT and control file 2LGWR and online redo log files
3DBWn and archived redo log files 4DBWn and database buffer cache
6. Users in your application complain of slow response to queries. Upon analysis, you realize that the queries are being reparsed because they are aged out quickly.
Which component of the Shared Global Area (SGA) should you modify to avoid the reparsing of queries?
1java pool 2large pool 3library cache
4redo log buffer 5data dictionary cache
6database buffer cache
7. Users in your application complain of slow response to queries. Upon analysis, you realize that the queries are being reparsed because they are aged out quickly.
Which component of the Shared Global Area (SGA) should you modify to avoid the reparsing of queries?
1java pool 2large pool
3library cache 4redo log buffer 5data dictionary cache
6database buffer cache
8. Which two interfaces can be used as command-line interfaces for accessing an Oracle database?
1SQL*Plus 2Oracle Forms
3Oracle Reports 4Oracle Enterprise Manager
9. Evaluate this statement:
ALTER SYSTEM SET UNDO_TABLESPACE='UNDOTEMP' SCOPE=SPFILE;
What will be the result of executing this statement?
1The change will only be made in the instance currently running.
2The change will be persistent across instance shutdown and startup.
3The change will be made in both the currently running instance and the SPFILE.
4The statement will fail because the only valid SCOPE values are MEMORY and BOTH.
10. Eric is working on his production database, PROD. Eric detects a deadlock involving transactions between two users in his database. He wants to view the details of the deadlock to prevent it from occurring the next time.
Which initialization parameter will determine the location of the file containing the details of the deadlock?
1CORE_DUMP_DEST 2USER_DUMP_DEST
3LOG_ARCHIVE_DEST 4BACKGROUND_DUMP_DEST
What does this value specify?
1the directory location for the base of OFA
2the directory location where the Oracle software is installed
3the directory location where the script files of the database are stored
4the directory location where the operating system searches for Oracle executables, such as SQL*Plus
2. While installing the Oracle database, you have set the NLS_LANG environment variable to AMERICAN_AMERICA.WE8IS08859P1.
What will be the default date format assigned to the Oracle database?
1DDMMYY 2DD-MM-YY
3DD-MON-YY 4DD-MONTH-YYYY
3. Your Oracle server is running on a Linux platform. You create a new database NEWDB on this server.
Which file is updated with the Oracle system identifiers (SIDs) when this new Oracle database, NEWDB, is created?
1oratab 2crontab
3catexp.sql 4orainstRoot.sh
4. Your database is running in the shared server mode. You want to ensure that the memory allocated to the shared pool is completely used by the application users and not by RMAN processes or any other I/O server processes.
Which component of the Shared Global Area (SGA) should be allocated memory to achieve the objective?
1java pool 2log buffer
3large pool 4buffer cache
5. Which background process and associated database component guarantees that committed data is saved even when the
changes have not been recorded in the datafiles?
1CKPT and control file 2LGWR and online redo log files
3DBWn and archived redo log files 4DBWn and database buffer cache
6. Users in your application complain of slow response to queries. Upon analysis, you realize that the queries are being reparsed because they are aged out quickly.
Which component of the Shared Global Area (SGA) should you modify to avoid the reparsing of queries?
1java pool 2large pool 3library cache
4redo log buffer 5data dictionary cache
6database buffer cache
7. Users in your application complain of slow response to queries. Upon analysis, you realize that the queries are being reparsed because they are aged out quickly.
Which component of the Shared Global Area (SGA) should you modify to avoid the reparsing of queries?
1java pool 2large pool
3library cache 4redo log buffer 5data dictionary cache
6database buffer cache
8. Which two interfaces can be used as command-line interfaces for accessing an Oracle database?
1SQL*Plus 2Oracle Forms
3Oracle Reports 4Oracle Enterprise Manager
9. Evaluate this statement:
ALTER SYSTEM SET UNDO_TABLESPACE='UNDOTEMP' SCOPE=SPFILE;
What will be the result of executing this statement?
1The change will only be made in the instance currently running.
2The change will be persistent across instance shutdown and startup.
3The change will be made in both the currently running instance and the SPFILE.
4The statement will fail because the only valid SCOPE values are MEMORY and BOTH.
10. Eric is working on his production database, PROD. Eric detects a deadlock involving transactions between two users in his database. He wants to view the details of the deadlock to prevent it from occurring the next time.
Which initialization parameter will determine the location of the file containing the details of the deadlock?
1CORE_DUMP_DEST 2USER_DUMP_DEST
3LOG_ARCHIVE_DEST 4BACKGROUND_DUMP_DEST
SQL> STARTUP NOMOUNT;
Which of the following could be the reason for the failure?
1Oracle database cannot read the datafiles.
2Oracle database cannot read the control file.
3Oracle database cannot read the redo log files.
4Oracle database cannot read the initialization parameter file.
12. Which view will you query to display the PFILE information currently in effect for a database that was started by using the initialization parameter file?
1V$DATABASE 2V$PARAMETER
3V$SPPARAMETER 4V$CONTROLFILE
13. You have two listeners named LISTENER and listener2 configured for your database and listening on different port numbers. You executed
this command at the command-line:
lsnrctl stop
What is the result of executing this command?
1An error will be generated.
2Both the listeners will be stopped.
3The default listener will be stopped.
4The listener that was started first will be stopped.
14. After changing some parameters in your initialization parameter file, you start the database in the NOMOUNT state using the following command:
SQL> STARTUP NOMOUNT;
After this, you want to enable redo archiving and therefore, you issue the following statement to mount the database:
SQL> ALTER DATABASE MOUNT;
At this stage, the database fails to mount.
Which condition could be the reason for the failure?
1A datafile in the database cannot be accessed.
2The control file in the database cannot be accessed.
3The redo log files in the database cannot be accessed.
4The parameter file in the database cannot be accessed.
15. While starting your database, you receive an error stating that the database cannot identify one of the redo log files in it.
At which stage will you receive this error?
1when the database changes from the MOUNT to the OPEN state
2when the database changes from the NOMOUNT to the MOUNT state
3when the database changes from the SHUTDOWN to the MOUNT state
4when the first transaction ends and the changes to the database must be written to the redo log files
16. Your Oracle server has a set of four databases. You want to monitor the startup and shutdown times of the ORCL Oracle database.
Assuming you have not modified the default file name, which file will you view to obtain information regarding the startup and shutdown of the ORCL database?
1ORA00122.TRC 2ALERT_ORCL.LOG 3ORCL_ALERT.TRC 4TRACE_ALERT.LOG
17. Your production database has crashed due to media failure. After analysis, you discover that the instance crashed because some database files were located on failed media.
Which file contains detailed information about the background processes, the files that caused the instance to crash, and the time of the crash?
1datafile 2control file
3alert log file 4redo log file
18. You are required to rename the EXAMPLE.DBF datafile of your Oracle database. First, you relocate the file using OS utilities. After relocating
the file by using OS utilities, which statement will accomplish the task of updating the control file with the new name of the datafile?
1ALTER DATAFILE...RENAME FILE
2ALTER DATABASE...RENAME DATAFILE
3ALTER DATABASE...RENAME DATA FILE
4ALTER TABLESPACE...RENAME DATAFILE
19. As a database administrator, you are creating a user. You run the following statement to create the user:
SQL> CREATE USER ADAM IDENTIFIED BY PASSWORD
DEFAULT TABLESPACE SYSTEM
QUOTA 1M ON TS1
QUOTA 10M ON USERS
PROFILE USER_PROF;
What will be the result of running this statement?
1The user will not be able to change his password.
2The user will be assigned the database's default temporary tablespace, if one exists.
3The statement will fail because the temporary tablespace for the user has not been specified.
4The statement will fail because you cannot assign the SYSTEM tablespace as the user's default tablespace.
20. The database of your company is running in the NOARCHIVELOG mode. Due to a hard disk failure, a datafile of your SYSTEM
tablespace is corrupted and your database instance has crashed.
Up to which point in the past can you recover the SYSTEM tablespace?
1up to the last commit
2up to the last log switch
3up to the last complete cold backup
4up to the point of the database crash
5The SYSTEM tablespace cannot be recovered.
Thomas Kyte写的,最好是原版的,前面五章吧,基本就有你这里所有问题的答案。