当前位置:  数据库>oracle

了解学习国外公司的Oracle DBA面试试题

    来源: 互联网  发布时间:2017-03-17

    本文导语: Oracle DBA Interview Questions By B G  1. How many memory layers are in the shared pool?  2. How do you find out from the RMAN catalog if a particular archive log has been backed-up?  3. How can you tell how much space is left on a given file system and how much space each of the fil...

Oracle DBA Interview Questions By B G

  1. How many memory layers are in the shared pool?

  2. How do you find out from the RMAN catalog if a particular archive log has been backed-up?

  3. How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

  4. Define the SGA and:

  ? How you would configure SGA for a mid-sized OLTP environment?

  ? What is involved in tuning the SGA?

  5. What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

  6. Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

  7. How do you tell what your machine name is and what is its IP address?

  8. How would you go about verifying the network name that the local_listener is currently using?

  9. You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

  10. What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

  11. What is the recommended interval at which to run statspack snapshots, and why?

  12. What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

  13. Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

  14. How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

  15. What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

  16. In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?




































    
 
 
 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • Linux下安装Oracle的诀窍你了解吗
  • Oracle体系结构需要首先了解的两个概念
  • Oracle两个基本概念帮你了解体系结构
  • 解析学习Oracle架构所应了解的基础知识
  • 知识进阶 完全了解 Oracle 标签安全测试
  • 将mysql转换到oracle必须了解的50件事
  • oracle复习笔记之PL/SQL程序所要了解的知识点
  • win7, win8安装docker需要了解的概念
  • 想了解LINUX一定能明白汇编语言吗?
  • 八个问题帮你快速了解Docker
  • 进程迁移问题,急切想了解!!!!!!!!
  • 程序猿,千万别说你不了解Docker!
  • 谁了解Panabit,用它来做流控效果如何
  • 想深入了解操作系统该怎么做
  • 谁对JBuilder4比较了解,有什么好书可以介绍,或有什么建议
  • 关于JIT技术,有对它了解的朋友吗?
  • 要学习JSP,一定要先了解XML吗??
  • 谁了解JAVA方面的认证,想考一个JAVA的认证!XIEXIE
  • 了解一下北京搞java的要求和待遇,来者有分。
  • 我想了解一下,用LINUX的朋友们,
  • 关于Linux的文化了解
  • 有谁了解“江苏新晨信息科技发展有限公司”吗,公司怎么样?
  • 谁了解postsql
  • 有没有在大连搞linux的,我想了解一下大连的linux情况!
  • 有谁了解postsql
  • L想了解一下Linux驱动开发的前景如何?难度大小如何?
  • 菜鸟问题:如何了解系统关于某个C语言变量类型是怎样定义的?
  • 请问:做(linux)驱动开发对于电子技术需要了解到什么程度,


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3