CBSE Class 12 Computer Science Sql Worksheet Set B

Read and download free pdf of CBSE Class 12 Computer Science Sql Worksheet Set B. Download printable Computer Science Class 12 Worksheets in pdf format, CBSE Class 12 Computer Science Sql Worksheet has been prepared as per the latest syllabus and exam pattern issued by CBSE, NCERT and KVS. Also download free pdf Computer Science Class 12 Assignments and practice them daily to get better marks in tests and exams for Class 12. Free chapter wise worksheets with answers have been designed by Class 12 teachers as per latest examination pattern

Sql Computer Science Worksheet for Class 12

Class 12 Computer Science students should refer to the following printable worksheet in Pdf in Class 12. This test paper with questions and solutions for Class 12 Computer Science will be very useful for tests and exams and help you to score better marks

Class 12 Computer Science Sql Worksheet Pdf

 

STRUCTURED QUERY LANGUAGE (SQL)

 
Create the tables as given below:

CBSE Class 12 Computer Science Sql Worksheet Set B 1

Write the SQL commands for the following questions:

1. Create database in your name and create the tables EMPLOYEE and DEPT as given above.
2. To insert records into both the tables.
3. To display the structure of both the tables.
4. To modify the name field in the employee table with 25 characters.
5. To display all rows of both the tables.
6. To display the names of employees who are getting salary in the range 5000 – 10000(both included).
7. To display the details of all employees whose name starts with ‘P’.
8. To display name of those employees ending with ‘a’.

9. To display the names of those employees with exact 6 characters.
10. To display the details of all managers from the Employee table.
11. To change the salary of Bhawna to 40000.
12. To sort the records of employee table in the descending order of salary.
13. To display the names of all clerks and analysts from employee table.
14. To increase the salary of all employees by 10%.
15. To display the name, salary and bonus(salary+20% of salary).
16. To find the number of different jobs present in the table employee.
17. To delete the record of Col.Singvi from employee table.
18. To display the details of all the employees who are either managers or getting a salary less than 7000.
19. To display the details of all employees with doj > ‘1990-01-01’
20. To add a new column named Phone in the employee table and fill with values of your choice.
21. To show the minimum and maximum salary of the employees.
22. To show the sum and average salary of all clerks.
23. To display the job and total salary of employees for each job.
24. To create a view “Company” from employee table containing name, job and salary of employees who are getting salary more than 8000.
25. To change the salary of “Pallav” on the view as 5000. Display both the view and the base table.
26. To display name and deptno of all employees who do not earn a commission (comm field).
27. To find the name of the employee who is getting the maximum salary.
28. To find the name and salary of the employee getting minimum salary.
29. To delete all rows of the employee table and dept table.
30. To drop both employee and dept tables.

 
Interface Python with SQL database

I. Multiple choice Questions:

Question. A Database contains one or more_______
a) Data
b) Tables
c) Files
d) Links
Answer. B

Question. A ............ is an organized collection of structured data.
a) Database
b) File
c) DBMS
d) Information
Answer. A

Question. A data ................ is a set of rules that define valid data.
a) Query
b) Constraint
c) Dictionary
d) All of the above
Answer. B

Question. What is not true in respect of DBMS?
a) Database enforces standards
b) Database increases redundancy
c) Database facilitates sharing of data
d) Database helps to maintain integrity
Answer. B

Question. Cardinality is total ___________
a) number of rows in a table
b) number of columns in a table
c) number of data items in a table
d) none of the above
Answer. A

Question. To fetch one record from resultset you may use<curor>………… method.
a) fetch()
b) fetchone()
c) fetchtuple
d) none of these.
Answer. B

Question. To reflect the changes made in the database permanently you need to run……..
a) done()
b) reflect()
c) commit()
d) final
Answer. C

Question. Data about data is _________
a) Data redundancy
b) Meta Data
c) Database schema
d) None of the above
Answer. B

Question. Repetition of data is called ..............
a) Data redundancy
b) Data Description
c) Data inconsistency
d) None of the above
Answer. A

Question. Which of the following statements is not true about relational database?
a) Relational data model is the most widely used data model.
b) The data is arranged as a collection of tables in relational database.
c) Relational database increases data redundancy and inconsistency.
d) None of the above.
Answer. C

Question. The term ____________ is used to refer to a field in a table.
a) Attribute
b) Row
c) Tuple
d) Instance
Answer. A

Question. Which of the following is a disadvantage of file processing system?
a) Data redundancy
b) Data isolation
c) Data inconsistency
d) All of the above
Answer. D

Question. Degree refers to total_________
a) number of rows in a table
b) number of columns in a table
c) number of data items in a table
d) none of the above
Answer. B

Question. Answer the questions based on the table Employee. Table: Employee EMPID ENAME SALARY DEPTNO Email
1001   George    30000   10   George23@yahoo.co.in
1002   Mary      32000    12   Mary_123@yahoo.co.in
1003   Alwin     25000    12    Al_win@gmail.com
1004   Sumit    20000    11    Sumit_222@yahoo.co.in

Question. The cardinality of the table Employee is ……
i) 5
ii) 4
iii) 3
iv) 6
Answer. B

