Database Interview Questions

 
1.
What does CLIPPER stand for?
2.
Do I need CCP4?
3.
Why C++ used in Clipper?
4.
Why use references rather than pointers in the public API, particularly for arguments which are modified?
5.
Can I use Fortran/C/Python/Visual Basic?
6.
What is the license for Clipper?
7.
Why do not you use GNU autoconf or SCONS for building?
8.
Why not PHENIX, the Zelinka/Otwinoski libraries, etc?
9.
What is NetLib for Clipper?
10.
If I use NetLib, will I find many other users to network with?
11.
Why do I need NetLib?
12.
Is it possible to break NetLibs encryption?
13.
Does NetLib support Windows 95?
14.
What versions of Clipper does NetLib support?
15.
Who is Communication Horizons?
16.
How easy is NetLib to use?
17.
Give us a non-computer example of preemptive and non-preemptive scheduling?
18.
What is the difference between star flake and snow flake schema?
19.
What is data sparsity and how it effect on aggregation?
20.
What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
21.
When should you consider denormalization?
22.
What is ERD?
23.
What is third normal form?
24.
Why are recursive relationships are bad? How do you resolve them?
25.
Is this statement TRUE or FALSE? all databases must be in third normal form?
26.
What is an artificial (derived) primary key? When should it be used?
27.
What is second normal form?
28.
What is data structure?
29.
List out the areas in which data structures are applied extensively?
30.
If you are using C language to implement the heterogeneous linked list, what pointer type will you use?
31.
What is the data structures used to perform recursion?
32.
What are the methods available in storing sequential files ?
33.
List out few of the Application of tree data-structure?
34.
In RDBMS, what is the efficient data structure used in the internal storage representation?
35.
What is a spanning Tree in data structure?
36.
Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?
37.
Whether Linked List is linear or Non-linear data structure?
38.
What is the quickest sorting method to use?
39.
How can I search for data in a linked list?
40.
What is the heap in data structures?
41.
What is the easiest sorting method to use in data structures?
42.
What is the bucket size, when the overlapping and collision occur at same time?
43.
In an AVL tree, at what condition the balancing is to be done?
44.
Minimum number of queues needed to implement the priority queue?
45.
How many different trees are possible with 10 nodes ?
46.
What is a data structure node class?
47.
When can you tell that a memory leak will occur?
48.
What is placement new in data structures?
49.
Tell how to check whether a linked list is circular ?
50.
What is the difference between ARRAY and STACK in Data Structures?
51.
What is the difference between NULL AND VOID pointer in Data Structures?
52.
What is precision in Data Structures?
53.
What is impact of signed numbers on the memory using Data Structures?
54.
How memory is reserved using a declaration statement in data structure?
55.
How many parts are there in a declaration statement using data structures?
56.
Is Pointer a variable in data structure?
57.
What is significance of � * � ?
58.
Why do we Use a Multidimensional Array in data structure?
59.
How do you assign an address to an element of a pointer array ?
60.
Run Time Memory Allocation is known as in data structure?
61.
What method is used to place a value onto the top of a stack?
62.
What method removes the value from the top of a stack?
63.
What does isEmpty() member method determines?
64.
What is a queue in data structure?
65.
What is the relationship between a queue and its underlying array?
66.
Which process places data at the back of the queue?
67.
Why is the isEmpty() member method called?
68.
How is the front of the queue calculated in data structure?
69.
What does each entry in the Link List called?
70.
What is Linked List in data structure?
71.
What member function places a new node at the end of the linked list?
72.
How is any Data Structure application is classified among files?
73.
Which file contains the definition of member functions?
74.
What are the major data structures used in the following areas : RDBMS, Network data model & Hierarchical data model?
75.
Difference between calloc and malloc in data structures?
76.
Explain the syntax of named procedure?
77.
How to find the first two highest salaries in deptno in emp table?
78.
What is difference between primary key and unique key?
79.
What is the use of foreginkey?
80.
How to create an external table?
81.
What is the difference between case version and decode version?
82.
What is the family trees and connection by clause?
83.
How to find the duplicate rows count from employees table in oracle?
84.
In which phase of mload can i use .FILLER?
85.
Write short notes on XSU and JAVA?
86.
What is Database Definition (DBD)?
87.
What is DL/I?
88.
What is PCBs (Program communication blocks)?
89.
What is a hierarchical database?
90.
Explain a checkpoint and When does it occur?
91.
Explain the Hierarchical Database?
92.
What is IMS Software Environment?
93.
Explain Phantom Deadlock?
94.
Explain atomicity and aggregation?
95.
Explain the advantages and disadvantages of a Hierarchical Database?
96.
Explain the main control blocks available in IMS DB?
97.
Explain a Database Server?
98.
What is network database?
99.
Explain What are the two types of OLTP?
100.
Explain What are called Fat clients and Fat servers?
101.
What is building blocks of Client/Server?
102.
Explain meant by 3-Tier architecture?
103.
Explain What is meant by Asymmetrical protocols?
104.
Explain What are the types of Transparencies?
105.
Explain What are Triggers and Rules?
106.
Explain What are Super servers?
107.
Explain What are TP-Lite and TP-Heavy Monitors?
108.
Explain a TP Monitor?
109.
Explain What are Service-specific middleware?
110.
Can I concurrently access a Firebird database with embedded and with regular server?
111.
How to activate all indexes in Firebird?
112.
How to add, remove, modify users using SQL?
113.
How to change database dialect?
114.
How to configure events with firewall?
115.
How do convert or display the date or time as string?
116.
How to create a database from my program?
117.
How to deactivate triggers?
118.
How to debug stored procedures?
119.
How to detect applications and users that hold transactions open too long?
120.
How to detect the server version?
121.
How to determine who is and change the owner of database?
122.
How to pipe multiline string to isql?
123.
How to open the database in exclusive mode?
124.
How to move a multi-file database?
125.
How to monitor Firebird server activity?
126.
How to migrate Paradox, dBase or FoxPro database to Firebird?
127.
How to lock records in a table?
128.
How to load a file into database column?
129.
How to get a list of tables, views and columns in Firebird database?
130.
How to extract metadata for the entire database?
131.
How to export data from database and import into another?
132.
How to drop all foreign keys in database?
133.
How to do replication of Firebird databases?
134.
How to disconnect the user connection?
135.
How to prevent firebird.log file from filling up the disk partition?
136.
How to pump the data from one database to another?
137.
How to recreate the index on a Firebird table?
138.
How to reorder the table columns (fields)?
139.
How to repair a corrupt Firebird database?
140.
How to select a random record from a table?
141.
How to specify transaction or query timeout?
142.
How to stop SuperServer service on Linux using only Firebird tools?
143.
How to tell Firebird to only accept conections from XYZ host or network?
144.
How to use events with ZeBeDee, SSH or stunnel?
145.
How to write UDF s in Delphi?
146.
Is it possible to determine clients IP address?
147.
Is there a way to automate SQL execution from the command-line, batch job or shell script?
148.
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
149.
Is there an example how to configure ExternalFileAccess setting in firebird.conf?
150.
Is there an example how to configure UdfAccess setting in firebird.conf?
151.
Is there some bulk load or other way to import a lot of data fast?
152.
What is the best way to determine whether Firebird server is running?
153.
Why does reading require write privileges on database file?
154.
what are the bind parameters IBM DB2?
155.
Is it Possible to declare or create a cursor for UPDATE of
table? If yes tell me how? If no Tell me why?
156.
Cursors can be declared in both working-storage & procedure
division, Agreed.
But is there any difference? If could you please suggest
what is the difference.
TIA
157.
If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
158.
could you give me an example how, where i code CHECKPOINT
and restart. I need and example
159.
Can you search give an array in the WHERE clause of a db2
query?
160.
Can i insert bulk records into a db2 table using qmf of
spufi only.
161.
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables.
162.
when we are tying to update a table having 100 rows. if the
program abends when updating 51 row . how to start updating
again from the 51 row . What was the logic?
163.
what is the difference between normal select query and
currosor
164.
What are Bind concepts in DB2 cobol?
165.
When DB2 connection fails, will online program work or give
errors?
166.
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
167.
What is DCLGEN ?
168.
Can GROUP BY and ORDERED BY used in a single query?
169.
Can you have more than one cursor open at any one time in a program ?
170.
What is a composite index and how does it differ from a multiple index?
171.
What are the disadvantages of PAGE level lock?
172.
How does DB2 determine what lock-size to use?
173.
What are delete-connected tables?
174.
What is a precompiler?
175.
What is the diff bet plan,package,dbrm?
176.
Give the COBOL definition of a VARCHAR field.
177.
When can an insert of a new primary key value threaten referential integrity?
178.
What are foreign keys in DB2?
179.
Is DECLARE CURSOR executable?
180.
What is the self-referencing constraint?
181.
A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.
182.
What is a clustering index ?
183.
What is the difference between primary key & unique index ?
184.
What is sqlcode -922 ?
185.
What is sqlcode -811?
186.
Somehow Informix fails to go online. Is there a way to view what oninit is doing?
187.
I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?
188.
Can I install Informix on a non-English version of Windows NT?
189.
What is the informix-list@iiug.org mailing list?
190.
What Rules Exist Regarding Format, Content, Flame Wars, etc
191.
Can I ask about Perl, DBI and DBD Informix? Other products?
192.
What is chunk in Informix?
193.
What is Informix instance?
194.
What are the uses of key value locking in Informix?
195.
Who conceived and designed the Informix database management system?
196.
What is the option or command used in Informix for finding which dbspace a database resides?
197.
Who developed informix?
198.
Mention the database server operating modes available for Informix?
199.
Explain about light scans in Informix?
200.
What is extent in Informix?
201.
What is Informix Binary Large Object?
202.
How do you call a Stored Procedure from JDBC?
203.
Is the JDBC-ODBC Bridge multi-threaded?
204.
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
205.
What is 2-phase commit?
206.
When we will Denormalize data?
207.
What is cold backup, hot backup, warm backup recovery?
208.
What is a �dirty read�?
209.
What is the advantage of using PreparedStatement?
210.
What is Metadata and why should I use it?
211.
What are different types of Transaction Isolation Levels?
212.
How do you handle your own transaction?
213.
What is the normal procedure followed by a java client to access the db?
214.
What is a data source (DS)?
215.
What are collection pools? What are the advantages?
216.
How do you get Column names only for a table (SQL Server)?
217.
What is SonicMQ?
218.
What is openEdge translation manager?
219.
What is Progress open edge?
220.
What is Progress Actional?
221.
What is advantages of Progress Actional?
222.
Define and explain about progress?
223.
Explain some of the uses of OpenEdge architect features useful for a Developer?
224.
Explain the scenarios or situations under which Progress Database creates new index entry for a record?
225.
What are the features of Openedge features?
226.
What is openEdge RDBMS?
227.
What is Progress Apama?
228.
Explain the use of ASSIGN statement in progress database?
229.
What is openEdge ABL in terms of taking the perspective of the developer?
230.
What is OpenEdge Workgroup RDBMS?
231.
What is environment of Openedge?
232.
Explain environment of Openedge?
233.
What is Actional Flow mapping?
234.
What is the current version of PostgreSQL?
235.
How to pronounce PostgreSQL?
236.
What are new features postgre 9.1?
237.
Does PostgreSQL run on the Cloud?
238.
How does PostgreSQL compare to "NoSQL"?
239.
How does PostgreSQL compare to Oracle/DB2/MS SQL Server/Informix?
240.
How does PostgreSQL compare to MySQL?
241.
What company owns PostgreSQL?
242.
How many PostgreSQL users are there, worldwide?
243.
How many developers work on PostgreSQL?
244.
How to find nth lowest salary?
245.
When will data in the data base is updated?
246.
What is the advantage of RAID?
247.
Explain what is PostgreSQL?
248.
State some of the advanced features of PostgreSQL?
249.
Explain about Write Ahead logging?
250.
Explain about Multi version concurrency control?
251.
How to start the database server?
252.
How to stop the database server?
253.
How to check whether PostgreSQL server is up and running?
254.
What are the languages which PostgreSQL supports?
255.
Explain about the command enable debug?
256.
Explain about functions in PostgreSQL?
257.
Explain about indices of PostgreSQL?
258.
Explain about Triggers?
259.
What are the different data types supported by PostgreSQL?
260.
Explain about database administration tools?
261.
Explain about pgadmin?
262.
How do you create a data base with postgreSQL?
263.
What are the various enhancements to the straight relational data model by PostgreSQL?
264.
Explain about tokens?
265.
Explain about string constants?
266.
Explain about concurreny with the help of MVCC?
267.
How to created a database?
268.
How to list the number of database?
269.
How to take backup of database?
270.
How to create a PostgreSQL user?
271.
Explain 2NF?
272.
Explain 3NF?
273.
Explain 4NF?
274.
Explain DML Compiler?
275.
Explain 5NF?
276.
Explain DDL Interpreter?
277.
Explain degree of a Relation?
278.
Explain Fully Functional dependency?
279.
Explain the different types of JOIN operations?
280.
Explain Relational Algebra?
281.
Explain BCNF (Boyce-Codd Normal Form)?
282.
Explain Armstrong rules? How they are complete and/or sound?
283.
Explain Data Independence?
284.
What you know in mapping of ERD to DFD?
285.
Explain VDL (View Definition Language)?
286.
Explain DML (Data Manipulation Language)?
287.
What is the SQL?
288.
What is SQL*Plus?
289.
What is NVL?
290.
What is Date Functions?
291.
What is Character Functions?
292.
What is TTITLE and BTITLE?
293.
What is COLUMN?
294.
What is BREAK?
295.
What is COMPUTE?
296.
What is SET?
297.
What is SPOOL?
298.
What is a JOIN?
299.
What is Union?
300.
What is Intersect?
301.
What is Minus?
302.
What is Correlated Subquery?
303.
What is Multiple columns?
304.
What is Sequences?
305.
What is Synonyms?
306.
What is Indexes?
307.
What is Data types?
308.
Order of SQL statement execution?
309.
What is Transaction?
310.
What is Commit?
311.
What is Posting?
312.
What is Rollback?
313.
What is Savepoint?
314.
What is Set Transaction?
315.
What is Locking?
316.
What is Consistency?
317.
What is SQL Integrity?
318.
What is SQL Deadlock?
319.
What is Mutating SQL Table?
320.
What is SQL*Loader?
321.
The most important DDL statements in SQL are?
322.
Operators used in SELECT statements are?
323.
SELECT statements in SQL?
324.
The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records?
325.
The INSERT INTO Statements in SQL?
326.
The Update Statement in SQL.
327.
The Delete Statements in SQL.
328.
Sort the Rows in SQL.
329.
The IN operator may be used if you know the exact value you want to return for at least one of the columns.
330.
BETWEEN ... AND operators in SQL.
331.
What is the use of CASCADE CONSTRAINTS?
332.
How does Notification Services Work?
333.
What are Notification services?
334.
Explain architecture of SQL Server Notification services?
335.
What are the basic components of Notification services?
336.
What are the restrictions applicable while creating views?
337.
Define Primary and Unique key?
338.
Explain the difference between a primary key and a unique key?
339.
Define Distributed Query and Linked Server?
340.
What is Distributed Queries?
341.
What is a linked server?
342.
Explain OPENQUERY function and OPENROWSET function?
343.
Define transaction and transaction isolation levels?
344.
What is Isolation Levels?
345.
Define data, entity, domain and referential integrity?
346.
What are the lock types?
347.
What can SQL Server Reporting Services do?
348.
Explain the architecture of reporting services?
349.
Describe Reporting Lifecycle?
350.
What are the ways to tune Reporting Services?
351.
How to schedule SSAS Database backup.
352.
How to Generate an Auto Incremental Number in a SSIS Package?
353.
Lookups are a key component in SQL Server Integration Services (SSIS). Explain its purpose?
354.
How to unzip a File in SSIS?
355.
Define Truncate and Delete commands?
356.
What are the ways to controlling Cursor Behavior?
357.
Define Identity and uniqueidentifier property of Column?
358.
What happens when my integer IDENTITY runs out of scope?
359.
What are the advantages of using Stored Procedures?
360.
Describe the purposes and advantages stored procedure?
361.
What is RAID (Redundant Array of Inexpensive disks)? Explain its level?
362.
What is RAID controller technology?
363.
What is RAID and what are different types of RAID configurations?
364.
What is a stored procedure?
365.
What are the uses of stored procedure?
366.
What is the difference between a user defined function and a Stored procedure?
367.
Explain about the implementation of stored procedures?
368.
State the different extensions for stored procedures?
369.
State about the security aspects of stored procedures?
370.
Does storing of data in stored procedures increase the access time? Explain?
371.
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
372.
Explain about the implementation of business logic in Stored procedures?
373.
Explain the benefits of running stored procedure on a database engine?
374.
Explain about recursive stored procedures?
375.
Explain about the process which takes place to execute a Stored routine?
376.
Explain about the RETURN statement?
377.
Explain about cursors?
378.
Explain about the properties of Cursors?
379.
How do you notify DBPAK about Stored Procedure?
380.
Explain about the case statement present in Stored procedure?
381.
How teradata makes sure that there are no duplicate rows being inserted when its a SET table?
382.
What is the difference between Global temporary tables and Volatile temporary tables?
383.
What is an optimization and performance tuning and how does it really work in practical projects?
384.
What is explain and how does it work?
385.
What are the enhanced features in Teradata V2R5 and V2R6?
386.
What the default privileges which get assigned ?
387.
What is cliques? What is Vdisk and how it will communicate with physical data storage at the time of data retrieval through AMP?
388.
What is basic teradata query language?
389.
How many codd s rules are satisfied by teradata database?
390.
What is the difference between Multiload and Fastload interms of Performance?
391.
Does SDLC changes when you use Teradata instead of Oracle?
392.
Which two statements are true about a foreign key?
393.
What are two examples of an OLTP environment?
394.
What is a common data source for the central enterprise data warehouse?
395.
Which two can be implemented as a centrally located logical architecture?
396.
What is the difference between start schma and Fsldm?
397.
Can we have an unconnected lkp to lookup a DB2 record against a Teradata record? doesnt seem to work. I could be wrong.
398.
What is stored procedure in Teradata?
399.
What is Group by in Select statement?
400.
How many codd,s rules are satisfied by teradata database?