12th Standard Syllabus & Materials

12th Standard

TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A

NEW

12th Standard

TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

12th Standard Computer Applications English Medium - Introduction to Database Management System 2 Mark Creative Question Paper and Answer Key 2022 - 2023

Published on: 05/09/2022

QB365 provides a detailed and simple solution for every Possible Creative Questions in Class 12 Computer Applications Subject - Introduction to Database Management System, English Medium. It will help Students to get more practice questions, Students can Practice these question papers in addition to score best marks.

Download Tamil Nadu 12th Standard Computer Applications question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.

Questions + Answers key

Take MCQ Computer Applications Test

QB365 Student Learing Managemnet System

Std: 12th Standard - Computer Applications

chapter: - Model Question paper

Visit QB365-SLMS - https://www.qb365.in/slms/ Complete Questions and Answers

Questions:

Generic 2

15 x 2 = 30

What is a record?

What is a table?

Write about Concurrency Control and Locking

What is Data Base Management system?

What is meant by the Designing of databases?

What is XAMPP?

What is the purpose of JOIN Clause?

Write the types of SQL commands

What do you mean by table in Relational database model?

10.

What are the features of RDBMS?

11.

Write the various forms of database.

12.

What are the limitations of database?

13.

What are the various methods to access file system?

14.

Define DBMS

15.

Define Database.

Visit QB365-SLMS - https://www.qb365.in/slms/

Answers Key:

Generic 2

15 x 2 = 30

1. A single entity in a table is called as Row (or) Record (or) Tuple.
2. The horizontal entity in a table is known as Record (or) row

1. Table is defined as the collection of data organized in terms of rows and columns.
2. Table is the simple representation of relations.

1. It is the DBMS mechanism used for data sharing.
2. When the same data is shared among multiple users, proper access control is needed and privilege of changing the applications is controlled through Locking.

1. DBMS is a system software for creating and managing databases.
2. It provides users and programmers with a systematic way to create, retrieve, update and manage data.

The process of creating, implementing and maintaining the enterprise data in a system is known as Designing of databases.

(i) XAMPP is a free and open source package.
(ii) It was developed by Apache.
(iii) It is a software platform for MySQL, PHP and Peri programming languages.

(i) When we have to select data from more than 2 tables SQL JOIN clause is used.
(ii) Retrieves data from two or more tables, by referendnq columns in the tables that hold identical values

(i) Data Definition Language (DDL)
(ii) Data Manipulation Language (DML)
(iii) Data Query Language (DQL)
(iv) Transaction Control Language (TCL)
(v) Data Control Language (DCL)

In relational database model,
(i) Table is defined as the collection of data organized in terms of rows and columns.
(ii) Table is the simple representation of relations. The true relations cannot have duplicate rows

10.

The features of RDBMS are
(i) High Availability
(ii) High Performance
(iii) Robust Transactions and support
(iv) Ease of management
(v) Less cost

11.

(i) Relational Database Management System (RDBMS)
(ii) And Object Database Management System (ODBMS).

12.

(i) Data Duplication
(ii) High Maintenance
(iii) Security

13.

(i) Indexed method
(ii) Random Method
(iii) Sequential Method

14.

Definition:
(i) A database management system (DBMS) is system software for creating and managing databases.
(ii) The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.

15.

(i) A database is a place where store, retrieve and manage data
(ii) It is a structured set of data held in a computer especially one that is in various ways.