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?
?1?????the directory location for the base of OFA
?2?????the directory location where the Oracle software is installed
?3?????the directory location where the script files of the database are stored
?4?????the 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?
?1?????DDMMYY 2?????DD-MM-YY
3?????DD-MON-YY 4?????DD-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?
?1?????oratab 2?????crontab
?3?????catexp.sql 4?????orainstRoot.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?
?1?????java pool 2?????log buffer
3?????large pool 4?????buffer 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?
?1?????CKPT and control file 2?????LGWR and online redo log files
?3?????DBWn and archived redo log files 4?????DBWn 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?
?1?java pool 2?large pool 3?library cache
?4?redo log buffer 5?data dictionary cache
?6?database 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?
?1?java pool 2?large pool
?3?library cache 4?redo log buffer 5?data dictionary cache
?6?database buffer cache
8. Which two interfaces can be used as command-line interfaces for accessing an Oracle database?
?1?SQL*Plus 2?Oracle Forms
?3?Oracle Reports 4?Oracle Enterprise Manager
9. Evaluate this statement:
ALTER SYSTEM SET UNDO_TABLESPACE='UNDOTEMP' SCOPE=SPFILE;
What will be the result of executing this statement?
?1?The change will only be made in the instance currently running.
?2?The change will be persistent across instance shutdown and startup.
?3?The change will be made in both the currently running instance and the SPFILE.
?4?The 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?
?1?CORE_DUMP_DEST 2?USER_DUMP_DEST
?3?LOG_ARCHIVE_DEST 4?BACKGROUND_DUMP_DEST
------解决方案--------------------
楼主,不会吧,这样的面试题能给你一个月15000的工资啊,