当前位置:我的异常网» Oracle管理»一个好资企业的的oracle DBA面试试题 大家来看看啊
一个好资企业的的oracle DBA面试试题 大家来看看啊 把答案写下来 最好带注释 测试一下 了 最后30分散分 快来啊
网友分享于:-12-21浏览:44次
一个美资企业的的oracle DBA面试试题 大家来看看啊 把答案写下来 最好带注释 测试一下 了 最后30分散分 快来啊
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
------解决方案--------------------
楼主,不会吧,这样的面试题能给你一个月15000的工资啊,
文章评论
oracle dba笔试 一个好资企业的的oracle DBA面试试题 大家来看看啊 把答案写下来 最好带注释 测试一下 了 最后30分散分 快来啊...