Databases-Query Languages (GATE Computer Science): Questions 14 - 19 of 19

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: 14

» Databases » Query Languages

MCQ▾

Question

________ is the time from when a read or write request is issued to when data transfer begins.

Choices

Choice (4) Response

a.

Access time

b.

seek time

c.

average seek time

d.

rotational latency time.

Question number: 15

» Databases » Query Languages

MCQ▾

Question

________ are the most elementary form of integrity constraint.

Choices

Choice (4) Response

a.

Domain constraints

b.

Integrity constraints

c.

Referential Integrity

d.

Integrity

Question number: 16

» 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: 17

» 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: 18

» 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

Question number: 19

» Databases » Query Languages

MCQ▾

Question

You can add a row using SQL in a database with which of the following?

Choices

Choice (4) Response

a.

INSERT

b.

CREATE

c.

ADD

d.

MAKE

Sign In