GATE Database Concepts Questions Pdf - 1

Question: 1

How many types of relationships are there?

(A) 1

(B) 2

(C) 3

(D) 4

Ans: D

4

Question: 2

Which database model represents parent-child relationship?

(A) Hierarchical

(B) Object

(C) Relational

(D) Network

Ans: A

Hierarchical

Question: 3

______ makes the data more meaningful and connected in the database?

(A) Relationship

(B) Data models

(C) DBMS

(D) Ingress

Ans: A

Relationship

Question: 4

How many different types of data models are there?

(A) 2

(B) 3

(C) 4

(D) 5

Ans: D

5

Question: 5

ER Model was developed in the year

(A) 1972

(B) 1976

(C) 1978

(D) 1980

Ans: B

1976

Question: 6

______ is one who manages the complete database management system.

(A) DBA

(B) Service Person

(C) Manager

(D) Engineer

Ans: A

DBA

Question: 7

_______ is the one who manages the complete database management system.

(A) Database Administrator

(B) Database Designer

(C) Data Analyst

(D) Database Architect

Ans: A

Database Administrator

Question: 8

What type of relationship does hierarchical model represents?

(A) One-to-one

(B) One-to-many

(C) Many-to-one

(D) Many-to-many

Ans: B

One-to-many

Question: 9

RDBMS means

(A) Relational Database Management system

(B) Rapid DataBase Management Server

(C) Relational Database Manipulation System

(D) Relational Data Manipulation System

Ans: A

Relational Database Management system

Question: 10

______ gives meaningful information.

(A) Information

(B) Data

(C) Row

(D) Tuple

Ans: A

Information