Basic and Advance databases programming :: Database Administrator  (DBA) Job Interview Questions and Answers

If you a Database Administrator and need to update DBA technical knowledge or need to prepare for a job interview? Then you are at eht right place explore this collection of DATABASE Administrator (DBA) Interview Questions and Answers here. This DBA Interview Questions and Answers are basic and advance level so every one who is DBA can get more help with these database interview questions and answers tutorial and guide.

1 What is a DBA?
2 What DBA activities did you to do today?
3 What are the different modes of mounting a Database with the Parallel Server?
4 What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode?
5 Do you consider yourself a development DBA or a production DBA and why?
6 What are the Large object types sported by Oracle?
7 Diffrence between a where clause and a having claus
8 Shall we create procedures to fetch more than one record?
9 Do View contain Data?
10 What are the Referential actions supported by FOREIGN KEY integrity constraint?
11 What are the type of Synonyms?
12 Where would you look for errors from the database engine?
13 Compare and contrast TRUNCATE and DELETE for a table.
14 Give the reasoning behind using an index.
15 Give the two types of tables involved in producing a star schema and the type of data they hold.
16 What type of index should you use on a fact table?
17 What is a Segment?
18 A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
19 Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
20 What is a Sequence?
21 Give the stages of instance startup to a usable state where normal users may access it.
22 What is a Synonym?
23 How would you go about generating an EXPLAIN plan?
24 How would you go about increasing the buffer cache hit ratio?
25 Explain an ORA-01555
26 Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
27 How would you determine the time zone under which a database was operating?
28 Explain the use of setting GLOBAL_NAMES equal to TRUE.
29 What command would you use to encrypt a PL/SQL application?
30 Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
31 Explain the use of table functions.
32 Name three advisory statistics you can collect.
33 Where in the Oracle directory tree structure are audit traces placed?
34 Explain materialized views and how they are used.
35 What does a Control file Contain?
36 What is difference between UNIQUE constraint and PRIMARY KEY constraint?
37 What is the effect of setting the value ALL_ROWS for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
38 Describe what redo logs are.
39 How would you force a log switch?
40 What are the different Parameter types?
41 What does coalescing a tablespace do?
42 What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
43 Name a tablespace automatically created when you create a database.
44 When creating a user, what permissions must you grant to allow them to connect to the database?
45 How do you add a data file to a tablespace?
46 How do you resize a data file?
47 What view would you use to look at the size of a data file?
48 What view would you use to determine free space in a tablespace?
49 How would you determine who has added a row to a table?
50 How can you rebuild an index?
51 Explain what partitioning is and what its benefit is.
52 You have just compiled a PL/SQL package but got errors, how would you view the errors?
53 How can you gather statistics on a table?
54 How can you enable a trace for a session?
55 What is the difference between the SQL*Loader and IMPORT utilities?
56 What is a database schema?
57 What are the options available to refresh snapshots?
58 What is a SNAPSHOT LOG?
59 What is Distributed database?
60 What are the basic element of Base configuration of an oracle Database?
61 What is database clusters?
62 What is an Index? How it is implemented in Oracle Database?
63 What is a Database instance?
64 What is the use of ANALYZE command?
65 What is default tablespace?
66 What are the system resources that can be controlled through Profile?
67 What is Tablespace Quota?
68 What are the different Levels of Auditing?
69 What is Statement Auditing?
70 What are the database administrators utilities available?
71 How can you enable automatic archiving?
72 What are database roles?
73 How can we implement database roles?
74 What are the use of database Roles?
75 What is database Auditing?
76 What is Audit Trial?
77 What are the responsibilities of a Database Administrator?
78 What is a trace file and how is it created?
79 What is a database profile?
80 How will you enforce security using stored procedures?
81 What are the dictionary tables used to monitor a database spaces?
82 What are the roles and user accounts created automatically with the database?
83 What are the minimum parameters should exist in the parameter file (init.ora)?
84 How can we specify the Archived log file name format and destination?
85 What is user Account in Oracle database?
86 What dynamic data replication?
87 What is Two-Phase Commit?
88 How can you Enforce Referential Integrity in snapshots?
89 What is a SQL * NET?
90 What is a SNAPSHOT?
91 What is the mechanism provided by ORACLE for table replication?
92 What is database snapshots?
93 What are the various type of snapshots?
94 Describe two phases of Two-phase commit?
95 What is snapshot log?
96 What are the benefits of distributed options in databases?
97 What are clusters?
98 What is a cluster key?
99 How can we reduce the network traffic?
100 Differentiate simple and complex, snapshots?
101 What are the Built-ins used for sending Parameters to forms?
102 Can you have more than one content canvas view attached with a window?
103 Is the After report trigger fired if the report execution fails?
104 Does a Before form trigger fire when the parameter form is suppressed?
105 Is it possible to split the print reviewer into more than one region?
106 Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?
107 How do you list the files in an UNIX directory while also showing hidden files?
108 How do you execute a UNIX command in the background?
109 Can a formula column referred to columns in higher group?
110 Can a formula column be obtained through a select statement?
111 If a parameter is used in a query without being previously defined, what diff. exist between report 2.0 and 2.5 when the query is applied?
112 What are the SQL clauses supported in the link property sheet?
113 What is trigger associated with the timer?
114 What are the trigger associated with image items?
115 What are the different windows events activated at runtimes?
116 When do you use data parameter type?
117 What is difference between open_form and call_form?
118 How would you change all occurrences of a value using VI?
119 Give two UNIX kernel parameters that effect an Oracle install
120 Briefly, how do you install Oracle software on UNIX.
121 What is the diff. when confine mode is on and when it is off?
122 What are visual attributes?
123 Which of the two views should objects according to possession?
124 What are the two types of views available in the object navigator (specific to report 2.5)?
125 What are the vbx controls?
126 What is the use of transactional triggers?
127 How do you create a new session while open a new form?
128 What are the ways to monitor the performance of the report?
129 If two groups are not linked in the data model editor, What is the hierarchy between them?
130 An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
131 Explain about horizontal, Vertical tool bar canvas views?
132 What is the purpose of the product order option in the column property sheet?
133 What is the use of image_zoom built-in?
134 How do you reference a parameter indirectly?
135 Is it possible to insert comments into sql statements return in the data model editor?
136 Is it possible to disable the parameter from while running the report?
137 When a form is invoked with call_form, Does oracle forms issues a save point?
138 Can a property clause itself be based on a property clause?
139 What is a timer?
140 What are the two phases of block coordination?
141 What are Most Common types of Complex master-detail relationships?
142 What is a text list?
143 What is term?
144 What is use of term?
145 What is pop list?
146 What is the maximum no of chars the parameter can store?
147 What are the default extensions of the files created by library module?
148 What are the Coordination Properties in a Master-Detail relationship?
149 What is an index and How it is implemented in Oracle database?
150 Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
151 Give two methods you could use to determine what DDL changes have been made.
152 What are the types of calculated columns available?
153 Explain about stacked canvas views?
154 What are the built_ins used the display the LOV?
155 What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
156 What are the built-ins that are used to Attach an LOV programmatically to an item?
157 How do you call other Oracle Products from Oracle Forms?
158 What is the main diff. bet. Reports 2.0 & Reports 2.5?
159 What are the different file extensions that are created by oracle reports?
160 What is strip sources generate options?
161 What is the basic data structure that is required for creating an LOV?
162 What is the Maximum allowed length of Record group Column?
163 Which parameter can be used to set read level consistency across multiple queries?
164 What are the different types of Record Groups?
165 From which designation is it preferred to send the output to the printed?
166 what are difference between post database commit and post-form commit?
167 What are the different display styles of list items?
168 Which of the above methods is the faster method?
169 With which function of summary item is the compute at options required?
170 What are parameters?
171 What are the three types of user exits available?
172 How many windows in a form can have console?
173 If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
174 What are the two repeating frame always associated with matrix object?
175 What are the master-detail triggers?
176 What are the different objects that you cannot copy or reference in object groups?
177 What is an OLE?
178 Is it possible to modify an external query in a report which contains it?
179 Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
180 Can a repeating frame be created without a data group as a base?
181 If a break order is set on a column would it affect columns which are under the column?
182 Is it possible to set a filter condition in a cross product group in matrix reports?
183 Do user parameters appear in the data modal editor in 2.5?
184 Can you pass data parameters to forms?
185 Is it possible to link two groups inside a cross products after the cross products group has been created?
186 What are the different modals of windows?
187 What are modal windows?
188 What are the different default triggers created when Master Deletes Property is set to Non-isolated?
189 What are the different default triggers created when Master Deletes Property is set to isolated?
190 What are the different default triggers created when Master Deletes Property is set to Cascade?
191 What is the diff. bet. setting up of parameters in reports 2.0 reports2.5?
192 What are the difference between lov & list item?
193 What is the advantage of the library?
194 What is lexical reference?
195 What is system.coordination_operation?
196 What is synchronize?
197 What use of command line parameter cmd file?
198 What is a Text_io Package?
199 What is forms_DDL?
200 How is link tool operation different bet. reports 2 & 2.5?
201 What are the different styles of activation of ole Objects?
202 How do you reference a Parameter?
203 What is the difference between object embedding and linking in Oracle forms?
204 Name of the functions used to get/set canvas properties?
205 What are the built-ins that are used for setting the LOV properties at runtime?
206 What are the built-ins used for processing rows?
207 What are built-ins used for Processing rows?
208 What are the built-in used for getting cell values?
209 What are the built-ins used for Getting cell values?
210 Atleast how many set of data must a data model have before a data model can be base on it?
211 To execute row from being displayed that still use column in the row which property can be used?
212 What are different types of modules available in oracle form?
213 What is the remove on exit property?
214 What is WHEN-Database-record trigger?
215 What is a difference between pre-select and pre-query?
216 What are built-ins associated with timers?
217 What are the built-ins used for finding Object ID function?
218 Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
219 Use the Add_group_row procedure to add a row to a static record group 1. true or false?
220 Use the add_group_column function to add a column to record group that was created at a design time?
221 What are the various sub events a mouse double click event involves?
222 How can a break order be created on a column in an existing group?
223 What is the use of place holder column?
224 What is the use of hidden column?
225 What is the use of break group?
226 What is an anchoring object and what is its use?
227 What are the default parameter that appear at run time in the parameter screen?
228 What are the built-ins used for Creating and deleting groups?
229 What are different types of canvas views?
230 What are the different types of Delete details we can establish in Master-Details?
231 What is relation between the window and canvas views?
232 What is a User_exit?
233 How is it possible to select generate a select set for the query in the query property sheet?
234 How can values be passed between precompiler exits & Oracle call interface?
235 How can a square be drawn in the layout editor of the report writer?
236 How can a text file be attached to a report while creating in the report writer?
237 How can I message to passed to the user from reports?
238 How is possible to restrict the user to a list of values while entering values for parameters?
239 How can a button be used in a report to give a drill down facility?
240 How can a cross product be created?
241 What are different types of images?
242 What is the difference between boiler plat images and image items?
243 What is bind reference and how can it be created?
244 What are the triggers available in the reports?
245 Give the sequence of execution of the various report triggers?
246 Why is a Where clause faster than a group filter or a format trigger?
247 Why is it preferable to create a fewer no. of queries in the data model?
248 Where is the external query executed at the client or the server?
249 Where is a procedure return in an external pl/SQL library executed at the client or at the server?
250 What is coordination Event?
251 What is the difference between OLE Server & OLE Container?
252 What is an object group?
253 What is an LOV?