I am good in MySQL so i will teach you MySQL.......

       

MySQL important questions

Posted on November 30, 2015 by arelshane

Introduction to MySQL

Questions & Answers :

1.What is a database ?

Ans :  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.

2.What is a Database Management System(DBMS) ?

Ans :  DBMS is a software that enables the user to create or maintain a                      database. eg.MySQL

3. Give 5 examples of DBMS ?

Ans : Examples of the DBMS are MySQL,postgre,ms sql server,oracle  and sybase

4.What is the difference between primary key and candidate key ?

Ans : A Candidate Key can be any column or a combination of column that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as  Primary Key.

A Primary Key is a column or a combination of columns that  uniquely identify a record. Only one Candidate Key can be Primary Key.

5. what is relational database ?

Ans:A database structured to recognize relations between stored item of  information.

                            ———–*******THE END **********————