คำถามที่ใช้ในการสัมภาษณ์งานในตำแหน่ง Oracle Database Admin ที่หากใครต้องการสมัครงานในตำแหน่งนี้ ควรจะต้องตอบคำถามได้ เพื่อทดสอบความเข้าใจในตำแหน่งงานรวมถึงความสามารถในการวิเคราะห์และแก้ไขปัญหานั่นเอง
Basic Question
Q: What is the difference between DBMS and RDBMS ?
Q: What is the difference between PL SQL and SQL ?
Q: What is the difference between DML and DDL ?
Q: What is the difference between full backup and incremental ?
Q: What is the difference between hot backup and cold backup ?
Q: What is the difference between Cluster and Grid ?
Q: What is the difference between Oracle Database and Oracle Instance ?
Q: What is the difference between $ORACLE_BASE and $ORACLE_HOME ?
Q: What is the difference between SGA and PGA ?
Q: What is the difference between PFILE and SPFILE ?
Q: What is the difference between UNDO and REDO ?
Q: What is the difference between Data Pump and RMAN ?
Q: What is the difference between Image Copy and Backupset ?
Q: What is the difference between Auto Increment and Sequence ?
Q: What is the difference between Sequence and Identity ?
Q: What is SQL join explain with examples ?
Q: What is aggregate functions explain with examples ?
Q: What is deadlock explain with examples ?
Q: What is instance recovery explain with examples ?Optional Question
Q: What are the components of physical database structure ?
Q: What are the components of logical database structure ?
Q: How to create & delete Oracle Database explain using tool ?
Q: How to backup & restore Oracle Database explain using tool ?
Q: How to migrate Oracle Database explain using tool ?อ่านเพิ่มเติม : https://bit.ly/2MIwzkw, https://bit.ly/30Qrwol
Leave a Reply