Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 1

Q1. Write full form of DBMS.

Q2. Define the following term

1. Primary Key
2. Foreign Key
3. Candidate Key
4. Alternate Key

Q3. A group of rows and columns is called _______________

Q4. Candidate Key - Primary key = ___________________

Q5. Give two examples of DBMS software.

Q6. What is the difference between Data and Information?

Q7. A primary key is one of the candidate key. (True/False)

Q8. What do you mean by degree and cardinality in DBMS?

Q9. What is the alternate name of column in table?

Q10. What is the alternate name of row in table?

SOLUTIONS:

Q1. Write full form of DBMS.

Ans. Database Management System

Q2. Define the following term

1. Primary Key
2. Foreign Key
3. Candidate Key
4. Alternate Key

Ans. 

1. A field which uniquely identifies each and every record.
2. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. It is used to link two tables.
3. Those fields which can act as a primary key are called candidates key

Q3. A group of rows and columns is called _______________

Ans Table

Q4. Candidate Key - Primary key = ___________________

Ans. Alternate Key

Q5. Give two examples of DBMS software.

Ans. Oracle, MS Access, MySQL

Q6. What is the difference between Data and Information?

Ans. Raw facts and figures is called Data. 

        Processed data is called information

Q7. A primary key is one of the candidate key. (True/False)

Ans. True

Q8. What do you mean by degree and cardinality in DBMS?

Ans. Number of rows in a table is called cardinality

        Number of columns in a table is called degree.

Q9. What is the alternate name of column in table?

Ans. Attribute and Field 

Q10. What is the alternate name of row in table?

Ans. Record and Tuple