Free Printable Activity 1 - Database Management System

Worksheets

Activity 1 - Database Management System

Total questions: 15

Worksheet time: 11mins

Name

Class

Date

What is rows of a relation known as?

Degree

Entity

Tuple

None

What is the name of the query that is placed within a WHERE or HAVING clause of another query?

Subquery

Join Query

Aggregate Query

Filter Query

What is the use of COUNT in SQL?

COUNT is used to delete rows from a table.

COUNT is used to update existing records.

COUNT is used to count the number of rows in a result set.

COUNT is used to create new tables.

Which data structure is used in Hierarchical model records?

Tree

List

Array

Graph

Which normal form deals with multivalued dependency?

Second Normal Form (2NF)

Third Normal Form (3NF)

Fourth Normal Form (4NF)

Fifth Normal Form (5NF)

Which of the following allows to uniquely identify a tuple?

Primary key

Unique constraint

Foreign key

Composite key

Select the correct command to modify a column in a table.

ALTER TABLE table_name MODIFY COLUMN column_name new_data_type;

MODIFY TABLE table_name CHANGE column_name new_data_type;

CHANGE TABLE table_name ALTER COLUMN column_name TYPE new_data_type;

UPDATE table_name SET column_name = new_data_type;

During transaction before commit which of the following statement is done automatically in case of shutdown?

Commit of all transactions

Rollback of uncommitted transactions

Savepoint creation for all transactions

Ignore uncommitted transactions

Identify the concurrency based protocol?

Single Locking Mechanism

Two-Phase Locking (2PL)

Timestamp Ordering

Optimistic Concurrency Control

10.

Maximum children of a B-tree of order m?

m-1

m+1

11.

Select the correct advantages of view.

Advantages of views include simplification of complex queries, enhanced security, improved performance, and code reusability.

Limited access to underlying tables

Reduced data integrity

Increased complexity in query writing

12.

To select some particular columns, which of the following command is used in Relational Algebra?

σ (sigma) selection operation

∪ (union) operation

∩ (intersection) operation

π (pi) projection operation

13.

What is a table joined with itself called?

Cross-join

Inner-join

Outer-join

Self-join

14.

Select the correct definition of Relational calculus?

A procedural query language that requires specific steps to retrieve data.

A type of database that stores data in a hierarchical format.

A language used for programming applications outside of databases.

A non-procedural query language for databases that specifies what data to retrieve.

15.

A ___________of the transactions can be obtained by finding a linear order consistent with the partial order of the precedence graph.

linear regression

graph traversal

data sorting

topological sorting

Reset

Activity 1 - Database Management System

Total questions: 15

Worksheet time: 11mins

Similar Resources on Wayground