Databases (GATE Computer Science): Questions 144 - 150 of 154

Get 1 year subscription: Access detailed explanations (illustrated with images and videos) to 913 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. View Sample Explanation or View Features.

Rs. 450.00 or

Question number: 144

» Databases » Query Languages

MCQ▾

Question

The primary key is selected from the:

Choices

Choice (4) Response

a.

Candidate keys.

b.

Forgien Key

c.

composite keys.

d.

Determinants.

Question number: 145

» Databases » Database Design

MCQ▾

Question

The “DBMS” acts as an interface between what two components of an enterprise-class database system?

Choices

Choice (4) Response

a.

Data and Database

b.

Database application and the database

c.

The user and database application

d.

Database application and SQL

Question number: 146

» Databases » Query Languages

MCQ▾

Question

In a relational database, ________ is a data structure that organizes the information about a single topic into rows and columns.

Choices

Choice (4) Response

a.

Block

b.

Tuple

c.

Table

d.

None of the above

Question number: 147

» Databases » Relational Model

MCQ▾

Question

The distinguishable parts of a record are called

Choices

Choice (4) Response

a.

Dada

b.

files

c.

Field

d.

None of the above

Question number: 148

» Databases » ER-Model

MCQ▾

Question

Which is the central component of the DBMS software that can also be termed as the database control system:

Choices

Choice (4) Response

a.

Data manager

b.

Data Consistency?

c.

Data sharing

d.

Data integration

Question number: 149

» Databases » ER-Model

MCQ▾

Question

elimination of data redundancy?

Choices

Choice (4) Response

a.

elimination of data redundancy?

b.

Ability to associate related data

c.

Increased security

d.

All a. , b. and c. are correct

Question number: 150

» Databases » Query Languages

MCQ▾

Question

A functional dependency is a relationship between or among:

Choices

Choice (4) Response

a.

tables

b.

Relations

c.

Rows

d.

Attribute

Sign In