Which of the following best defines a 'database language'?

B) A language used for retrieving and manipulating data

A) A programming language for controlling hardware

C) A language for creating database backups

D) A language used to define the operating system structure

Which of the following best describes a 'relational DBMS'?

A) A DBMS that uses tables to represent data

B) A DBMS that uses trees for data storage

C) A DBMS that stores data in files

D) A DBMS that stores data as objects

In an Entity-Relationship (ER) model, an 'entity' is best described as:

A) A real-world object or concept

B) A relationship between two objects

C) A data structure used for organizing data

In an ER diagram, a 'weak entity' is:

A) An entity that cannot exist without a corresponding strong entity

B) An entity that has no attributes

C) An entity that does not have relationships with other entities

D) An entity with a high degree of participation in relationships

Which of the following is an example of an attribute of an entity in an ER model?

B) Relationship between two people

D) Connection between two entities

A 'cardinality' constraint in an ER model specifies:

A) The maximum and minimum number of entities that can be involved in a relationship

B) The primary key of an entity

C) The number of entities in a database

D) The uniqueness of an attribute in a relation

A '1:1' cardinality in an ER diagram means:

B) Each entity in set A can relate to exactly one entity in set B, and vice versa

A) One entity of set A can be related to one or more entities of set B

C) One entity of set A can relate to only one entity in set B

D) There is no relationship between entities in sets A and B

Which of the following is true about a 'participation constraint' in an ER model?

B) It specifies whether all or only some entities participate in a relationship

A) It determines the degree of a relationship

C) It defines the primary key of an entity

D) It specifies the number of attributes of an entity

Which of the following best describes a 'composite attribute' in an ER diagram?

A) An attribute that can be broken down into simpler components

B) An attribute that uniquely identifies an entity

C) An attribute that belongs to multiple entities

D) An attribute that does not have any values

What is a 'multivalued attribute' in an ER diagram?

A) An attribute that can have multiple values for a single entity

B) An attribute that cannot be assigned any values

C) An attribute that uniquely identifies an entity

D) An attribute that is composed of other attributes

A "ternary relationship" in an ER diagram involves:

A single entity with multiple attributes

In an ER diagram, a "participation constraint" of total participation means:

Every entity in the entity set must participate in the relationship

Some entities in the entity set may not participate in the relationship

The relationship is optional for all entities

The relationship is mandatory for all entities

The primary purpose of using an Entity-Relationship (ER) model is to:

Represent the logical structure of the database

Define the data types of attributes

Create an operational database schema

Establish relationships between file systems

Which of the following is true about weak entities in an ER diagram?

They must have a composite key from the strong entity

They can exist independently without a strong entity

They do not participate in any relationship

They have unique identifiers that are not derived from other entities

A relationship in an ER diagram is represented as a diamond shape. What does the diamond represent?

A relationship between entities

Which of the following best defines a "primary key" in a DBMS?

An attribute that uniquely identifies a record in a table

An attribute that is used for indexing a table

An attribute that can have null values

An attribute that stores metadata about the data

What is the purpose of using "normalization" in database design?

To eliminate data anomalies and improve consistency

To increase redundancy in the database

To reduce the complexity of queries

To define the physical storage of data

Which of the following is an example of a "one-to-many" relationship in an ER model?

A department has many employees, but each employee works for only one department

A student can have many courses, but each course has one student

Each employee has one job title

A product can be associated with many suppliers, but each supplier supplies only one product

Which of the following constraints is used to define the minimum number of entities that can be involved in a relationship?

Referential integrity constraint

In an ER diagram, which of the following is used to indicate the degree of a relationship?

The number of entities involved in the relationship

The color of the relationship diamond

The number of attributes of an entity

The shape of the entity rectangle

Which of the following is NOT an integrity constraint in a relational database?

Referential Integrity Constraint

Which of the following integrity constraints ensures that no two tuples in a relation have the same value for the primary key attribute?

Referential Integrity Constraint

Which of the following integrity constraints ensures that every foreign key in a table matches a primary key in the referenced table?

Referential Integrity Constraint

Functional Integrity Constraint

