Worksheet on Database Management Systems - Class 10 / Class 11/Class 12 - Information Technology /Computer Science / Informatics Practices

Worksheet on Database Management Systems

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 _________.

Class 12 Informatics Practices CBSE Sample Question Paper with Marking Scheme 2020-21 (#class12SamplePapers)(#InformaticsPractices)(#eduvictors)

Class 12 Informatics Practices CBSE Sample Question Paper with Marking Scheme 2020-21

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)  

2. Buy Oswaal CBSE Question Bank Class 12 Informatics Practice Chapterwise & Topicwise Solved Papers (Reduced Syllabus) (For 2021 Exam)

Here attached the Informatics Practices Sample Question Paper (2020-2021) along with Marking Scheme (published by CBSE). 

CBSE Class 12 - Computer Science/Informatics Practices - Python - A Quick Revision (#eduvictors)(#Class12ComputerScience)(#Class12InformaticsPractices)

Python - A Quick Revision

CBSE Class 12 - Computer Science / Informatics Practices

Q1: What is python?

Answer: Python is an object-oriented high-level computer language developed by Guido Van Rossum in 1990s. It was named after a British TV show namely ‘Monty Python’s Flying circus’.


Q2: What are the major advantages of Python language?

Answer: Python is a very powerful interpreted language (executes the code line by line at a time).
Some advantages of python are:
    Easy to use
    Expressive language
    Cross-platform
    Free and open sources

CBSE Class 12 - Informatics Practices - Introduction to XML (Questions and Answers)(#cbsenotes)(#class12notes)(#eduvictors)

Introduction to XML 

Class 12 - Informatics Practices

(Questions and Answers)

Q1: What is XML? How it is different from HTML?

Answer: XML is short for Extensible Markup Language, which describes a document. It is a text-based markup language that allows storing data in a structured format. It is also a type of metalanguage.

XML is a markup language like HTML. But XML is different from HTML in the sense that HTML describes how to display and format the data text and images in the browser whereas XML is used to describe the data.

To store self-describing data, XML allows us to create our own tags.

Q2: Is XML structured language or unstructured?

Answer: Structured language


Q3: What is a meta-language?

CBSE Class 12 - Informatics Practices Sample Question Paper + Solution- (2018-19)(#cbsenotes)(#eduvictors)

CBSE Class 12 - Informatics Practices
 Sample Question Paper + Solution- (2018-19)

Learning Objectives of Informatics Practices are: 

1. To understand the application development environment. 

2. To gain programming Skills in GUI Programming Tool and Database Creation in RDBMS. 

3. To design, program and develop a database application using GUI Programming Tool and RDBMS. 4. To learn database connectivity using Visual Basic as Front-end tool. 

5. To develop the ability to use Open Source Technology. 

Competencies: 

1. The student will become familiar with Application Development 

2. The student will be able to develop & debug programs Independently. 

3. The student can use SQL for storing and retrieving data from the RDBMS. 

4. Ability to arrive at a normalized design of tables and other database objects in RDBMS. 

5. The student will be able to develop a Client Server Application using Front end and Back end tools.

Here follows the class 12  Informatics Practices sample question paper along with marking scheme and answers help you in studies.

Class 12 - Informatics Practices - HTML Basics - 1 Mark Based Question Answers (#cbsenotes)(#eduvictors)

Informatics Practices - HTML Basics

1 Mark Based Question Answers

Q1. HTML tags must be written within_____________.

Answer: HTML tags must be written within angular <> bracket e.g. <font>


Q2. What is the correct structure of the HTML document?

Answer:

<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>

CBSE Class 12 - Computer Science - SQL Commands and Functions - Summary(#cbsenotes)(#eduvictors)

SQL Commands and Functions 

Summary

SQL (Structured Query Language) is a standardized language used to create, maintain, modify, and query relational databases. When a user wants to get some information from a database file, he can issue a SQL query.

Types of SQL commands OR Processing capabilities of SQL:
① Data Definition Language Commands (DDL Commands)
② Data Manipulation Language Command (DML Commands)
③ Transaction Control Language Command (TCL commands)
④ Data Control Language (DCL Commands)


DDL Commands
All the commands used to create, modify or delete physical structure of an object like a table. e.g., Create, Alter, Drop.

DML Commands
DML contains commands that can be used to manipulate the database objects and to query the databases for information retrieval.
e.g Select, Insert, Delete, Update etc.

TCL commands
TCL include commands to control the transactions in a database system. The commonly used commands in TCL are COMMIT, ROLLBACK etc.

Data Control Language (DCL)
This language is used for controlling the access to the data. Various commands like GRANT, REVOKE etc are available in DCL.

Class 10 - Foundation of Information Technology - Chapter 01 - Internet Basics - Very Short Questions and Answers (#cbsenotes)(#eduvictors)

Internet Basics

Very Short Questions and Answers

Class 10 - Foundation of Information Technology

Question 1: Why is the Internet is so popular? 

Answer: Due to its extensible use and sharing of data, the Internet becomes so popular.


Question 2: Mention any two major uses of the Internet. 

Answer: The two major uses of the Internet are as follows:

1. For the students and educational purposes, the Internet is widely used to gather information so as to do the research.

2. We can send/receive the mail all over the world.


Question 3: Write two advantages of using the Internet.

Answer: Advantages of using the Internet are as follows:

1. It is used for communication, entertainment, searching for information and for providing many types of services.

2. It provides the facility of E-mail.

Entrance Exam/BCA/BBA/Class 11/Class 12 - Computer Awareness Quizzes (#eduvictors)(#cbsenotes)(#bcaentrance)

Computer Awareness Quizzes

Computer Awareness MCQs are available at eduvictors.com that may help you prepare for BCA/BBA entrance tests and Computer Science related examinations.

CBSE Class 12 - Final Examination Date Sheet - (2017-18) (#eduvictors)(#cbsenotes)

CBSE Class 12 - Final Examination Date Sheet - (2017-18)

CBSE Class 12 - Informatics Practices - Sample Question Paper - (2017-18) (#cbsepapers)(#eduvictors)

CBSE Class 12 - Informatics Practices -
Sample Question Paper - (2017-18)

CBSE Class 12 - Informatics Practices - Chapter - IT Applications (Q & A) (#cbseNotes) (#eduvictors)

IT Applications (Q & A)

Class 12 - Informatics Practices

Q1: What is the use of 'Front end'?

Answer: The front end application interacts with the user and collects input from the user. For example: E-mail sign up form or any application where a user enters data.


Q2: What is the use of 'Back end' application?

Answer: The backend is an application or program that is not visible to the user but that processes the user requests as received from the front end. The back end handles all database accesses through one or more servers. For Example: MYSQL, Oracle, MS-Access etc.

CBSE Class 12 - Informatics Practices - Worksheet (#cbseNotes) (#eduvictors)

Informatics Practices - Worksheet

Fill in the blanks


1. A___________ is a Logical Unit of Work (LUW) on the database that must succeed or fail entirely.


2. Transaction is an atomic unit, it must be executed independently, no any other transaction should interfere during the execution of a transaction to avoid conflicts. It is known as ______ of database.


3. Transaction SQL command __________, cancels the effect of a transaction and restores the previous state of the database



4. Each time when record is inserted or updated in the table, the other table is referenced. This constraints is also called __________ ___________ Constraints.

Class 12 - Informatics Practices - Java Concepts (Worksheet- 2) (#cbseNotes)

JAVA Concepts (Worksheet-2)

Q1: See the following Java code. Identify
(i) Superclass
(ii) Subclass
(iii) Can student class modify the value of birthyear? Why or Why not?
(iv)    Can student class modyfy the value of age? Why or Why not?

class human
{ 
private int birthyear;
String name;
int age;
void method1()
{...}
}

class student extends human
{
int rollno;
...
void method2()
{...}
}

CBSE Class 12 - Informatics Practices - JAVA Concepts (Worksheet) (#cbseNotes)

JAVA Concepts (Worksheet)

Q1: What will be the value of X1 after execution of the following code?

String X1 ="Graduate", X2 = "Post";
X1 = X2.contcat(X1);


Q2: What is the difference between the use of JTextField and JPasswordField in a form?

Q3: Name the method used to extract specified number of characters from a string?

CBSE Class 12 - Informatics Practices - Java Object Oriented Programming-2 - Inheritance (#cbseNotes)

Java - InheritanceClass 12 - Informatics Practices

Q1: What do you mean by the term 'inheritance'?

Answer: In OOPs, Inheritance is the process of creating new class (Derived Class or sub-classes) from an existing class (Base Class or Super class). A Sub-class inherits all the properties (data members) and behaviour (method members) of the parent class (Super-class).

The level of Inheritance may be extended i.e. A Sub-class may have their own sub-classes.

In Real-life most of the things exhibit Inheritance relationship.


Q2: What is the importance of 'inheriatnce'?

Answer: Inheritance is important for the following reasons:
① Modelling of Real-world
② Reusability of codes
③ Transitive nature of Inheritance

CBSE Class 12/ 11 - Informatics Practices - Java Practical Snippet-1 - Leap Year Testing (#cbseNotes)

Java Practical Snippet-1
Leap Year Testing  

Question: Input a year and check if the year is leap year or not.

Answer:

CBSE Class 12 - Informatics Practices- Java – Object Oriented Programming (Question and Answers) (#cbseNotes)

Java – Object Oriented Programming (Question and Answers)

Q1:  What is computer programming?

Answer: Computer Programming is a process of designing, writing, testing, debugging and maintaining the source code written in a programming language to solve a real life problem.


Q2: What does it require to write a source code in programming process?

Answer: The process of writing source code of programs requires expertise in subject, knowledge of desired application domain, a formal logic and knowledge of syntax of the relevant programming language.


Q3: What are the two main approaches (methodologies) of programming?

Answer:
1. Procedural Programming
2. Object Oriented programming.


Q4: What is procedural programming? Give examples of programming languages that support procedural programming.

Answer: In this approach or procedural programming, a programming task is broken into smaller and easily manageable modules (procedures). The stress is given to functionalities rather than data.

Basic, COBOL, Pascal and C Languages supports Procedural Programming approach.

CBSE Class 12 - Informatics Practices - Java GUI Programming – Tour III (Q and A) (#cbseNotes)

Java GUI Programming – Tour III (Q and A)JOptionPane : Built-In Dialog of JAVA

JOptionPane allows to create pop-up window or dialog with predefined style.

It provides following types of Dialogs which can be used as per requirement.


① Dialog Type: MessageDialog
Method used: showMessageDialog();
It is used to inform user by displaying a message. It includes OK button only.


② Input Dialog
Method: showInputDialog();
Used to get user input using Text Field.

③ Confirm Dialog
Method: showConfirmDialog();
Used to ask a user to confirm some information with Yes/No or OK/Cancel buttons.

CBSE Class 12 - Informatics Practices - Java GUI Programming - Revision Tour-2 (Q & A)

Java GUI Programming - Revision Tour-2
(Q & A)

Questions and Answers

Q: What is Netbeans? Write about its three important features.

Answer: Netbeans is an open source, Integrated Development Environment (IDE) tool for developing Java applications. 

1. Its a RAD (rapid application development) tool that allows us to develop applications by dragging and positioning GUI components from a palette onto a container.

2. Its GUI builder automatically takes care of the correct spacing and alignment of the different components relative to each other.

3. It has in built support for Java Compiler, interpreter and debugger.

4. It has in built text editor with syntax highlighting.