MySQL revision - Class 12 Computer Informatics Practices - Download Ncert Cbse IP Questions Bank with Answers

CBSE Guide NCERT Solutions  >  Class 12 Informatics Practices 

MySQL Class 12 CBSE Informatics Practices: IP Questions and Answers

Here we present you CBSE guess and sample questions (download answers in pdf at the end) on Computer Informatics Practices (IP) chapter MySQL revision, a Ncert Cbse Guide important for CBSE Board and other exams - 

CBSE Class 12 Informatics Practices (IP) 

Question.1: Define Primary Key, Candidate Key,  Alternate Key,  Foreign Key.

Question.2: What is Degree, Cardinality?

Question.3: Difference between CHARM and VARCHAR

Question.4: Name ACID properties (transaction properties)

Question.5: What is SQL?  Name the classification of SQL statements.

Question.6: How would you display tablets in a database?

Question.7:  Which SQL clause is used to restrict the rows returned by a Query?

Question.8: Write MySQL command to display list of existing databases.

Question.9: Which command is used to add a new tuple in a table?

Question.10: Difference between WHERE clause and HAVING clause.

NCERT Guide for Class XII - Informatics Practices (IP) | CbseNcertSolution.com
MySQL Quick Review with Solutions of IP Questions

Question.11: A Table "TRAINS" has degree 3 and Cardinality 8. What is the number of ray and columns in it?

Question.12: Difference between COUNT (*) and COUNT (column).

Question.13: How would you view constraints, Viewing columns associated in a Relation (table)?

Question.14:What is the difference between Drop Table and Delete?

Question.15: What is the purpose of ORDER By clause?

Question.16: What are the TCL commands?

Question.17: How would you begin a new Transaction?

Question.18: Write a statement to set onto commit to off.

Question.19: How would you delete a column from a table (give syntax).

Question.20: How would you change a data type of a column?

Class 12 Ncert Cbse Guide and Guess for Computer Informatics Practices (IP)

A quick review for the chapter MySQL : CBSE Guess Questions and Answers

Question.21: Which command is used to save the changes permanently in the data base?

Question.22: Which command is used to undo (or) cancel the previous transaction in a database?

Question.23: What is the purpose of SELECT statement?  Give its syntax.

Question.24: Write the operators used in SQL.

Question.25: Neha created a table layer on she realised that there is a need to include CLASS column. Which command she should use to do so? (Table Name is Student)

CBSE Guess for Informatics Practices - Class 12 IP MySQL revision NCERT Guide with Solutions of CBSE Questions important for Board Exams

Question.26: A table named "OFFICE" has 6 rows 10 columns and another table named"STAFF" has 3 rows and 5 columns5.  How many rows ams columns will be there, if we obtain the Cartesian product of these two tables?

Question.27: What are the six relational operations?

Question.28: Write a MySQL command for creating a table EMPSALARY. Whose structure is given below:

Field Name	Data type (size)	Constraint
EMPID	INTEGER(5)	Primary Key
EMPNAME	VARCHAR (20)	Not Null
SALARY	SALARYDECIMAL (8,2)
DOJ	Date

Question.29: Which command is used to create a new database?

Question.30: Which command in MySQL is used to open a specific database?

Question.31:Which command in MySQL is used to view the structure of a table?

Question.32: What is a NULL value?

Question.33: What is Cartesian Join?

Question.34: What is Equi-Join?

Question.35: Which command is used to modify existing data in a table?

Question.36: Which command is used to delete rows from a table?

Question.37: What are constraints? Give examples.

Question.38: In a database there is a table Cabinet. The data entry operator is not able to insert a null value in a column. What may be the possible reasons?

Question.39: Do the primary key of a table accept null or duplicate values?

Question.40: What is Transaction?

Question.41: What is the purpose of inserting Savepoint?

Question.42: What is the difference between Rollback and Rollback To?

Download / View Answers (pdf)