CBSE Class 12 Informatics Practices Worksheet - Revision (3)

Scroll down for PDF

CBSE Class 12 Informatics Practices Worksheet - Revision (3)

Chapter wise assignments are being given by teachers to students to make them understand the chapter concepts. Its extremely critical for all CBSE students to practice all assignments which will help them in gaining better marks in examinations. All assignments available for free download on the website are developed by the best teachers having many years of teaching experience in CBSE schools all over the country. Students, teachers and parents are advised to download the CBSE study material.

 

INTERNATIONAL INDIAN SCHOOL, RIYADH

INFORMATICS PRACTICES

WORK SHEET – II TERM

CLASS: XII

Q1:

Q2:

(a)

Which commands in MySql is used to make any Database current Database and see the list of table in that data base?

(b)

What do you mean by table level constraint and column level constraints? Give example for that.

(c)

How primary key in a table is different from unique key constraint?

(d)

What is the purpose of following query statements. Write output.

Select round(4325.7869,2);

Select truncate(4325.7869,2);

(e)

What is the difference between Group by and Order by clause?

(f)

A table Alpha contains 4 records and table Beta contains 7 records what will be total number of records in their Cartesian product?

(g)

Write SQL statement to add a column regno of data type varchar in a table Candidate which is primary key?

(h)

Mrs Hetal, a database administrator created a table Voters in which she has used nationality as column name and by mistake she has entered nationality as Gujarat. Now she wants to change all the values from Gujarati to Indians using single statement. Help her to do the following by writing statement.

(i)

What will be the query output for the following statement. Write in words/sentence.

(a) SELECT * from SCHOOL where sname like “_ _ _ SURAT”;

(b) SELECT * from SCHOOL where sname like “DC%”;

(a)

What is the difference between drop and delete table command?

(b)

What are different commands used in Transaction in MySql?

Please click the below link to access CBSE Class 12 Informatics Practices Worksheet - Revision (3)

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

CBSE Board Secretary says Class 10 and 12 CBSE Exam Pattern to be modified

The Central Board of Secondary Education is expected to introduce a few changes to the exam pattern for class 10 and board exams by 2023. Anurag Tripathi, secretary of CBSE speaking at an Assoham School Education Summit said that although this year class 10 students...

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...

How to crack a competitive examination

“How I crack a competitive examination” is a frequently asked question by today’s students. Cracking a competitive exam is a challenging task. Attaining a huge amount of study and solving several complex problems in a limited amount of time is a huge task. Competitive...

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...

NCERT NTSE Admit Card 2020 released - know more

Introduction: NTSE 2020 National Talent search examination is conducted by NCERT to take out the students who excel in science. It is organized to measure and let the students with talent outshine in their coming future. This talent search exam is taken in 2 stages....

JEE in Punjabi too after English, Hindi and Gujarati

Punjab Minister Tript Rajinder Singh Bajwa requested the joint technology entrance exam (main) to be conducted in Punjabi and other regional languages too. In his letter to Union HRD Minister Ramesh Pokhriyal Nishank, the Punjab Minister for Higher Education and...

×
Studies Today