Preparation for CBSE Standard XII for the Session 2020-21

 Python Questions for 1 Mark

SET 1
1. Python is a __________ programming language. Python is very easy to learn language as compared to other languages like C, C#, Javascript, Java, etc. 
2. Python is __________, this means that source code is also available to the public. So one can download it, use it as well as share it.
3. Python supports _________________ which includes the concepts of classes, objects, encapsulation, data hiding, abstraction, etc.
4. Python language is a ____________ which means if we have python code for windows and if we want to run this code on other platforms then we do not need to change it.
5. Python is an __________ language because Python code is executed line by line at a time. 
6. Python has a large standard library that provides a rich set of ________ and functions so you do not have to write your own code for every single thing. 
7. Python is a __________ language because we don't have to declare the type of variable while assigning a value to a variable.
8. Python has support for an __________ which allows interactive testing and debugging of snippets of code.
9. Python supports ___________ programming methods as well as Object Oriented Programming.
10. All Python program script files have to be written in a file with an extension ___________. 

Answer
1. high-level
2. open-source
3. object-oriented language
4. portable language
5. interpreted
6. module
7. dynamically typed
8. interactive mode
9. functional and structured
10. .py

SET 2

1. Python shell can be used in two ways __________ and ____________.

2. Python, in interactive mode, is good enough to learn, experiment, or explore, but we _________ the statements for further use and we have to retype all the statements to re-run them.

3. IDLE stands for ______________ 

4. While working in script mode, we add _________ statement in our program to see the results which are not required in interactive mode.

5. Every object has ______________, _____________ and ___________

6. ___________ of the object means it is the object's address in memory and does not change once it has been created.

7. It is a set of values, and the _______ decides the allowable operations on those values.

8. Numeric Types in python are _________ , ___________ , ________.

9. Number data type stores Numerical Values. This data type is ___________.

10. __________ in python is made up of two floating-point values, one each for the real and imaginary part.

Answer

1. interactive mode, script mode.

2. cannot save

3. integrated development environment

4. print

5. an identity, a type, a value

6. Identity 

7. data type 

8. int, float, complex

9. immutable

10. Complex number

SET 3

1. Three types of sequence data type available in Python are ___________, ____________ and ____________ .

2. String: is an ordered sequence of letters/characters. They are enclosed in ________________ and ____________.

3. It is possible to change one type of value/ variable to another type. It is known as ___________________ or ________________.

4. In ___________conversion, Python automatically converts lower data type to higher data type.

5. In ___________ Conversion, users convert the data type of an object to the required data type.

6. The predefined functions like int(), float(), str(), etc to perform ____________ conversion.

7. List is also a sequence of values of any type. Values in the list are called elements/items. These are __________ and indexed/ordered. 

8. __________ is enclosed in square brackets.

9. Tuples are a sequence of values of any type, and are indexed by integers. They are __________. Tuples are enclosed in ____________.

10. Set is an _____________ collection of values, of any type, with no duplicate entry. Sets are ____________.

Answer

1. Strings, Lists, Tuples

2. single quotes (' '), double quotes (" ")

3. type conversion, typecasting

4. Implicit type 

5. Explicit Type

6. explicit type

7. mutable

8. List 

9. immutable, round brackets

10. unordered, immutable

SET 4

