This may be the article you have been looking forward to, while paying attention to this technical problem, please be sure to read questions and answers about individuals in the interview. The answer here is not very comprehensive, these issues can be explained by multiple angles. Maybe you don't have to give a completely detailed answer during the interview process, just need to make the interview examinations to understand your familiarity of Oracle concept. . 1. Explain the different points of the cold backup and thermal spare and their own advantage: The hot backup for the archive mode, the database is still in the working state. The cold backup refers to the backup after the database is closed, and it is suitable for databases of all modes. The advantage of the thermal spare is that the database can still be used when backup and can restore the database to any point in time. The advantage of the cold backup is that its backup and recovery operation is quite simple, and the database performance is slightly better than the archive mode due to the database of the cold backup. (Because you don't have to write Archive log to your hard drive) 2. You must use the backup to restore the database, but you don't control the file, how to solve the problem? Solution: Reconstruction Control File, recover the database with the Recover command with the Backup Control File clause. 3. How to convert init.ora to SPFILE? Solution: Using the Create SPFile from Pfile command. 4. Explain the Data Block, Extent and Segment Differences (Recommended English Terminology) Answer: Data Block is the smallest logical storage unit in the database. When the database's object requires more physical storage space, continuous Data Block constitutes an extent. A database object has all extents called the object's segment. 5. Method of answering the table structure: 1.Describe command 2.DBMS_Metadata.get_ddl package 6. How to view the error of the database engine: Alert log.
Original author: black_snail
