Top 10 sql server questions and answer

SQL is the Query Language it can be used for writing queries to store data in database.Before learning sql server completely first we have to learn the sql basics like why it can be used what is database ,what is sql why it can be used for storining data through what is data etc...

SQL Technical Questions

1. What is a data?

A. Data is collection of facts. Data can exists in many forms like numeric,character or other data(audio file,video file).

                                                *****SQL Technical  Questions*****

2. What is database?

A. Database is collection of related data which is organized in a proper manner.

Ex:- MySQL,Ms SQL server,Oracle.

                                               *****SQL Technical  Questions*****

3. What is data source?

A. Data source is a place where the data is available. Data source may be a flatfile or excel or email or xml or database,etc.

                                                *****SQL Technical  Questions*****

4. What is SQL?

A SQL is a query language which is used to interact with the database.

                                                  *****SQL Technical  Questions*****

5. What is DBMS?

A. DBMS is a software which enables the user to access the database.

                                                  *****SQL Technical  Questions*****

6. What is datatype?

A. Datatype specifies the type of the data that we can store in the memory.

                                                  *****SQL Technical  Questions*****

7. What is a database server?

A. It is a software which is used to store the data. Database server will automatically run by os.

                                                  *****SQL Technical  Questions*****

8. What is a table?

A. Table is a database object which is used to store the data in the form of rows and columns.

                                                  *****SQL Technical  Questions*****

9. How to create a database?

A. By using commands we can create the database.

Syntax for create database

               create database databasename

Ex:- create database Employee

                                                  *****SQL Technical  Questions*****

10. How to use database?

A. Syntax for use database

                use database databasename

Ex:- use database Employee

                                                 *****SQL Technical  Questions*****

Share With Your Friends in Social Media (Facebook, Twitter, Google Plus Etc...) if You Like Our Content And Feel Free To Comment.