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 **********————

shanevijay

Monday, 30 November 2015

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

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

MySQL important questions