Question. The degree of the table Employee is …….
i) 3
ii) 4
iii) 5
iv) 6
Answer. C

Question. Which column can be made as the primary key in the table Employee?
i) EMPID
ii) EMAIL
iii) Both i and ii
iv) None of the above
Answer. C

Question. If two columns are added to the table Employee, then the cardinality and degree of the table is …… and …… respectively.
i) 4 , 7
ii) 7, 4
iii) 6,5
iv) 5,6
Answer. B

Question. State True/False: Both EMPID and EMAIL can be defined as primary key in the table Employee.
i) True
ii) False
Answer. B

Question. An attribute in a relation is a foreign key if it is the ________ key in any other relation.
a) Candidate
b) Primary
c) Super
d) Sub
Answer. B

Question. A(n) ________ in a table represents a logical relationship among a set of values.
a) Column
b) Key
c) Row
d) Attribute
Answer. C

Question. Which of the following attributes can be considered as a choice for the primary key?
a) Name
b) Street
c) RollNo
d) Subject
Answer. C


Question. Fill in the blanks

1.A ------------------ is a special control structure that facilitates the row by row processing of records in the resultset.
2.After importing mysqlconnector, first of all --------------is established by using connect()
3.-----------------method executes a database query from within Python.
4. Running of sql query through database cursor returns the table records in the form of---------------
5.A connectivity package---------------must be imported before running db connection program.
Answer. 1.database cursor  2.database connection.  3. execute()  4.resultset  5.mysql.connector


Very Short Answer Questions:

Question. What is primary key?
Answer. A primary key is a column or set of columns that contain values that uniquely identify each row in a table.

Question. What do you mean by candidate key?
Answer. It is an attribute or a set of attributes or keys participating for Primary Key, to uniquely identify each record in that table.

Question. What is meant by degree and cardinality of a table?
Answer. Degree refers to the number of attributes/columns in a relation. Cardinality refers to the number of tuples/rows in a relation

Question. What is meant by RDBMS?
Answer. RDBMS (relational database management system) is the software used to store, manage, query, and retrieve data stored in a relational database. The RDBMS provides an interface between users and applications and the database, as well as administrative functions for managing data storage, access and performance.

 

Please click on below link to download CBSE Class 12 Computer Science Sql Worksheet Set B

Practice Worksheets Class 12 Computer Science
CBSE Class 12 Computer Science All Chapters Worksheet
CBSE Class 12 Computer Science Arrays Worksheet
CBSE Class 12 Computer Science Binary Files Worksheet
CBSE Class 12 Computer Science Boolean Algebra Worksheet
CBSE Class 12 Computer Science C++ Worksheet Set A
CBSE Class 12 Computer Science C++ Worksheet Set B
CBSE Class 12 Computer Science Classes And Objects Worksheet
CBSE Class 12 Computer Science Communication Technology Worksheet
CBSE Class 12 Computer Science Computer Networks Worksheet Set A
CBSE Class 12 Computer Science Computer Networks Worksheet Set B
CBSE Class 12 Computer Science Computer Networks Worksheet Set C
CBSE Class 12 Computer Science Constructor And Destructor Worksheet Set A
CBSE Class 12 Computer Science Constructor And Destructor Worksheet Set A
CBSE Class 12 Computer Science Constructor And Destructor Worksheet Set B
CBSE Class 12 Computer Science Data Base Concept Worksheet
CBSE Class 12 Computer Science Data File Handling Worksheet
CBSE Class 12 Computer Science Data Management Worksheet Set A
CBSE Class 12 Computer Science Data Management Worksheet Set B
CBSE Class 12 Computer Science Data Management Worksheet Set C
CBSE Class 12 Computer Science Data Management Worksheet Set D
CBSE Class 12 Computer Science Data Management Worksheet Set E
CBSE Class 12 Computer Science File Handling Worksheet Set A
CBSE Class 12 Computer Science File Handling Worksheet Set B
CBSE Class 12 Computer Science File Handling Worksheet Set C
CBSE Class 12 Computer Science Function In Python Program Worksheet
CBSE Class 12 Computer Science Functions Worksheet Set A
CBSE Class 12 Computer Science Functions Worksheet Set B
CBSE Class 12 Computer Science Header Files Worksheet
CBSE Class 12 Computer Science Implementation of Queue Worksheet Set A
CBSE Class 12 Computer Science Implementation of Queue Worksheet Set B
CBSE Class 12 Computer Science Implementation of Stack Worksheet
CBSE Class 12 Computer Science Inheritance Worksheet Set A
CBSE Class 12 Computer Science Inheritance Worksheet Set B
CBSE Class 12 Computer Science Pointers Worksheet
CBSE Class 12 Computer Science Programming and Computational Thinking Worksheet Set A
CBSE Class 12 Computer Science Programming and Computational Thinking Worksheet Set B
CBSE Class 12 Computer Science Programming and Computational Thinking Worksheet Set C
CBSE Class 12 Computer Science Programming and Computational Thinking Worksheet Set D
CBSE Class 12 Computer Science Programming and Computational Thinking Worksheet Set E
CBSE Class 12 Computer Science Programming and Computational Thinking Worksheet Set F
CBSE Class 12 Computer Science Python Worksheet
CBSE Class 12 Computer Science Recursion Worksheet
CBSE Class 12 Computer Science Revision Worksheet
CBSE Class 12 Computer Science Society Law and Ethics Worksheet Set A
CBSE Class 12 Computer Science Society Law and Ethics Worksheet Set B
CBSE Class 12 Computer Science Society Law and Ethics Worksheet Set C
CBSE Class 12 Computer Science Society Law and Ethics Worksheet Set D
CBSE Class 12 Computer Science Society Law and Ethics Worksheet Set E
CBSE Class 12 Computer Science Sql Worksheet Set A
CBSE Class 12 Computer Science Sql Worksheet Set B
CBSE Class 12 Computer Science Using Python Libraries Worksheet
CBSE Class 12 Computer Science Worksheet Set A Solved
CBSE Class 12 Computer Science Worksheet Set B Solved
CBSE Class 12 Computer Science Worksheet Set C Solved
CBSE Class 12 Computer Science Worksheet Set D Solved
CBSE Class 12 Computer Science Worksheet Set E Solved
CBSE Class 12 Computer Science Worksheet Set F Solved

