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 English Medium Computer Applications Subject Introduction to Database Management System BookBack 2 Mark Questions with Solution Part - I

Published on: 04/06/2021

QB365 provides detailed and simple solution for every book back questions in class 12 Computer Applications subject.It will helps to get more idea about question pattern in every book back questions with solution.

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: - Book back Questions

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

Questions:

Generic 2

5 x 2 = 10

What are the ACID properties?

List any two DDL and DML commands with its Syntax.

Define Single and Multi valued attributes.

List few disadvantages of file processing system.

Define Data Model and list the types of data model used.

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

Answers Key:

Generic 2

5 x 2 = 10

ACID Properties :
(i) The acronym stands for Atomicity, Consistency, Isolation and Durability.
(ii) Atomicity follows the thumb rule "All (or) Nothing" while updating the data in database for the user performing the update operation.
(iii) Consistency ensures that the changes in data value to be constant at any given instance. Isolation property is needed during concurrent transaction.
(iv) Durability is defined as the system is ability to recover all committed transactions during the failure of storage or the system

DDL Commands :
(i) CREATE :
Syntax : CREATE database database name;
(ii) DROP
Syntax : DROP database databasename;
DML Commands:
(i) INSERT
Syntax: INSERT INTO table name (column 1, column 2, column 3) VALUES (value 1, value 2, value 3);
(ii) UPDATE
Syntax: UPDATE tablename
SET column 1 = "new value"
Where column2="value2";

Single Valued Attribute: A single valued attribute contains only one value for the attribute and they don't have multiple numbers of values.
Multi Valued Attribute: A multi valued attribute has more than one value for that particular attribute.

i). Data Duplications : Same data is used be multiple resources for processing, thus created multiple copies of same data wasting the spaces.
ii). High Maintenance : Access control and verifying data consistency needs high maintenance cost.
iii). Security : Less security provided to the data.

Data models define how the logical structure a database is modeled. Data models define how data is connected to each other and how they are processed andstored inside the system
Types of Data Model :
1) Hierarchical database model
2) Network model
3) Relational model
4) object oriented database model