Vibrant Publishers
5. What is the cache hit ratio, what impact does it have on performance of an Oracle database andwhat is involved in tuning it? 6. Other than making use of the statspack utility, what would you check when you are monitoring orrunning a health check on an Oracle 8i or 9i database?
A file system and volume manager built into Oracle databases is called Oracle Automatic Storage Management (ASM). By automatically controlling the storage layout to improve I/O performance, it makes managing Oracle database files easier. ASM helps efficiently handle large databases, ensure data redund...
1_ORACLE 面试题及其答案(1_ORACLE interview questions and answers) 1_ORACLE 面试题及其答案(1_ORACLE interview questions and answers) 21. How do I determine the time zone for the database? Answer: SELECT, DBTIMEZONE, FROM, DUAL; 22. Explain the usefulness of GLOBAL_NAMES as TRUE Answer: ...
Oracle 笔试题 oracle DBA 面试题及答案 (国外公司 ) oracle 数据库笔试题 DBA 国际大公司 Oracle 面试笔试题 oracle Database DBA Interview Questions 1. How many memory layers are in the shared pool? Sqlplus shared pool and private pool. 2. How do you find out from the RMAN catalog if a part...
Oracle DBA Job Interview Questions and Answers 1 :: When using Oracle export/import what character set concerns might come up? How do you handle them? Be sure to set NLS_LANG for example to "AMERCIAN_AMERICA.WE8ISO8859P1". If your source database is US7ASCII, beware of 8-bit ...
Oracle is one of the leading relational database management systems (RDBMS) in the world. If you are preparing for an Oracle interview, it is important to familiarize yourself with common interview questions and be prepared with accurate and concise answers. In this article, we will discuss some...
30. Name two files used for network connection to a database. TNSNAMES.ORA and SQLNET.ORA fromhttp://www.orafaq.com/wiki/Interview_Questions
OUR SERVICES When looking out for a job in Oracle Database administration and you are a fresher, you can always turn to Kendba. We provide all assistance in fresher oracle DBA jobs. Right from resume making tips to where to submit the resume is guided by Kendba. ...
SQL语言包括数据定义、数据操纵(Data Manipulation),数据控制(Data Control)数据定义:Create Table,Alter Table,Drop Ta... 数据库 sql 数据 oracle 表空间 转载 mob604756e88498 2012-08-10 10:12:00 598阅读 2评论 数据库面试题(SQL+ORACLE) 数据库基础(面试常见题)一、数据库基础1. 数据抽象:物理...