Database of written examination interview questions (Oracle, MySQL, etc.)

Database of written examination interview questions (Oracle, MySQL, etc.)

Copyright notice: copyright reserved, welcome to share this article, reprint please keep the source, otherwise pursue legal liability, thank you for your cooperation.

Note: this article will be updated continuously, you can follow the author's official account of Wechat to get the latest written interview materials.

Interview questions database of written examination: http://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w

⊙ [DB written interview] what is the role of the database parameter RESOURCE_LIMIT in Oracle?

⊙ [DB written interview] what are the functions of kfed, kfod and amdu tools in Oracle?

⊙ [DB written interview] what are the commonly used character functions in Oracle in Oracle?

⊙ [DB written interview] in Oracle, what is Metalink or MOS?

⊙ [DB written interview] how to quickly uninstall RAC in Oracle, Linux and Windows?

⊙ [DB written interview] in Oracle, if the permission under $GRID_HOME has been artificially modified, how to fix the permission problem?

⊙ [DB written interview] in Oracle, how to completely clear the configuration information of OCR?

⊙ [DB written interview] what is the purpose of the $GRID_HOME/root.sh script during cluster installation in Oracle?

⊙ [DB written interview] what is high availability in Oracle?

⊙ [DB written interview] in Oracle, how do I clear a SQL statement in Shared Pool?

⊙ [DB written interview 190] in Oracle, which view can query whether the database user's password is the original default password?

⊙ [DB written interview] what is delayed password verification in Oracle? How to block it?

⊙ [DB written interview 188] which parameter controls the case sensitivity of passwords in Oracle?

⊙ [DB written interview] what is the role of UNDER ANY TABLE or UNDER ANY VIEW in Oracle?

⊙ [DB written interview] what is the role of the PROFILE option when creating users in Oracle?

⊙ [DB written interview] in Oracle, how to enable ordinary users to TRUNCATE other users' tables?

⊙ [DB written interview] in Oracle, how to monitor TEMP and UNDO tablespaces and record SQL statements that consume a lot of TEMP and UNDO space?

⊙ [DB written interview] how to check the compilation errors of stored procedures in Oracle?

⊙ [DB written interview 182] how many segments have been created by the following SQL statement in Oracle?

⊙ [DB written interview] what is the purpose of redoing log files (Redo Log Files) in Oracle?

⊙ [DB written interview] what is the role of UNDO in Oracle?

⊙ [DB written interview] what are the characteristics of locally managed tablespaces (LMT) and dictionary managed tablespaces (DMT) in Oracle?

⊙ [DB written interview 178] in Oracle, how to query the CPU and memory of the database server host through the SQL statement, as well as each snapshot period?

⊙ [DB written interview] how to query unresponsive sessions for more than 10 hours in Oracle?

⊙ [DB written interview] in Oracle, how to implement the Load Profile part of the AWR report with SQL?

⊙ [DB written interview] in Oracle, how do I know which foreign keys are not indexed?

⊙ [DB written interview] in Oracle, how do I know which business users' tables or indexes are created on the SYSTEM tablespace?

⊙ [DB written interview] in Oracle, if a user fails to log in to LHRSYS, from which view can I get the number of login failures?

⊙ [DB written interview] in Oracle, how to query which users have the DBA role?

⊙ [DB written interview] in Oracle, how to query the daily log switching times by hour?

⊙ [DB written interview 170] how to query the generation of archive logs in Oracle?

⊙ [DB written interview] in Oracle, how to query all the backup information of RMAN?

⊙ [DB written interview] in Oracle, how to query the usage of ASM disks and ASM disk groups?

⊙ [DB written interview] how to query the usage of database flashback space in Oracle?

⊙ [DB written interview] in Oracle, how to query the growth of the database?

⊙ [DB written interview] how to track expdp and SQL*Plus commands in Oracle?

⊙ [DB written interview] in Oracle, how to stop the expdp process completely?

⊙ [DB written interview] in Oracle, can RMAN perform restore or copy commands across versions or platforms?

⊙ [DB written interview] in Oracle, how to recover if the UNDO tablespace data file is missing?

⊙ [DB written interview] what is the role of the NETWORK_LINK option in the data pump in Oracle?

⊙ [DB written interview 160] what is the role of the TWO_TASK environment variable in Oracle?

⊙ [DB written interview] what is the function of the sqlnet.ora file in Oracle?

⊙ [DB written interview] what is the function of the tnsnames.ora file in Oracle?

⊙ [DB written interview] in Oracle, what is the difference between SCHEMA and USER?

⊙ [DB written interview] in Oracle, how to query the database system or the amount of REDO and UNDO generated for the current session?

⊙ [DB written interview] in Oracle, what are the ways to create ASM disks?

⊙ [DB written interview] what is ASMLIB in Oracle? What are the common commands? Where is its running log path?

⊙ [DB written interview] in Oracle, RAC waits for events gc buffer busy acquire and gc buffer busy

⊙ [DB written interview] in Oracle, how to kill the session of another instance under the current instance under RAC?

⊙ [DB written interview] in Oracle, talk about your understanding of the Cache Fusion used by RAC in Oracle.

⊙ [DB written interview] what is the role of tkprof in Oracle?

⊙ [DB written interview] what is the role of the ignore parameter of the imp tool in Oracle?

⊙ [DB written interview] in Oracle, how to find out how many users are currently logged into the database?

⊙ [DB written interview] in Oracle, >