on Saturday
(2004/10/16)
Go to Hangzhou interview
Alibaba
of
Oracle DBA
position
,
The following is an interview question
: ------------------------------------------------- -------------------------------------------------- ------- Note: The following topics can be selected according to their own situation, don't have to answer, you can directly find the relevant problems directly to see the interview staff, not the answer 1: SQL Tuning class 1: list several tables Connection method 2: Do not use third-party tools, how to view SQL execution plan 3: How to use CBO, CBO and Rule 4: How to locate important (more resources) SQL5: How to track SQL6: SQL adjustment What is the most concerned about 7: Tell you about your understanding of the index (index structure, influence on DML, affect the query performance) 8: Can I use an index query to improve the performance of the query? Why 9: What is the binding variable? What is the advantages and disadvantages of binding variables? 10: How to stabilize (fixed) Executive plan 11: and sort correlation between 8i and 9i how to adjust, what is the function of temporary table space 12: There are tables t (a, b, c, d), to be based on field C After sorting, take the 21-30 records, please give SQL 2: Database Basic Concept Class 1: Pctused and PCTFREE indicates what meanings 2: Simply describe Table / Segment / Extent / Block relationship 3: Description The relationship between tablespace and datafile 4: Local management table space and dictionary management table space characteristics, what is the characteristics of ASSM 5: What is the role of the rollback segment 6: What is the role of the log 7: SGA mainly there are some parts, mainly What is the role? What is the main function of the Oracle system, what is the three: Backup recovery class 1: Backup How to Category 2: Archive What Meaning 3: If a table is in 2004-08-04 10:30:00 Drop, In the case of perfect archiving and backup, how to restore 4: RMAN, what features 5: Standby Features 6: For a system that requires a short time required to recover time (database 50g, archive 5G daily), how do you design? Backup Policy 4: System Management Class 1: For a system with system performance, how to diagnose IO, CPU, performance status 3: How do you know Statspack 4: If the system is now Need to create an index on a big table, you will consider those factors, how to do to minimize the impact on the application 5: What do you know to RAID10 and RAID5: Comprehensive place 1: You are best at Oracle Which part? 2: Like Oracle? Do you like forum? Or which part of Oracle is prefering? 3: Fame, you think that Oracle is most interesting or the most difficult part 4: Why choose to do DBA?
