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: 10/09/2022
QB365 provides a detailed and simple solution for every Possible Creative Questions in Class 12 Computer Science Subject - Database Concepts , 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 Science 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 Science Test

1.
Write the symbol used for the following.
(i) SELECT
(ii) PROJECT
(iii) Union
(iv) Intersection
(v) Difference
(vi) PRODUCT
2.
What is Relational Algebra?
3.
List the types of DBMS users.
4.
Write a short note on the database model, in which relationship are created by dividing the object into entity.
5.
Explain the data model that represent parent child relationship.
6.
Write a short note on Relational data model.
7.
List the types of data model.
8.
Write the importance of using data model.
9.
Identity which is a DBMS and RDBMS software from the following.
(i) SQlite
(ii) Foxpro
(iii) MySQL
(iv) Dbase
10.
Fill up the blank.
(I) A table is known as a _____________
(ii) A table row is known as a __________
(iii) A table column is known as a ________
11.
Write a note on database structure.
12.
List the components of DBMS
13.
Write the advantages of DBMS.
14.
Write a note on DBMS or write a note on a software that allows us to create, define and manipulate database.
15.
What does the term database refers?
1.
(i) σ
(ii) π
(iii) U
(iv) ∩
(v) -
(vi) X
2.
(i) Relational Algebra, was first created by Edgar F Codd while at IBM. It was used for modeling the data stored in relational databases and defining queries on it.
(ii) Relational Algebra is a procedural query language used to query the database tables using SQL.
(iii) Relational algebra operations are performed recursively on a relation (table) to yield an output. The output of these operations is a new relation, which might be formed by one or more input relations.
3.
(i) Database Administrators(DBA)
(ii) Application or software developers
(iii) End User
(iv) Database designers
4.
Entity Relationship Model (ER model):
(i) In this database mo-ad., relationship are created by dividing the object into entity and its characteristics into attributes.
(ii) It was developed by Chen in 1976. This model is useful in developing a conceptual design for the database.
(iii) It is very simple and easy to design logical view of data. The developer can easily understand the system by looking at ER model constructed.
5.
(i) Hierarchical model was developed by IBM as Information Management System.
(ii) In Hierarchical model, data is represented as a simple tree like structure form. This model represents a one-to-many relationship ie parent-child relationship.
(iii) One child can have only one parent but one parent can have many children. This model is mainly used in IBM Main Frame computers.
6.
(i) The Relational Database model was first proposed by E.P. Codd in 1970. It is the most widespread data model used for database applications around the world.
(ii) The basic structure of data in relational model is tables (relations). All the information's related to a particular type is stored in rows of that table.
(iii) Hence tables are also known as relations in a relational model. A relation key is an attribute which uniquely identifies a particular tuple (row in a relation (tabler).
7.
The different types of a Data Model
(i) Hierarchical Model
(ii) Relational Model
(iii) Network Database Model
(iv) Entity Relationship Model
(v) Object Model
8.
(i) A data model describes how the data can be represented and accessed from a software after complete implementation
(ii) It is a simple abstraction of complex real world data gathering environment.
(iii) The main purpose of data model is to give an idea as how the final system or software will look like after development is completed.
9.
(i) RDBMS
(ii) DBMS
(iii) RDBMS
(iv) DBMS
10.
(i) Relation
(ii) Tuple
(iii) Attribute
11.
(i) Table is the entire collection of related data in one table, referred to as a File or Table where the data is organized as row and column.
(ii) Each row in a table represents a record, which is a set of data for each database entry.
(iii) Each table column represents a Field, which groups each piece or item of data among the records into specific categories or types of data. Eg. StuNo., StuName, StuAge, StuClass, StuSec.,
A Table is known as a RELATIQN
A Row is known as a TUPLE
A column is known as an ATTRIBUTE
12.
The Database Management System can be divided into five major components as follows:
(i) Hardware
(ii) Software
(iii) Data
(iv) Procedures / Methods
(v) Database Access Languages
13.
Advantages of DBMS:
(i) Segregation of application program
(ii) Minimal data duplication or Data Redundancy
(iii) Easy retrieval of data using the Query Language
(iv) Reduced development time and maintenance
14.
(i) A DBMS is a soft ware that allows us to create, define and manipulate database, allowing users to store, process and analyze data easily.
(ii) DBMS provides us with an interface or a tool, to perform various operations to create a database, storing of data and for updating data, etc.
(iii) DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users.
15.
(i) A database is an organized collection of data, generally stored and accessed electronically from a computer system.
(ii) The term "database" is also used to refer to any of the DBMS, the database system or an application associated with the database
(iii) Because of the close relationship between them, the term "database" is often used casually to refer to both a database and the DBMS used to manipulate it.
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