1. ______________ comments are created simply by beginning a line with the hash (#) character, and they are automatically terminated by the end of the line. 

2. Python ____________ comment is a piece of text enclosed in a delimiter (""") on each end of the comment. 

3. _________________ are written with curly brackets, and have keys and values.

4. Dictionary items are ordered, changeable, and does ___________ duplicates.

5. ___________ is a collection which is ordered and changeable. Allows duplicate members.

6. __________ is a collection which is ordered and unchangeable. Allows duplicate members.

7. ___________ is a collection which is unordered and unindexed. No duplicate members.

8. _________ objects can change their state or contents and ____________ objects can't change their state or content.

9. One way to bind a name to an object is to use the _____________. For example, x=5 the following code binds the name x to the object 5.

10 ___________ are the words used by the Python interpreter to recognize the structure of the program. As these words have specific meanings for interpreters, they cannot be used for any other purpose.

Answer

1. Single-line

2. multi-line

3. Dictionaries

4. not allow

5. List

6. Tuple

7. Set

8. mutable, immutable

9. assignment operator (=)

10. Keywords

SET 5

1. ___________________ are used to perform mathematical operations like addition, subtraction, multiplication,division, modulus, floor division, exponent.

2. ____________ are used to compare values. It returns either True or False according to the condition.

3. ____________  are the and, or, not operators. 

4. ___________ act on operands as if they were strings of binary digits. They operate bit by bit.

5. ______________________ are used in Python to assign values to variables.

6. is and is not are the ____________________ in Python. They are used to check if two values (or variables) are located on the same part of the memory. 

7. in and not in are the _____________________ in Python. They are used to test whether a value or variable is found in a sequence (string, list, tuple, set and dictionary).

8. An ____________ is a combination of values, variables, operators, and calls to functions.

9. Python has well-defined rules for specifying the order in which the operators in an expression are evaluated when the expression has several operators. This is known as ______________________________.

10. Multiplication and division have a _________________ than addition and subtraction. Precedence rules can be overridden by explicit parentheses.

Answer

1. Arithmetic operators

2. Comparison operators / Relational operators

3. Logical operators

4. Bitwise operators

5. Assignment operators

6. identity operators

7. membership operators

8. expression

9. precedence of operators

10. higher precedence

SET 6

1. In left associative, the operator falling on __________ will be evaluated first, while in _____________________ operator falling on right will be evaluated first. 

2. If any one of the operands is true, then the condition becomes true. Which logical operator is this?

3. If both the operands are true, then the condition becomes true. Which logical operator is this?

4. In python Assignment operator "="  and Exponent operator "**" are ____________ Associative. 

5. Expression can be combined together to form large expressions but no matter how big the expression is, it always evaluates into a ___________ value. 

6. A Python ____________ is a unit of code that the Python interpreter can execute. 

7. Compound statements typically span multiple lines and start with a ____________ ending in a colon, which identifies the type of statement.

8. The __________ method reads a line from input, converts into a string, and returns it.

9. id() function returns the ____________ of the object. This is an integer that is unique for the given object and remains constant during its lifetime.

10. The __________ data type allows only True/False values

Answer

1. left side, right-associative

2. OR 

3. AND

4. Right

5. single

6. statement

7. one-line header

8. input()

9. identity

10. bool

SET 7

1. A python ______________ can be defined as a python program file which contains a python code including python functions, class, or variables. 

2. To make use of the functions in a module, one needs to import the module with an __________ statement.

3. A module is simply a ____________ with a ".py" extension that can be imported inside another Python program. 

4. The ____________ function returns the ceiling value which is the smallest value, greater or equal to the number x.

5. The ____________ returns the absolute value of x.

6. The ____________ returns factorial of x 

7. The ____________ returns the floor value which is the largest integer, less or equal to the number x.

8. The ____________ returns the greatest common divisor of x and y.

9. The ____________ returns x to the power y value.

10. The ___________ returns the square root of x.

Answer

1. module

2. import

3. Python file

4. Ceil(x)

5. fabs(x)

6. factorial(x)

7. floor(x)

8. gcd(x,y)

9. pow(x,y)

10. sqrt(x)

SET 8

1. The ____________ returns the log of x, where base is 10.

2. The ___________ returns the sine of x in radians.

3. The ___________ returns the cosine of x in radians.

4. The ___________ returns the tangent of x in radians

5. The ___________ returns the the inverse of the sine, similarly we have acos, atan also.

6. The ___________ converts angle x from radian to degrees.

7. The ___________ converts angle x from degrees to radians.

8. All methods of math() function are used for __________________ type objects but not for complex numbers.

9. Pi return the value of _________.

10. NAN stands for ________________ and is defined as a substitute for declaring value which are numerical values that are missing.

Answer

1. log10(x)

2. sin(x)

3. cos(x)

4. tan(x)

5. asin(x)

6. degrees(x)

7. radians(x)

8. integer or float

9. pi which is equal to 3.141592

10. not a number

DBMS and SQL Questions for 1 Mark

SET  1

1. _____________is collection of interrelated data.

2. _____________is a software for creating and managing databases, helps in efficient retrieval, inserting and deleting of data

3. _____________ is required to keep a record of ticket booking, train's departure and arrival status, the status of seats available, etc.

4. ______________ is a condition created within a database or data storage technology in which the same piece of data is held in two separate places. 

5. Data redundancy can cause __________________, which can provide a company with unreliable and/or meaningless information.

6. _______________ is the overall accuracy, completeness, and consistency of data. 

7. _______________ is the practice of protecting digital information from unauthorized access, corruption, or theft throughout its entire lifecycle.

8. _____________ automatically takes care of backup and recovery, reduces application development and maintenance time.

9. In the context of databases, __________ means that you either a) Commit to the entirety of the transaction occurring or b) Have no transaction at all

10. _____________ means that integrity constraints must be maintained so that the database is consistent before and after the transaction. It refers to the correctness of a database.

Answer

1. Database

2. Data Base Management System

3. Database

4. Data redundancy

5. data inconsistency

6. Data integrity

7. Data security

8. Data Base Management System

9. atomicity

10. Consistency

SET 2

1. ____________ deals with consistency and completeness of data retrieved by queries unaffecting a user data by other user actions.

2. _____________ ensures that the result or effect of a committed transaction persists in case of a system failure.

3. _______________ is a set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps. 

4. ACID stands for _____________________ .

5. RDBMS stands for ____________________________.

6. SQL stands for _______________________________ .

7. In RDBMS a database is considered as a collection of___________. 

8. Collection of rows and columns are called as ___________

9. A single row entry in a table is called a _______________ or Record.

10. Column is a set of data values of a particular type, one value for each row of the database. A column can also be called an _______________.

Answer

1. Isolation 

2. Durability

3. ACID

4. atomicity, consistency, isolation, and durability

5. Relational Database Management System

6. Structured Query Language

7. interrelated data

8. table

9. Tuple

10. attribute

SET 3

1. Primary Key is a ______________ key which identify a record uniquely in table. A table can have only one primary key.

2. _____________ is also a unique key to identify a record uniquely in a table but a table can have multiple candidate keys.

3. The candidate key other than the primary key is called an ___________________.

4. A _________ is a key used to link two tables together. This is sometimes also called as a referencing key. 

5. A __________ is a column or a combination of columns whose values match a _______________ in a different table.

6. ____________ enforce limits to the data or type of data that can be inserted/updated/deleted from a table. 

7. The whole purpose of constraints is to maintain the ______________ during an insert/update/delete into a table. 

8. ____________ constraint makes sure that a column does not hold NULL value. 

9. UNIQUE Constraint enforces a column or set of columns to have __________ values. 

10. The _____________ constraint provides a default value to a column when there is no value provided while inserting a record into a table.

Answer

1. unique and non-null

2. Candidate key

3. alternate key

4. foreign key

5. foreign key, primary key

6. Constraints

7. data integrity

8. NOT NULL

9. unique

10. DEFAULT

SET 4

1. The ____________ constraint is used for specifying range of values for a particular column of a table. 

2. Primary key uniquely identifies each record in a table. It must have __________ and cannot contain __________ values.

3. __________statements or commands are used to define and modify the database structure of your tables or schema.

4. _________________statements or commands are used for managing data within tables.

5. _____________is used to control user access in a database. it is related to security issues. it is also dealing with the rights and permissions of the database access.

6. DDL commands in SQL are ______________ , ______________ , ________________ , _______________ .

7. DML commands in SQL are ______________ , ______________ , ________________ , _______________ .

8. The create table command defines each column of the table uniquely. Each column has minimum of three attributes ___________, ____________, ___________. 

9. To provide access or privileges on the database objects___________command is used.

10. To remove access rights or privileges on the database object____________command is used.

Answer

1. Check

2. unique values, null

3. DDL

4. DML

5. DCL

6. CREATE, ALTER, DROP, TRUNCATE

7. INSERT, UPDATE, DELETE, SELECT

8. Name, Data type, Size(column width).

9. GRANT

10. REVOKE

SET 5

1. The ____________ Command will destroy the table and all data which will be recorded in it.

2. The ___________ TABLE Command we can modify our exiting table by Adding New Columns, Dropping a Column, Modifying data type and size of the Column.

3. To insert records into a specified table of the database we have to use the ___________ clause. 

4.  ______________ Command is used to remove existing records from a specified table. You can use the ____________ clause with DELETE command to delete the selected rows.

5. The __________ statement is used to modify the existing records in a table.

6. In the UPDATE command if we omit the WHERE clause, ________records will be updated.

7. The ___________ keyword sorts the records in ascending order by default. To sort the records in descending order, use the ___________ keyword.

8. ___________ keyword is used in conjunction with the ___________ statement to eliminate all the duplicate records and fetching only unique records.

9. _____________ clause is used to specify a condition while fetching the data from a single table or from multiple tables. 

10. ______________ clause is used in collaboration with the SELECT statement to arrange identical data into groups.

Answer

1. DROP

2. ALTER

3. INSERT

4. DELETE, WHERE

5. UPDATE

6. ALL

7. ORDER BY, DESC

8. DISTINCT, SELECT

9. WHERE 

10.  GROUP BY