ORACLE DBA

UNIX 1. How can you determine the space left in a file system? Level: Low Expected answer: There are several commands to do this: du, df, or bdf 2. How can you determine the number of SQLNET users logged in to the UNIX system? Level: Intermediate Expected answer: SQLNET users will show up with a process unique name that begins with oracle, if you do a ps -ef|grep oracle|wc -l you can get a count of the number of users. 3. What command is used to type files to the screen? Level: Low Expected answer: cat, more, pg 4. What command is used to remove a file? Level: Low Expected answer: rm 5. Can you remove an open file under UNIX? Level: Low Expected answer: yes 6. How do you create a decision tree in a shell script? Level: intermediate Expected answer: depending on shell, usually a case-esac or an if-endif or fi structure 7. What is the purpose of the grep command? Level: Low Expected answer: grep is a string search command that parses the specified string from t...

DBA Interview Questions - Set 1 Read   DBA Interview Questions Set 2 What is Log Switch?   - The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. What is On-line Redo Log?   - The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion. Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?   - All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE co...

DBA Interview Questions Part-I By   admin   |   March 13, 2006 1.        What is Log Switch?   - The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. 2.       What is On-line Redo Log?   - The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion. 3.       Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?   - All the default storage parameters defined for the tablespace can be changed using the ALTER TABLESPACE command. When ...