CBSE Class 12 Informatics Practices MYSQL Revision Tour Assignment

 

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.

 


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

Tags: 

 


Click to View or Download pdf file
Click for more Informatics Practices Study Material

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

Training Programme on the Alternative Academic Calendar

In view of the extraordinary situation prevailing in the world due to COVID-19 pandemic, the CBSE Board had announced the ‘Revised Academic Curriculum for classes 9- 12 for the session 2020-21’. The reduced topics will not be part of the internal assessment or for the...

CBSE Reduced Syllabus Clarification

CBSE board has issued the following clarification relating to various news reports regarding reduction in syllabus and questions from the reduced syllabus during board exams. Please read below: It has come to notice of the Board through a section of media reports that...

Cogito and The Question Book A series on Thinking skills by CBSE

The Board has dedicated this academic session 2020-21 for ‘Competency Based Learning’. Skills connected to Critical & Creative thinking, Problem Solving, Collaboration and Communication are core to successful living in the 21st Century. To focus on the importance...

CBSE Reduced Syllabus Class 9 and 10

The prevailing health emergency in the country and at different parts of the world as well as the efforts to contain the spread of Covid-19 pandemic has resulted in loss of class room teaching due to closure of schools. Therefore the CBSE Board has decided to revise...

Board Cancelled Official CBSE Statement

Keeping in view the requests received from various State Governments and the changed circumstances as on date, following has been decided- 1. Examinations for classes X and XII which were scheduled from 1st July to 15th, 2020 stand cancelled. 2. Assessment of the...

Internal Assessments and CBSE Reduced Syllabus

CBSE on 7th July 2020 had announced the ‘Revised Academic Curriculum for classes IX-XII for the session 2020-21’ to mitigate the effect of face to face learning loss due to the closure of schools to contain COVID-19 Pandemic. The rationalization of syllabus up to 30% ...

×
Studies Today