Resources » Articles/Knowledge Sharing » General

technical questions-DBMS


Posted Date: 10-Mar-2008  Last Updated:   Category: General    
Author: Member Level: Gold    Points: 4



1. What are the different types of joins?
Inner Join

outer join (left outerjoin , right outer join)
full outer join

2. Explain normalization with examples.


First Normal Form : Avaoids relation within a relation
Second Normal Form : Fully functional depended on each key
Third Normal Form : Avoids Transitivity dependency


3. What cursor type do you use to retrieve multiple recordsets?
ref cursors'


4. State the difference between a "where" clause and a "having" clause

having comes along with group by


5. What is the difference between "procedure" and "function"?

procedure doesnot return a value thru return statement


6. How will you copy the structure of a table without copying the data?

select * from table_naem where 1 > 3


7. How to find out the database name from SQL*PLUS command prompt?

-

8. Tadeoffs with having indexes


9. Talk about "Exception Handling" in PL/SQL?


10. What is the difference between "NULL in C" and "NULL in Oracle?"


11. What is Pro*C? What is OCI?


12. Give some examples of Analytical functions.


13. What is the difference between "translate" and "replace"?


14. What is DYNAMIC SQL method 4?


15. How to remove duplicate records from a table?


16. What is the use of Analyzing the tables?


17. How to run SQL script from a Unix Shell?


18. What is a "transaction"? Why are they necessary?


19. Explain Normalization and Denormalization with examples.


20. When do you get constraint violation? What are the types of constraints?


21. How to convert RAW datatype into TEXT?


22. What is the difference between Primary Key and Aggregate Key


23. How functional dependency is related to database table design?


24. What is a "trigger"?


25. Why can a "group by" or "order by" clause be expensive to process?


26. What are "HINTS"? What is "index covering" of a query?


27. What is a VIEW? How to get script for a view?


28. What are the Large object types supported by Oracle?


29. What is SQL*Loader?


30. Difference between "VARCHAR" and "VARCHAR2" datatypes.


31. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table.


32. Difference between "ORACLE" and "MICROSOFT ACCESS" databases

.
33. How to create a database link ?

-


Did you like this resource? Share it with your friends and show your love!




Responses to "technical questions-DBMS"
Author: Girish Patil    10 Mar 2008Member Level: Gold   Points : 1
Hi rajasekhar

Can you provide answers to these questions?
Girish



Author: Olufemi    10 Mar 2008Member Level: Gold   Points : 4
Hi,
It may be impossible for one to answer these questions at ago but it will be done in a bit and I will like to recommend a book on SQL that will give answers to almost all these questions if not all. This books will be attached to this post please do endeavour to check it out, it is a document type of file named SQL_Tutorials.

Rgds
Olufemi



SQL_Tutorial.doc
Author: rajasekhar    11 Mar 2008Member Level: Gold   Points : 4
thank you Olu temi.
your turorial is good.
i want say some of the books it will help alot for people who want to learn DBMS and Oracle.

1) Data Base Management Systems - Navathe,Elamsree,Somayajulu
2) Oracle 7i

Oracle 7i book is very much helpful for learns.after completion of 7i you should better to follow any other books like Oracle 9i complete reference



Author: Deepu    11 Mar 2008Member Level: Gold   Points : 3
Hi guys this is deepu,
Nice collection on SQL,but i want to know some thing about the stored procedures in SOL,Does any one know about these things,if yes please give me the information about the stored procedures,
With regards,
deepu.



Guest Author: Banerjee M     27 Feb 2013
DBMS technical questions and its explanation is nicely written but no complete detail than few questions here and there...


Feedbacks      

Post Comment:




  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)



    Type the numbers and letters shown on the left.


    Submit Article     Return to Article Index

    Awards & Gifts
    Active Members
    TodayLast 7 Daysmore...

    ISC Technologies, Kochi - India. Copyright © All Rights Reserved.