Who developed ER model?

(a)

Chen

(b)

EF Codd

(c)

Chend

(d)

Chand

Which of the following is an organized collection of data?

(a)

Word Processor

(b)

Spreadsheet

(c)

Programming language

(d)

Database

Which of the following is an organized collection of data, which can be stared and a cersed through computer system

(a)

Database

(b)

Worksheet

(c)

DBMS

(d)

Information

Which of the following allows users to store, process and analyze data easily?

(a)

My SQL

(b)

Relational Algebra

(c)

Datamodels

(d)

DBMS

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

(a)

SQL

(b)

DBA

(c)

DBMS

(d)

Algebra

Which of the following is not an example of DBMS?

(a)

Foxpro

(b)

Dbase

(c)

CoBoL

(d)

Ms-Access

Which of the following makes the data more meaningful and connected in the database?

(a)

Information

(b)

Security

(c)

Relationship

(d)

Data models

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

(a)

Segregation

(b)

Normalisation

(c)

Integrity

(d)

Consistency

Which of the following DBMS components that manage databases to take backups, report generation?

(a)

Square

(b)

Hardware

(c)

Data

(d)

Procedures

Which of the following used to write commands to update and delete data stored in database?

(a)

Procedures

(b)

Methods

(c)

Database Access language

(d)

Hardware/software

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

(a)

Data redundancy

(b)

Data consistency

(c)

Data abstraction

(d)

Data model

The basic structure of data in relational model is

(a)

Tables

(b)

rows

(c)

columns

(d)

tuples

Who manages the complete database management system?

(a)

End user

(b)

DBA

(c)

DB designer

(d)

software developer

Who are the one responsible for identifying the data to be stored in the data base?

(a)

DBA

(b)

Application programmers

(c)

End user

(d)

Database designers

How many types of relationships used in a database?

(a)

3

(b)

5

(c)

2

(d)

4

Mention few examples of a database.

List some examples of RDBMS.

What is data consistency?

What is the difference between Hierarchical and Network data model?

What is normalization?

What is database?

Differentiate data and information.

List the characteristics of DBMS.

List the types of RDBMS software.

What is E F Codd rules?

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

What is the difference between Select and Project command?

What is the role of DBA?

Explain Cartesian Product with a suitable example.

Explain Object Model with example.

Write a note on different types of DBMS users.

What does the term database refers?

Write a note on DBMS or write a note on a software that allows us to create, define and manipulate database.

Write the advantages of DBMS.

List the components of DBMS

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 ________

Explain the different types of data model.

Explain the different types of relationship mapping.

Differentiate DBMS and RDBMS.

Explain the different operators in Relational algebra with suitable examples.

Explain the characteristics of DBMS.

Explain the components of DBMS.