CBSE Class 12 Computer Science Sql Worksheet Set 01

 

Q. Create the table TEACHER given below:

I. Multiple choice Questions:

Question. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
a) Rows
b) Key
c) Attribute
d) Fields
Answer. B

Question. Which of the following is not a legal method for fetching records from database.
a) fetchone()
b) fetchtwo()
c) fetchall()
d) fetchmany()
Answer. B

Question. To run an sql query from within python you may use cursor.------------- method.
a) query()
b) execute()
c) commit()
d) final()
Answer. B

Question. A database …………..controls the connection to an actual database , established in program.
a) database object
b) connection object
c) fetch object
d) query object
Answer. B

Question. Which one of the following attribute can be taken as a primary key?
a) Name
b) Street
c) Id
d) Department
Answer. C

Question. DBMS stands for_____________
a) Data Base Management Software
b) Data Base Maintenance System
c) Data Basic Management System
d) Data Base management system
Answer. D

Question. In RDBMS, R stands for_________
a) Relational
b) Rotational
c) Rational
d) None of the above
Answer. A

Question. A relational database consists of a collection of ..............
a) Fields
b) Records
c) Keys
d) Tables
Answer. D

Question. A row in a database.
a) Field
b) Record
c) Key
d) Table
Answer. B

Question. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
a) Referencing
b)Referential
c)Primary
d)Specific
Answer. B

Question. Referential Integrity is a rule that ensures ____________ between records in related tables are valid.
a) Links
b) difference
c) relationship
d) similarity
Answer. C

Question. Mismatched redundant copies of data is known as data ............
a) Dependence
b) Inconsistency
c) Isolation
d) Redundancy
Answer. B

Question. Fill in the blanks:

1) ___________ helps in efficient retrieval, inserting and deleting of data.
2) ___________ is a software for creating and managing databases.
3) _________ means that data is accurate and consistent in the database.
4) ______________- ensure that the database properly changes states upon a successfully committed transaction.
5) RDBMS stands for __________.
6) In RDBMS a database is considered as a collection of ___________
7) Collection of rows and columns are called as ______________
8) Record is also called as a ____________
9) The group of one or more columns used to uniquely identify each row of a relation is called________
10) __________ is data about data.
11) A _________ is a request to a database for obtaining information in a desired way.
12) ___________ is collection of values from which the value is derived for a column.
13) _______ are the columns of a table that points to the primary key of another table.
Answer. 
1 Database
2 DBMS
3 Data integrity
4 Consistency
5 Relational Database Management System
6 Interrelated data
7 Table
8 Tuple
9 Primary key
10 Meta – data
11 Query
12 Domain
13 Foreign key

Very Short Answer Questions:

Question. What is meant by a database?
Answer. A database is an organized collection of structured information, or inter-related data, typically stored in a computer system.

Question. What is meant by database schema?
Answer. Database schema is also called the visual or logical architecture as it tells us how the data are organized in a database.

Question. What is meant by data constraint?
Answer. Restrictions or limitations are put on the type of data that can be inserted in one or more columns of a table to ensure accuracy and reliability of data in the database.

Question. What is meant by relation?
Answer. A relation is a named, two dimensional table storing logically related data.

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