Some basic Oracle DBA pen questions and interview questions

Usage

1: Can indexed queries improve query performance? Instance Enumeration

2: What are the first, second, and third paradigms of database design and BCNF?

3: What is the difference between StoreProcedure and Function?

4: how to track the SQL of a session?

5: How to Use CBO? What is the difference between CBO and RULE?

6: describes the relationship between tablespace and datafile.

7: What is the difference between truncate and delete? Which operation has faster performance?

8: What is Snapshot? What is the difference between View and View?

9: pctused and pctfree

10: Where is cursor generally used? What are the vulnerabilities?

Management

1: What are the most important aspects of SQL adjustment?

2: What are the Oracle system processes? What is the role?

3: What are the features of the local tablespace management and dictionary tablespace management?

4: How are backups classified?

5: If a table is dropped, how can it be restored with comprehensive archiving and backup?

6: What is rman and what are its characteristics?

7: Features of standby

8: How do you design a backup policy for a system with a short recovery time (Database 50 GB, archiving 5 GB every day )?

9: For a system with system performance, describe your diagnosis and processing ideas.

10: lists several methods for diagnosing IO, CPU, and performance conditions.

11: What do you know about statspack?

12: 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.

13: What do you know about raid 10 and RAID 5?

14: What are the main functions of SGA?

15: Briefly describe the relationship between tables, segment, extent, and blocks.

16: your understanding of indexes (index structure, dml impact, query impact, and why query performance is improved)