12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

Published on: 05/09/2022
QB365 provides a detailed and simple solution for every Possible Book Back 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

1.
State few advantages of Relational databases.
2.
What is Relationship and List its types.
3.
Write the difference between SQL and MySQL
4.
What is view in SQL?
5.
Which command is used to make permanent changes done by a transaction?
6.
7.
List any two DDL and DML commands with its Syntax.
8.
Define Single and Multi valued attributes.
9.
List few disadvantages of file processing system.
10.
Define Data Model and list the types of data model used.
1.
Advantages:
(i) High Availability
(ii) High Performance
(iii) Robust Transactions and Support
(iv) Ease of Management
(v) Less Cost
2.
In ER Model, relationship exits between two entities.
Types :
(i) one-to-one Relationship,
(ii) one-to-many Relationship,
(iii) many-to-many Relationship.
3.
| S.No | SQL | MySQL |
| 1. | SQL is a structured query language. | MySQL is a database software. |
| 2. | SQL is used to query and operate a database system. | MySQL allows data handling, storing, modifying, deleting etc. |
4.
(i) A set of stored queries is known as view in SQL.
(ii) A View contains rows and columns just like a real table.
5.
COMMIT Command is used to make permanent changes done by transaction.
6.
7.
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";
8.
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.
9.
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.
10.
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
12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications களப்பெயர் முறைமை (DNS) Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு எடுத்துக்காட்டுகள் மற்றும் நெறிமுறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications கணினி வலையமைப்பு ஓர் அறிமுகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications PHP-உடன் MySQL-ஐ இணைத்தல் Sample Question Papers Study Material - QB365 Set A
Tamilnadu Stateboard 12th Standard Subjects

Maths

Chemistry

Physics

Biology

Computer Science

Business Maths and Statistics

Economics

Commerce

Accountancy

History

Computer Applications

Biology

Computer Technology

Computer Applications

Computer Science

Business Maths and Statistics

Commerce

Economics

Maths

Chemistry

Physics

Computer Technology

History

Accountancy

Tamil

English

French
Tamilnadu Stateboard Standards