Sql Server Interview Questions and Answers Part 2

1. What is SQL?
A.SQL is Structured Query Language, which is a computer language for storing, manipulating  and retrieving data stored in relational database. SQL is the standard        language for Relation Database System.

2. What is SQL Server?
A.Sql server is   client/server Relational Database management system .It’s used to store large amount of data and its Transact-sql request between a client and a        Sql server. All relational database management systems like My SQL, MS Access, Oracle, Sybase, Informix, and SQL Server.
   Any project contains two tolls or software.
    1. Front end tool.
 2. Back end Toll


3 What is Front end tool?
A. Front end tool is developing the application or project and it contains designing of forms,WebPages, and coding.
 Ex. Java, Dot.net


4. What is Back end tool?
 A.Back end Toll is Store the large amount of data.
    Ex: Sql server, Oracle.


5. Why SQL? 
A.Sql Allows to access data in relational database management systems.
   1.To describe the data.
   2. To define the data in database and manipulate that data.
   3. To embed within other languages using SQL modules, libraries & pre-compilers. 
   4. To create and drop databases and tables.
   5.To create view, stored procedure, functions in a database.
   6.To set permissions on tables, procedures and views


6. What is database?
A. Database is a collation of large amount of Data.

7. What is data?
A.Data is collection of facts and figures.

8. What is RDBMS?
A.RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL and for all modern database systems like MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.         A Relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd.

9. How many types of Data base?
A.Data base are of Two Types:
    1. System database.
    2. User Database.


10. What is System Database?
A. These databases are created and maintained by sql server for its functionality. By default when sql server installed we get the following system database.
    1. Master database.
    2. Model database.
    3. Msdb.
    4. TEMPdb.
    5. Restore.






Subscribe

Receive Quality Tutorials Straight in your Inbox by submitting your Email below:

Delivered by FeedBurner

Protected by Copyscape Duplicate Content Checker