Search Header Logo

DBMS 11-20

Authored by Vaishnavi Patil

Other

University

DBMS 11-20
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which one of the following uniquely identifies the elements in the relation?

Secondary Key

Alternate key

Foreign key

Primary key

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which are important properites to identify a candidate key of Entity set

Not Null and Unique

Minimal of Super key and No proper subset

Default and Check

Not Null and duplicate

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

______is an abstraction through which relationship are treated as higher level entity set.

Specilization

Inheritance

Aggregation

Generlization

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is _____________

Overlapping

Disjointness

Uniqueness

Relational

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Let E1 and E2 be two entities in an E-R diagram with simple single-valued attributes,R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many,R1 and R2 do not have any attributes of their own,What is the minimum number of tables required to represent this situation in the relational model.

2

4

3

5

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Consider the following relations student(id, name, address, gpa, sizeHS) campus(location, enrollment, rank) apply(id, location, date, major, decision) Identify the correct query to find name and address of all students with GPA > 3.7 and sizeHS < 1000

Πname, address(σGPA>3.7 ∧ sizeHS<1000(student))

σname, address(ΠGPA>3.7 ∧ sizeHS<1000(student))

Πname, address(σGPA>3.7 ∨ sizeHS<1000(student))

σname, address(ΠGPA>3.7 ∨ sizeHS<1000(student))

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Suppose T1 table contains 3 attribues and 5 tuples and T2 table contains 3 attributes and 4 tuples, then how many attributes and tuples will be there in resultant relation if take cartesian product between T1 and T2 (.e.(T1 X T2)

6 attributes and 5 tuples

3 attributes and 20 tuples

6 attributes and 20 tuples

6 attributes and 4 tuples

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?