Database Questions.......  

Posted by Rajiv Pandey

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images.
databases are sometimes classified according to their organizational approach. The most prevalent approach is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network. An object-oriented programming database is one that is congruent with the data defined in object classes and subclasses....

Some frequently asked questions :-

1. Why data reshuffling is required?
2. What is Dedicated Server and Shared Server?
3. Oracle Referential Backup?
4. How do you create a primary key to existing table with duplicate records?
5. How do you sort a table?
6. Different types of table join?
7. How do you handle exceptions and errors in stored procedures?
8. What is DDL, DML?
9. Name some built-in functions that can be used in SQL queries?
10. If you have an open cursor on a table, modify the same tableand commit, what would happen?
11. How would you pass hints to the SQL processor?
12. Do you need a commit after DDL statements?
13. How can you find all the tables created by an user?
14. What is a lookup table in database? where can we use these type of table?
15. Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i?
16. What is the relation between free list and buffer busy wait?
17. What is addressing modes? What is a node, How to insert into nodes?
18. How to provide much and more security to my users in the database?
19. What is the main difference between replication and logshipping?
20. Is there any difference between transaction id and SCN ?
21. what is the difference between database refresh and database cloning?
22. How do you create a primary key to existing table with duplicate records?
23. What is Dedicated Server and Shared Server?
24. Why data reshuffling is required?
25. Name of the class of SQL?
26. What is the difference between "procedure" and "function"?
27. How will you copy the structure of a table without copying the data?
28. What is the difference between "translate" and "replace"?
29. What is DYNAMIC SQL method ?
30. How to remove duplicate records from a table?
31. What is the use of Analyzing the tables?
32. How to run SQL script from a Unix Shell?
33. Explain Normalization and De normalization with examples?
34. Difference between Primary Key and Aggregate Key?
35. How functional dependency is related to database table design?
36. What is a "trigger"?
37. Difference between "VAR CHAR" and "VARCHAR2" datatypes?
38. What is a VIEW? How to get script for a view?
39. Difference between "ORACLE" and "MICROSOFT ACCESS" databases?
40. How to create a database link?

This entry was posted on Sunday, October 28, 2007 at Sunday, October 28, 2007 . You can follow any responses to this entry through the comments feed .


Post a Comment