Databases (GATE (Graduate Aptitude Test in Engineering) Computer Science): Questions 129 - 136 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: 129

» Databases » Relational Model

MCQ▾

Question

The ________is a proposed standard for creating specifications of various components of a software system.

Choices

Choice (4) Response

a.

set

b.

UML

c.

aggregation

d.

Entity set

Question number: 130

» Databases » Relational Model

MCQ▾

Question

The relational algebra is a ________ language.

Choices

Choice (4) Response

a.

procedural language,

b.

nonprocedural language

c.

SQL

d.

Both a. and b. are correct

Question number: 131

» Databases » Relational Model

MCQ▾

Question

The basic structure of an SQL expression consists of how many clauses?

Choices

Choice (4) Response

a.

whrere

b.

select

c.

from

d.

All a. , b. and c. are correct

Question number: 132

» Databases » Relational Model

MCQ▾

Question

The ________ operation, denoted by a cross (),

Choices

Choice (4) Response

a.

Cartesian-product

b.

relation

c.

Entity set

d.

Question does not provide sufficient data or is vague

Question number: 133

» Databases » Relational Model

MCQ▾

Question

________ proceeds from the recognition that a number of entities set share some common features.

Choices

Choice (4) Response

a.

Specification

b.

Generalization

c.

Entity

d.

Entity set

Question number: 134

» Databases » Database Design

MCQ▾

Question

The space in a table space is divided into units that is called ________

Choices

Choice (4) Response

a.

schema

b.

segments

c.

transaction

d.

All of the above

Question number: 135

» Databases » Database Design

MCQ▾

Question

The time for repositioning the arm is called ________.

Choices

Choice (4) Response

a.

rotational latency time

b.

seek time

c.

Access time

d.

average seek time

Question number: 136

» Databases » Database Design

MCQ▾

Question

The most popular forms of ________ are the compact disk (CD),

Choices

Choice (4) Response

a.

Flash memory

b.

cache

c.

optical storage

d.

main memory

f Page
Sign In