If Any request contact us :techtanu17@gmail.com << Catch on Facebook << If any link broken, Plz tell. we try to fix them.

Friday 13 September 2013

SQL INTERVIEW QUESTIONS PART-1 FREE DOWNLOAD

HI FRIENDS,
           HERE YOU CAN GET SOME IMPORTANT QUESTIONS THAT ARE ASK IN ALL INTERVIEW AND VI-VA.

HERE I COVERED MANY TOPIC WITH DIFFERENT QUESTIONS. THESE QUESTIONS ARE FOR BEGINNER  OR PROFESSIONALS.


INTERVIEW QUESTIONS ARE ON TOPIC THAT ARE COVERED IN THIS BLOG AREJAVA, C. C++, SOFTWARE TESTING, SOFTWARE ENGG, NETWORKING ETC.

 




1. What is DBMS ?

Database management system is a collection of programs that enables user to store , retrieve , update and delete information from a database .

2. What is RDBMS ?


Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model . Data from relational database can be accessed or reassembled in many different ways without having to reorganize the database tables . Data from relational database can be accessed using a API , Structured Query Language (SQL)


3. What is SQL ?


Structured Query Language(SQL) is a language designed specifically for communicating with databases. SQL is an ANSI (American National Standards Institute) standard .


4. What are the different type of Sql's?

1. DDL – Data Definition Language

DDL is used to define the structure that holds the data. For example. table

2. DML – Data Manipulation Language

DML is used for manipulation of the data itself. Typical operations are Insert,Delete,Update and retrieving the data from the table

3. DCL – Data Control Language

DCL is used to control the visibility of data like granting database access and set privileges to create table etc.


5. What are the Advantages of SQL ?

1. SQL is not a proprietary language used by specific database vendors. Almost every major DBMS supports SQL, so learning this one language will enable programmer to interact with any database like ORACLE, SQL ,MYSQL etc.

2. SQL is easy to learn. The statements are all made up of descriptive English words, and there aren't that many of them.

3. SQL is actually a very powerful language and by using its language elements you can perform very complex and sophisticated database operations.

FOR MORE DOWNLOAD FROM BELOW LINK


SO DOWNLOAD INTERVIEW QUESTION FROM BELOW LINK.



BEST OF LUCK IN ADVANCE......GOD IS ALWAYS WITH YOU

IF yOU HAVE ANY STOCK OF QUESTION, THEN PLEASE SEND ME FOR OTHER HELPFUL STUDENTS.

 
THANK


0 comments:

Post a Comment