More Study Material

CBSE Class 12 Computer Science Sql Worksheet

The above practice worksheet for Sql has been designed as per the current syllabus for Class 12 Computer Science released by CBSE. Students studying in Class 12 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 12 Computer Science on a daily basis. All the latest practice worksheets with solutions have been developed for Computer Science by referring to the most important and regularly asked topics that the students should learn and practice to get better scores in their examinations. Studiestoday is the best portal for Printable Worksheets for Class 12 Computer Science students to get all the latest study material free of cost.

Worksheet for Computer Science CBSE Class 12 Sql

Teachers of studiestoday have referred to the NCERT book for Class 12 Computer Science to develop the Computer Science Class 12 worksheet. If you download the practice worksheet for the above chapter daily, you will get better scores in Class 12 exams this year as you will have stronger concepts. Daily questions practice of Computer Science printable worksheet and its study material will help students to have a stronger understanding of all concepts and also make them experts on all scoring topics. You can easily download and save all revision Worksheets for Class 12 Computer Science also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the practice sheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 12 Computer Science designed by our teachers

Sql worksheet Computer Science CBSE Class 12

All practice paper sheet given above for Class 12 Computer Science have been made as per the latest syllabus and books issued for the current academic year. The students of Class 12 can be assured that the answers have been also provided by our teachers for all test paper of Computer Science so that you are able to solve the problems and then compare your answers with the solutions provided by us. We have also provided a lot of MCQ questions for Class 12 Computer Science in the worksheet so that you can solve questions relating to all topics given in each chapter. All study material for Class 12 Computer Science students have been given on studiestoday.

Sql CBSE Class 12 Computer Science Worksheet

Regular printable worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Sql concepts. Practice worksheets play an important role in developing an understanding of Sql in CBSE Class 12. Students can download and save or print all the printable worksheets, assignments, and practice sheets of the above chapter in Class 12 Computer Science in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 12 Computer Science MCQ Test for the same chapter.

Worksheet for CBSE Computer Science Class 12 Sql

CBSE Class 12 Computer Science best textbooks have been used for writing the problems given in the above worksheet. If you have tests coming up then you should revise all concepts relating to Sql and then take out a print of the above practice sheet and attempt all problems. We have also provided a lot of other Worksheets for Class 12 Computer Science which you can use to further make yourself better in Computer Science

Where can I download latest CBSE Practice worksheets for Class 12 Computer Science Sql

You can download the CBSE Practice worksheets for Class 12 Computer Science Sql for the latest session from StudiesToday.com

Can I download the Practice worksheets of Class 12 Computer Science Sql in Pdf

Yes, you can click on the links above and download chapter-wise Practice worksheets in PDFs for Class 12 for Computer Science Sql

Are the Class 12 Computer Science Sql Practice worksheets available for the latest session

Yes, the Practice worksheets issued for Sql Class 12 Computer Science have been made available here for the latest academic session

How can I download the Sql Class 12 Computer Science Practice worksheets

You can easily access the links above and download the Class 12 Practice worksheets Computer Science for Sql

Is there any charge for the Practice worksheets for Class 12 Computer Science Sql

There is no charge for the Practice worksheets for Class 12 CBSE Computer Science Sql you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in Sql Class 12 Computer Science

Regular revision of practice worksheets given on studiestoday for Class 12 subject Computer Science Sql can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 12 Computer Science Sql

Yes, studiestoday.com provides all the latest Class 12 Computer Science Sql test practice sheets with answers based on the latest books for the current academic session

Can test sheet papers for Sql Class 12 Computer Science be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for Sql Class 12 Computer Science in mobile-friendly format and can be accessed on smartphones and tablets.

Are practice worksheets for Class 12 Computer Science Sql available in multiple languages

Yes, practice worksheets for Class 12 Computer Science Sql are available in multiple languages, including English, Hindi