InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

12th Computer Science Monthly Test - 1 ( Database Concepts )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Monthly Test - 1 ( Database Concepts )-Aug 2020

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

Choose the incorrect statement from the following.
(i) Data redundancy not present in RDBMS
(ii) DBMS uses normalization to reduce redundancy
(iii) Distributed Database not supported by RDBMS
(iv) RDBMS uses keys and indexes to establish relationship.

i and ii
ii and iii
iii and iv
i and iv

The rule "reduce data redundancy and improve data integrity" is known as

Chen rule
E F Codd rule
Edgar rule
Edgar Frank rule

In which of the following data organized in a way that, it can be easily accessed, managed and updated?

Database
DBMS
Structure
Object

Which of the following is the most data model used for data base appreciation?

ER-Model
Hierarchical
Relational
table

Which of the following provided an interface to perform various operations to create a database, storing and updating data?

SQL
DBA
DBMS
Algebra

How many types of DBMS users are there?

2
3
4
5

Find the odd man out

SQLite
Maria DB
Oracle
Dbase

Which of the following in a table represents a record?

Row
Column
File
Data

Which of the following divides the data in such a way that repetition of data is minimum in the database?

Segregation
Normalisation
Integrity
Consistency

Hierarchical model represents a _______ relationship.

one to one
many to one
are to many
many to many

How the data can be represented and accessed from a software after complete implementation described by

Data model
Data implementation
Data redundancy
Data integrity

A tuple is also known as

table
row
attribute
field

In which year Relational Database model was first purposed?

1960
1964
1974
1970

Choose the correct pair from the following

Select- \(\cap\)
Product- \(\sigma\)
Project-\(\pi\)
Intersection-\(\cup\)

Who is called Father of Relational Database from the following?

Chris Date
Hugh Darween
Edgar Frank Codd
Edgar Frank Cadd

Part - B

Generic 2 - Answer All Question

List the types of RDBMS software.

What is E F Codd rules?

List the characteristics of DBMS.

What is normalization?
What is the difference between Hierarchical and Network data model?

Mention few examples of a database.

Π_course (STUDENT)

Differentiate data and information.

Write a note on
(i) SELECT Operation
(ii) PROJECT Operation

List some examples of RDBMS.

What is data consistency?

What is database?

Part - C

Generic 3 - Answer All Question

Write a note on database structure.

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 _____

Identity which is a DBMS and RDBMS software from the following.

(i) SQlite

(ii) Foxpro

(iii) MySQL

(iv) Dbase

Write a short note on the· database model, in which relationship are created by dividing the object into entity.

Write the symbol used for the following.
(i) SELECT (ii) PROJECT
(iii) Union (iv) Intersection
(v) Difference (vi) PRODUCT

Explain Cartesian Product with a suitable example.

Write the importance of using data model.

What does the term database refers?

List the types of DBMS users.

Write a note on different types of DBMS users.

What is Relational Algebra?

Part - D

Generic 5 - Answer All Question

Π_{studno, course} (STUDENT)

Explain the characteristics of DBMS.

Differentiate DBMS and RDBMS.

Explain the components of DBMS.

Explain the different types of relationship mapping.

Explain the different operators in Relational algebra with suitable examples.

Comment

Add Comment

Tamilnadu Stateboardszs - Class