Q1. What is database?
Answer: A database is an organized collection of data. The data are typically organized to model aspects of reality in a way that supports processes requiring this information. The term "database" can both refer to the data themselves or to the database management system.
Q1. To get the number of dimensions of a Series object, which attribute is used to display the value?
(a) index
(b) size
(c) itemsize
(d) ndim
Q2. To display last five rows of a series object ‘S’, you may write:
(a) S.Head()
(b) S.Tail(5)
(c) S.Head(5)
(d) S.tail()
Q1. SQL part-language that facilitates defining creation/ modification etc. of database objects such as tables, indexes, sequences etc. is called?
A. DML
B. DCL
C. DDL
D. None of these
Q1: Which python library is commonly used in data analytics?
(a) Django
(b) Flask
(c) Pandas
(d) Java
Q2: Pandas key data structure is called?
(a) Keyframe
(b) Dataframe
(c) DataTable
(d) HashTable
A scatter plot also called scatter chart uses dots to represent data points for two different numeric variables. The position of each dot on the horizontal and vertical axis represent an individual data point.
A scatter plot is commonly used to compare distribution of two variables and to find visually any correlation between them. If there are distinct clusters/segments within the data, it will be clear in the scatter plot.
Let us try to plot a few scatter graphs using matplotlib.
Q1: Define visualisation.
Answer: Data visualisation means graphical or pictorial representation of the data using graph, chart, maps etc.
Q2: Name any library that is used for data visualisation in Python.
Answer: matplotlib is a python library that provides various types of data visualisation interfaces.
Q3: How does visualisation help?
Answer: Visualisation also helps to effectively communicate information to intended users.
Q1 (MCQ): The now() function in MySql is an example of ?
a. Math function
b. Text function
c. Date Function
d. Aggregate Function
Q2: Write the output of the following SQL command.
select round(15.857,-1);
a. 15.8
b. 15.9
c. 15.0
d. 16
Q1: When a Series is created, are the data values mutable or not?
Answer: Yes data values can be modified and are mutable.
Q2: When a Series is created, can it be resized?
Answer: No. Its size Immutable.
Q3: Consider the following snippet
>>> import numpy as np
>>> import pandas as pd
>>> series1 = pd.Series(np.arange( 10, 20, 1 ))
(a) What will the be output the following statement.
>>> print(series1.head())
Q1: Name any three python libraries commonly used for scientific and analytical use.
Answer: NumPy, Pandas and Matplotlib
Q2: What does NumPy stand for?
Answer: It stands for ‘Numerical Python’. It is a library used for numerical data analysis and scientific computing.
Q3: What does PANDAS stand for?
Answer: Panel Data (PANelDAta).
Q4: What is use of Pandas tool?
Answer: It is a high-level data manipulation tool used for analysing data. It is very easy to import and export data using Pandas library which has a very rich set of functions.
Learning is a continual process. To improve scores, the best way is to learn and practice. Solving question papers help students to evaluate their knowledge and familarise with different types of question patterns being asked in the examination.
Eduvictors provides CBSE Previous Year Papers and Sample Question Papers for Class 12 Maths, Informatics Practices, Accountancy, English, Business Studies and Economics with/without solutions to help students in their board exam preparation.
1. Buy Informatics Practices with Python:Textbook for CBSE Class 12 (as per 2020-21 Syllabus)
Here attached the Informatics Practices Sample Question Paper (2020-2021) along with Marking Scheme (published by CBSE).
Class 10 - Information Technology
Class 11/Class 12 - Computer Science / Informatics Practices
Directions: Fill in the blanks with suitable words.
1 _______ is a collection of related information.
2 _______ are the basic building blocks of a database.
3 Table is also known as ________
4 In a table, columns are also called ________ and rows are called _________.
Eduvictors provides CBSE Previous Year Papers and Sample Question Papers for Class 12 Maths, Informatics Practices, Accountancy, English, Business Studies and Economics with/without solutions to help students in their board exam preparation.
1. Buy Informatics Practices with Python:Textbook for CBSE Class 12 (as per 2020-21 Syllabus)
Here attached the Informatics Practices Sample Question Paper (2020-2021) along with Marking Scheme (published by CBSE).
<HTML> // It identifies that the document is an HTML document.// Head tag makes the header for document.<HEAD> <TITLE> Page Title </TITLE> </HEAD>
//contains the title which appears in the title bar of the web browser <BODY> See Eduvictors.com for cbse notes </BODY>
// The content written in BODY tag appears in the windows.
//It contains many other tags.
</HTML>
