I. Choose the Correct Answer from the given four alternatives
8 × 1 = 8
1) What symbol is used for SELECT statement?
2) A table is known as
a) entity
b) relation
c) attribute
d) tuple
3) The constraint is used to assign a default value for the field
a) Default constraint
b) Check constraint
c) Primary key constraint
d) Unique constraint
4) The command to delete a table including the structure is
a) Alter Table
b) Delete Table
c) Drop
d) Delete
5) Which method will free up the resources that were tied with the file.
a) release()
b) delete()
c) close()
d) remove()
6) Which of the following mode is used when dealing with non-text files like images or exe files?
a) xls mode
b) csv mode
c) text mode
d) Binary mode
7) What does __ name __ contains?
a) main() name
b) c++ filename
c) os module name
d) python filename
8) A framework for interfacing Python and C++ is
a) Boost
b) Cython
c) SWIG
d) Ctypes
II. Answer any Four questions. Question No. 13 is Compulsory.
4 × 2 = 8
9) What is normalization?
10) Differentiate Unique and Primary key constraint.
11) Mention the two ways to read a CSV file using Python.
12) Differentiate compiler and interpreter.
13) How will you sort more than one column from a CSV file? Give an example.
III. Answer any Three questions. Question No. 17 is Compulsory
3 × 3 = 9
14) Write a note on different types of DBMS users.
15) What is constraint? Write short note on Primary Key Constraint.
16) What is the difference between the write mode and append mode.
17) What is MinGW? What is its use?
IV. Answer all the two questions.
2 × 5 = 10
18) a) Explain the different types of data model.
(OR)
b) What are the components of SQL? Write the commands in each.
19) a) Tabulate the different mode with its meaning.
(OR)
b) Write any five features of Python over C++
12th Std Study Materials
12th Study Materials
12th Tamil Study Materials
12th English Study Materials
12th French Study Materials
12th Maths Study Materials
12th Physics Study Materials
12th Chemistry Study Materials
12th Biology Study Materials
12th Botany Study Materials
12th Zoology Study Materials
12th Computer Science Study Materials
12th Accountancy Study Materials
12th Commerce Study Materials
12th Economics Study Materials
12th History Study Materials
12th Geography Study Materials
12th Statistics Study Materials
12th Business Maths Study Materials
12th Political Science Study Materials
12th Std Question Papers & Answer Keys
12th Quarterly Exam Question Papers and Answer Keys
12th Half Yearly Exam Question Papers and Answer Keys
12th Public Exam Question Papers and Answer Keys
12th First Revision Test Question Papers and Answer Keys
12th Second Revision Test Question Papers and Answer Keys
12th Third Revision Test Question Papers and Answer Keys
12th First Midterm Test Question Papers and Answer Keys
12th Second Midterm Test Question Papers and Answer Keys
12th Std Important Links
12th Syllabus
12th Lesson Plans
12th Monthly Test & Unit Test
Tamilnadu 12th Time Table | Plus Two Exam Time Table