| |||||
|
DataBase Administrator (DBA) Interview Questions and Answers Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 (Continued from previous part...) 114. What are the uses of rollback segment?
If we find any problem after data manipulation and if we want to undo it, then we can use this ROLLBACK segment.
115. What is a deadlock and Explain?
Waiting for an event that never happens or processed.
116. State any three mouse events system variables? System.mouse_button_pressedSystem.mouse_button_shift 117. What other parts of your organization do you interact with and how? Again, if you have exhausted question 1 and 2 you may never get to this question. But if you have been apprehensive to opening up and explaining yourself, take note that you may have an issue and the interviewer might also be already getting tired of the interview process. If you get to this question consider yourself in trouble. You really need to forget all your hang-ups and start explaining what it is that you like to do as a DBA, and why you want to work for this particular company. You are going to have to reel this interviewer back into the interview process or you might not get to the true technical question part of the interview. 118. How do you display console on a window? The console includes the status line and message line, and is displayed at the bottom of the window to which it is assigned. To specify that the console should be displayed, set the console window form property to the name of any window in the form. To include the console, set console window to Null. 119. In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
Once you got inside the OUTER_LOOP, it comes out only after the NOTFOUND
statement.
120. What are the different types of joins?
Different Types of Joins- 121. How will you copy the structure of a table without copying the data?
Answer1 122. What is a VIEW? How to get script for a view?
Answer1 (Continued on next part...)
Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
||||