Which of the following is an example of a strong entity?

A department that depends on an employee

A weak entity set depends on a strong entity set because:

It cannot exist without the associated strong entity

It is stored separately from the strong entity

Which of the following is the correct process for converting an ER diagram to a relational schema?

Convert entities to tables, attributes to columns, and relationships to foreign keys

Convert attributes to rows, relationships to columns, and entities to keys

Convert tables to entities and columns to attributes

Convert relationships to primary keys and attributes to tables

A many-to-many relationship in an ER diagram is typically implemented in a relational schema using:

A junction (bridge) table with foreign keys from both related tables

A foreign key in one of the tables

A composite primary key in one of the tables

Generalization in database design involves:

Combining several lower-level entities into a higher-level entity

Dividing a higher-level entity into several lower-level entities

Aggregating data from multiple tables into one

Creating relationships between unrelated entities

What does the projection operation (π) do in relational algebra?

Selects specific columns (attributes) from a relation.

Removes duplicate rows from a relation.

Selects specific rows that satisfy a given condition.

Combines two relations into one.

The intersection operation in relational algebra:

Selects tuples that are present in both relations.

Combines two relations and includes all tuples from both.

Selects tuples that are present in only one of the relations.

Selects tuples from the first relation but not from the second.

What is the result of the intersection operation in relational algebra?

Tuples present in both relations.

All tuples from both relations.

Tuples present only in the first relation.

Tuples present only in the second relation.

In a union operation, which of the following is true?

All tuples from both relations are included, with no duplicates.

Tuples from only one relation are included.

Tuples from both relations are included, but only if they exist in both.

All tuples from both relations are included, with duplicates allowed.

The cross product (Cartesian product) in relational algebra:

Combines every tuple from one relation with every tuple from another.

Combines tuples only if they satisfy a given condition.

Combines tuples that are present in both relations.

Removes duplicate tuples from two relations.

The set difference operation in relational algebra:

Selects tuples that are present in the first relation but not in the second.

Selects tuples that are present in both relations.

Combines all tuples from both relations.

Combines tuples based on a join condition.

In relational algebra, if R1 − R2 is performed, the result is:

Tuples present in R1 but not in R2.

Tuples present in both R1 and R2.

Tuples present in R2 but not in R1.

All tuples from both R1 and R2.

Database Concepts MCQ- 4

Authored by Pawan Kumar

English

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Data is best described as:

Organized facts

Raw facts and figures

Processed information

A set of reports

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In the database approach, data can be shared among multiple users. This is called:

Data isolation

Data redundancy

Data sharing

Data independence

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In which phase of the database system life cycle is the ER diagram created?

Database Design

Database Implementation

Database Maintenance

Database Testing

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which phase in the database system life cycle involves regular backups and monitoring system performance?

Requirements Analysis

Database Maintenance

Database Implementation

Database Design

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In the relational model, data is organized into:

Graphs

Records

Relations (tables)

Nodes and edges

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A primary key in a database:

Can have duplicate values

Must have unique and not null values

Can contain null values

Can be a composite of multiple fields

MULTIPLE CHOICE QUESTION

1 min • 1 pt

A foreign key is used to:

Enforce referential integrity between two tables

Uniquely identify each record in a table

Define the data type of a column

Index the records in a table

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

25 questions

IC writing review

Quiz

•

University

25 questions

SBAC ELA Prep

Quiz

•

5th Grade - University

25 questions

Digital Transactions

Quiz

•

University

25 questions

Solutions. Test on un5 (Techn, modal perfect,quantifiers)

Quiz

•

9th Grade - University

30 questions

HCT CB Level 1 List 3 ADWC

Quiz

•

4th Grade - University

25 questions

G&V Review-2

Quiz

•

University - Professi...

26 questions

S.A.Ts Revision 1

Quiz

•

5th Grade - University

25 questions

Australia

Quiz

•

University

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Database Concepts MCQ- 4

Data is best described as:

In the database approach, data can be shared among multiple users. This is called:

In which phase of the database system life cycle is the ER diagram created?

Which phase in the database system life cycle involves regular backups and monitoring system performance?

In the relational model, data is organized into:

A primary key in a database:

A foreign key is used to:

The phase of database design that defines the structure of the data elements without focusing on physical implementation is called:

The phase in which the actual storage structure is defined in a DBMS is:

Which of the following is an example of a strong entity?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground