CBSE Class 12 Informatics Practices MYSQL Revision Tour

Scroll down for PDF

CBSE Assignment for Class XII Informatics Practices -MYSQL Revision Tour . Based on CBSE and CCE guidelines. The students should read these basic concepts to gain perfection which will help him to get more marks in CBSE examination.

MYSQL REVISION TOUR

SOLVED QUESTIONS

1. What do you mean by a Database Management System?

Ans- Database Management is a collection of programs and files that allow a user to define structure of a database, store data into it, modify the structure and manipulate the data.

2. What do you mean by Relational database?

Ans-Relational Database is a type of database in which relation is used as its basic element.Row and columns are used to store data.

3. What is a foreign key?

Ans If a key is available in a table as a primary key then this key is called foreign key in another table.

4. What is primary key?

Ans-Primary key is a unique key in a relation which can uniquely identifies a tuple (row) in a given relation.

5. What is SQL?

Ans-SQL is stands for structured query language. This language is used to manipulate data stored in a table.

6. What is referential integrity?

Ans-This is a rule which ensures that in DBMS relationships between records in related tables are valid. And that user don’t accidently delete or change related data.

7. What is MySql?

Ans-Mysql is an open source RDBMS which uses SQL.

8. What is DDL?

Ans- DDL provides commands to define or redefine the schema of a table.Table is created,altered and dropped using DDL.

9. What are DML commands?

Ans- DML commands are used to manipulate data stored in a table.Insertion, deletion and modifications are possible using DML commands.

10. Maximum how many characters can be stored in a (i) text literals (ii) numeric literal

Ans-(i) Text literals can have 4000 bytes (ii) A numeric literals can store 53 digits.

11. What is null value in MySql?

Ans-If a column in a row has no value, then column is said to be null.

12. Which keyword eliminates redundant data in from a query result?

Ans- DISTINCT

13. How would you display system date as the result of a query?

Ans- CURDATE()

14. What is NOW() function in MySql?

Ans- It returns the current date and time.

15. What is NOT NULL constraint?

Ans- NOT NULL constraints impose a condition that value of a row cannot be left blank.

16. What is error in following statement? UPDATE EMPL;

Ans- WHERE clause is missing in given query.

17. Identify the error? DELETE ALL FROM TABLE EMP;

Ans-There is no need to write ALL and TABLE word in above query. Correct form is-DELETE FROM EMP;

18. Differeniate WHERE and HAVING clause?

Ans-:- Where clause is used to select particular rows that satisfy condition whereas having clause is used in connection with aggregate function, group by clause.


Please refer to attached file for CBSE Class 12 Informatics Practices MYSQL Revision Tour

Tags: 


Click on the text For more study material for Informatics Practices please click here - Informatics Practices

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Sample Papers for Class 12 Boards 2020

CBSE has released the final sample papers for the class 12 boards exams as per the new pattern as per which the question papers are expected to come in the 2020 board exams for class 12. The sample papers have been for class 12 for all subjects along with the suggested...

CBSE Instructs schools to form Eco Clubs

The Central Board of Secondary Education has directed schools to form Eco Clubs under the Board for Environmental Protection. They have further asked the schools to ensure that every student would save one litre of water at home and school every day. It was started by...

Extension of dates by CBSE for Single Girl Child Merit (SGC) scholarship

CBSE has announced to extend dates for SGC scholarship. Previously the dates to submit the SGC scholarship form were 18 October 2019. Now dates have shifted. For online submission, the last date is 31st October. Whereas date for submission of hard copies of renewal...

CBSE DATE SHEET 2020

Central Board of Secondary Education, CBSE is to conduct the 10th and 12th Board Examination 2020 from February 15, 2020. Due to University Admissions, CBSE has shifted Board Exams dates from 1 March to February 15 from 2019. This year too CBSE would be making changes...

Seven Motivational tips for every student

If you’re are a student or a learner and you doesn’t feel like study then this article is going to be very important for you, Reading constantly and Staying motivated as a student is one of the most challenging tasks and barriers to educational success. Education is...

CBSE and Microsoft join hands to build capacity for AI learning for schools

Central Board of Secondary Education and Microsoft join hands to build capacity for AI learning for schools : The officials from the Central Board of Secondary Education have announced that they have partnered with Microsoft India to conduct several capacity building...

×
Studies Today