Activity 1 - Database Management System

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

Maximum children of  a B-tree of order m?

• m-1
• m+1
• 2m
• m