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, D
30. Name two files used for network connection to a database. TNSNAMES.ORA and SQLNET.ORA fromhttp://www.orafaq.com/wiki/Interview_Questions
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 ...
33. Which environment variables are absolutely critical in order to run the OUI? 34. What SQL query from v$session can you run to show how many sessions are logged in as aparticular user account? 35. Why does Oracle not permit the use of PCTUSED with indexes? 36. What would you use t...
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 APEX interview questions – APEX-related examples: What is Page Zero in Oracle APEX? What are Collections in APEX? Could you give some usage examples? What would you call APEX Items in APEX, in PL/SQL, and in JS? How would you connect an Oracle APEX application to Active Directory...
ORACLE DBA 面试题集 一:SQL tuning 类 1 列举几种表连接方式 等连接、非等连接、自连接、外连接(左、右、全) 2 不借助第三方工具,怎样查看 sql 的执行计划 I) 使用 Explain Plan,查询 PLAN_TABLE; EXPLAIN PLAN SET STATEMENT_ID='QUERY1' FOR SELECT * FROM a WHERE aa=1; SELECT operation, options...
DBMS Tutorial | Database Management System tutorial and examples on Oracle, SQL, MongoDB, MCQ, Interview Questions with the answer, etc.
OracleDBAInterviewQuestionsByBG 1.Howmanymemorylayersareinthesharedpool? 2.HowdoyoufindoutfromtheRMANcatalogifaparticulararchiveloghasbeen backed-up? 3.Howcanyoutellhowmuchspaceisleftonagivenfilesystemandhowmuchspace eachofthefilesystem'ssubdirectoriestake-up?
DBMS Tutorial | Database Management System tutorial and examples on Oracle, SQL, MongoDB, MCQ, Interview Questions with the answer, etc.