What is the purpose of the domain integrity constraint in a relational database?

To restrict the values that an attribute can take

To ensure that the primary key is unique

To establish a relationship between two tables

To ensure that tuples have distinct values

What does the term "relational schema" refer to in a relational database?

The structure that defines the database tables and their relationships

The data stored in the database

The set of integrity constraints for the database

The physical storage of the database

Which of the following is true about relational algebra in DBMS?

It operates on tuples, relations, and attributes

It uses SQL syntax to execute queries

It is primarily used for querying unstructured data

It involves creating tables and relations

What does the Cartesian product operation in relational algebra do?

Combines two relations into a single relation without any condition

Filters rows based on a condition

Combines relations based on matching column values

Selects specific columns from a relation

What is the result of applying an equi-join operation in relational algebra?

Rows that match based on equality of attribute values

A combination of all rows from both relations

A combination of all rows with distinct values

A single relation with selected attributes

Which of the following is the main purpose of the natural join operation in relational algebra?

To merge two relations based on common attributes

To remove duplicate rows from a relation

To sort rows in ascending or descending order

To select columns from a relation

In relational algebra, the 'difference' operation is used to:

Return rows that are in one relation but not in another

Combine rows from two relations

Merge two relations with matching attribute values

Select rows from a relation based on conditions

What does the SQL INSERT command do?

Modifies existing records in a table

Creates a new table in the database

What does the SQL UPDATE command do?

Updates data in a table based on a condition

Modifies the structure of a table

DBMS Concepts Quiz

Authored by VAISHNEV SREEJEEV

Computers

University

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

70 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a characteristic of a Database Management System (DBMS)?

A) Provides concurrent access to data

B) Stores data in a file system without any structure

C) Does not support data security

D) Uses a flat file format for data storage

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a type of database user?

A) Database administrator

B) Database programmer

C) Database designer

D) Database compiler

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of data can be stored in a relational database?

A) Structured data only

B) Semi-structured data only

C) Unstructured data only

D) Structured, semi-structured, and unstructured data

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a major advantage of using a DBMS?

A) Data redundancy is reduced

B) Data retrieval speed is reduced

C) It does not allow concurrent access to the database

D) Data integrity is compromised

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which data model is used to represent data in a hierarchical structure with parent-child relationships?

A) Relational model

B) Network model

C) Hierarchical model

D) Object-oriented model

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The Three Schema Architecture consists of which of the following levels?

A) Internal, conceptual, and external

B) Physical, conceptual, and logical

C) External, logical, and physical

D) Conceptual, logical, and external

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is true about the 'Schema' in DBMS?

A) A schema is a set of data values in a table

B) Schema defines the structure of the database

C) Schema only applies to relational databases

D) A schema is a collection of all the files in the system

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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

69 questions

CEA201

Quiz

•

University

66 questions

Computing Fundamentals Prefinal Exam

Quiz

•

University

68 questions

SUBNETTING

Quiz

•

University - Professi...

65 questions

ASIA Midterm Reviewer

Quiz

•

University

75 questions

1er parcial de Plataforma de comercio digital

Quiz

•

University

70 questions

Communication Skills Quiz

Quiz

•

9th Grade - University

75 questions

APCS Principles Practice Exam

Quiz

•

8th Grade - University

72 questions

Server, Konsola, Virtual, AD, DHCP, DNS, NAT, IIS, FTP

Quiz

•

7th Grade - Professio...

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

20 questions

CompTIA Network+ - Ports and Protocols

Quiz

•

University

DBMS Concepts Quiz

Which of the following is a characteristic of a Database Management System (DBMS)?

Which of the following is NOT a type of database user?

Which type of data can be stored in a relational database?

Which of the following is a major advantage of using a DBMS?

Which data model is used to represent data in a hierarchical structure with parent-child relationships?

The Three Schema Architecture consists of which of the following levels?

Which of the following is true about the 'Schema' in DBMS?

Which of the following best defines a 'database language'?

Which of the following is an example of a Data Definition Language (DDL) command?

Which of the following best describes a 'relational DBMS'?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers