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

 

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 - 
MySQL revision - Class 12 Computer Informatics Practices - Download Ncert Cbse IP questions answers
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?


3 comments:
Write comments
  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete