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 Weekly Test - 4 ( Database Concepts )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Weekly Test - 4 ( Database Concepts )-Aug 2020

Time : 1.00 Hours

Part - A

Multiple Choice Question - Answer All Question

Who is called Father of Relational Database from the following?

Chris Date
Hugh Darween
Edgar Frank Codd
Edgar Frank Cadd

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

A way of combining two relations is._______

\(A \cup B\)
A x B
\(A \cap B\)
\(A \sigma B\)

Which of the following data model is mainly used in IBM main frame computers?

ER model
Hierarchical
Object
Relational

A________ is an attribute which uniquely identifies a particular tuple

relation key
row key
data key
tuple key

A relation key is a key which uniquely identifies a particular ______

columns
fields
tuples
none of these

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

Chen rule
E F Codd rule
Edgar rule
Edgar Frank rule

Which of the following is a simple abstraction of complex real world data gathering environment?

Data redundancy
Data consistency
Data abstraction
Data model

Hierarchical model represents a _______ relationship.

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

Choose the incorrect statement from the following

IBM developed Hierarchical data model
EF Codd proposed the Relational database model
Network model represents the data in many-to one relationships
Chen developed the ER model

The basic structure of data in relational model is

Tables
rows
columns
tuples

Expansion of SQL is

Structured Question Language
Selection Query Language
Structured Query Language
Structured Query Language

The symbol represents Unary relation operation PROJECT is

\(\cap \)
\(\cup\)
\(\sigma\)
\(\pi\)

Relational Algebra was first created by ______

E F Codd
Chen
Chris Date
Hugh Darwen

Choose the correct pair from the following

Table row= tuple
Table column = Relation
Table= Attribute
Table= record

The result of________ is a relation which includes all tuples that are in A but not in B.

\(A \cap B\)
\(A \cup B\)
A - B
A x B

Which of the following removes the duplicate rows in database?

SELECT
PROJECT
PRODUCT
INTERSECTION

In_______ where the data is organized as row and column

Database
DBMS
File or table
Procedure or methods

A table is known as

tuple
attribute
relation
entity

Which database model represents parent-child relationship?

Relational
Network
Hierarchical
Object

Which data model used in file management system?

ERmodel
Relational
Hierarchical
None of these

_________are also known as relations in a relational model

Table rows
Tables
Table columns
Tuples

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

Data model
Data implementation
Data redundancy
Data integrity

GIS expansion is

Geographic Information System
Global Information System
Global Information Source
Geographic Intelligent System

In which year Relational Database model was first purposed?

1960
1964
1974
1970

________ is formatted data

Raw facts
Database
Information
DBMS

Object model stores the data in the form of

objects
attributes and methods
classes and inheritance
all ofthese

Which of the following in a table represents a record?

Row
Column
File
Data

___ is the entire collection of related data

Square
Procedures
Table
Table or file

Who developed ER model?

Chen
EF Codd
Chend
Chand

Comment

Add Comment

Tamilnadu Stateboardszs - Class