MySQL

Question 1

Advantages of DBMS

Answer 1

Elimination of data redundancy

Data consistency on all devices

Sharing of data

Improved data integrity

Privacy and security

Backup and recovery

Question 2

Attribute

Answer 2

Column

Question 3

Tuple

Answer 3

Each row

Question 4

Cardinality

Answer 4

Down

Question 5

Degree

Answer 5

Side

Question 6

Primary key

Candidate key

Answer 6

Primary key- An attribute of a group of attributes that can uniquely identify tuples within the relation.

Candidate - capable of…

Question 7

Alternate key

Answer 7

A candidate key that’s not primary

Question 8

Foreign key

Answer 8

Non key attribute whole value is derived from primary key or something other table

Question 9

Remove an existing database
Create a database
Open the database
Create a table
View table
View table structure
Drop table

Answer 9

Drop database E;
Create database N;
Use N;
Create table A (…..);
Show A;
Descrbe A; or desc A;
Drop table A;

Question 10

Add column Aa
Modify the column desc
Rename column to Ab
Remove the column

Answer 10

Alter table N add (Aa int primary key);
Alter table N modify (Aa varchar(20));
Alter table N change Aa Ab varchar(5);
Alter table N drop Ab;

Question 11

Add and remove primary key

Answer 11

Alter table N add PRIMARY KEY(Ab);
Alter table N drop PRIMARY KEY;

Question 12

Insert into

Answer 12

INSERT INTO N(…) VALUES(…);

Question 13

Add row

Answer 13

INSERT INTO XX VALUES(BLAH BLAH);

Question 14

Change a data
Update a data

Answer 14

UPDATE N SET Ab=12;

Question 15

Truncate
Delete

Answer 15

Removes all tuples and free the table
Delete deletes.

TRUNCATE TABLE N;