Computer Science - World Largest Latest MCQs collection website

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

July 16, 2021July 16, 2021 administrator

The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

Select

WellDone! Your Selected answer is Correct. Select is used to view the tuples of the relation with or without some constraints.

Projection

Union

Join

The _______operation performs a set union of two “similarly structured” tables

July 16, 2021July 16, 2021 administrator

The _______operation performs a set union of two “similarly structured” tables

Union

WellDone! Your Selected answer is Correct. Union just combines all the values of relations of same attributes.

Product

Intersect

None of the Options are Correct

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match

July 16, 2021July 16, 2021 administrator

The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match

Cartesian product

WellDone! Your Selected answer is Correct. Cartesian product is the multiplication of all the values in the attributes.

Intersection

Set difference

None of the Options are Correct

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

July 16, 2021July 16, 2021 administrator

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

Join

WellDone! Your Selected answer is Correct. Join finds the common tuple in the relations and combines it.

Union

Select

None of the Options are Correct

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

July 16, 2021July 16, 2021 administrator

The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

Join

WellDone! Your Selected answer is Correct. Join finds the common tuple in the relations and combines it.

Union

Select

None of the Options are Correct

Which one of the following is a procedural language?

July 16, 2021July 16, 2021 administrator

Which one of the following is a procedural language?

Relational algebra

WellDone! Your Selected answer is Correct. Domain and Tuple relational calculus are non-procedural language. Query language is a method through which database entries can be accessed.

Query language

Tuple relational calculus

Domain relational calculus

Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key?

July 16, 2021July 16, 2021 administrator

Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key?

WellDone! Your Selected answer is Correct. The attributes name, dept and tot_cred can have same values unlike ID

Name

Tot_cred

Dept

Which one of the following is a procedural language?

July 16, 2021July 16, 2021 administrator

Which one of the following is a procedural language?

Relational algebra

WellDone! Your Selected answer is Correct. Domain and Tuple relational calculus are non-procedural language. Query language is a method through which database entries can be accessed.

Query language

Tuple relational calculus

Domain relational calculus

The tuples of the relations can be of ________ order

July 16, 2021July 16, 2021 administrator

The tuples of the relations can be of ________ order

Any

WellDone! Your Selected answer is Correct. The values only count. The order of the tuples does not matter

Same

Constant

None of the Options are Correct

Using which language can a user request information from a database?

July 16, 2021July 16, 2021 administrator

Using which language can a user request information from a database?

Query

WellDone! Your Selected answer is Correct. Query language is a method through which the database entries can be accessed.

Relational

Structural

None of the Options are Correct

Page 164 of 174

« Previous 1 … 162 163 164 165 166 … 174 Next »