An Oracle dba pen test, interested friends can try, there are unexpected surprises oh!__oracle

Oracle dba Pen Test
One: SQL tuning class

1: Enumerate several table connection ways
2: How to view SQL execution plan without the help of Third-party tools
3: How to use the difference between CBO,CBO and rule
4: How to locate the SQL that is important (consumes a lot of resources)
5: How to track the SQL of a session
What is the most concerned about 6:sql adjustment
7: Talk about your knowledge of indexes (structure of indexes, impact on DML, impact on queries, why query performance is improved)
8: Using the index query can improve the performance of the query. Why
9: What the binding variable is. What are the advantages and disadvantages of binding variables.
10: How to stabilize (fixed) the execution plan
11: How to adjust the memory related to the sort in 8i and 9i respectively, what is the function of the temporary tablespace?
12: Table T (a,b,c,d), to be sorted according to the field C after the 第21-30条 record display, please give the SQL

Two: Database basic concept Class

What does 1Octused and pctfree mean?
2: A brief description of the relationship between Table/segment/extent/block
3: Describe the relationship between Tablespace and datafile
4: The local management of the table space and the characteristics of the Dictionary management table space, what is the characteristics of ASSM
5: What is the function of the rollback segment
6: What is the function of the log
7:sga mainly have those parts, what is the main role
What are the main functions of 8Oracle system process?

Three: Backup Recovery class

1: How to Categorize backups
2: What does archiving mean
3: If a table is 10:30:00 in 2004-08-04, how to restore it in the case of a perfect archive and backup
What are the 4:rman and what are the characteristics
Characteristics of 5:standby
6: How do you design a backup strategy for a system that requires a shorter recovery time (database 50G, daily archive 5G)

IV: System Management Class

1: For a system that exists system performance, say your diagnostic approach.
2: Several methods of diagnosing IO, CPU and performance status are listed
3: What do you know about Statspack?
4: If the system now needs to create an index on a large table, you will consider those factors and how to minimize the impact on the application
5: What do you know about RAID10 and RAID5?

Five: Comprehensive Casual class

1: What part of Oracle are you good at?
2: Like Oracle? Like on the forum? Or what part of Oracle you prefer.
3: Feel free to say what you think is the most interesting part of Oracle or the hardest part
4: Why choose to be a DBA?

(The answer can be attached to the message, to CSDN account)