DBMS Lab Quiz 2 B3

DBMS Lab Quiz 2 B3

University

10 Qs

quiz-placeholder

Similar activities

Tree and Planar Graph

Tree and Planar Graph

University

10 Qs

CodeMonkey for B.Ed IT

CodeMonkey for B.Ed IT

University

10 Qs

Computational Thinking in Python[Quiz 3]

Computational Thinking in Python[Quiz 3]

University

15 Qs

TOOLS FOR AD & TECHNOLOGY DEVELOPMENT (W4-W6)

TOOLS FOR AD & TECHNOLOGY DEVELOPMENT (W4-W6)

University

10 Qs

Teste 1 - Inteligência Artificial

Teste 1 - Inteligência Artificial

University

10 Qs

Programación en HTML 1 con Codepen 10°

Programación en HTML 1 con Codepen 10°

10th Grade - University

14 Qs

Understanding Email, Contacts and Calendaring

Understanding Email, Contacts and Calendaring

University

10 Qs

BB

BB

University

10 Qs

DBMS Lab Quiz 2 B3

DBMS Lab Quiz 2 B3

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Nikhil govil

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A database application is designed to handle concurrent transactions. A user initiates a transaction to read a set of records without being affected by changes made by other transactions. Which isolation level should be set for this transaction?

READ UNCOMMITTED

READ COMMITTED

REPEATABLE READ

SERIALIZABLE

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A database contains a table named students with columns student_id, student_name, and enrollment_date. A user initiates a transaction to retrieve the count of students enrolled after a specific date. Which SQL statement should be used to perform this retrieval within the transaction?

SELECT COUNT(student_id) FROM students WHERE enrollment_date > '2023-01-01';

COUNT students WHERE enrollment_date > '2023-01-01';

GET COUNT(student_id) FROM students WHERE enrollment_date > '2023-01-01';

RETRIEVE COUNT(student_id) FROM students WHERE enrollment_date > '2023-01-01';

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A user initiates a transaction to retrieve the highest salary from a table named employees. Which SQL statement should be used to perform this retrieval within the transaction?

GET MAX(salary) FROM employees;

SELECT MAX(salary) FROM employees;

FIND MAX(salary) IN employees;

SEARCH MAX(salary) WITHIN employees;

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A database contains a table named products with columns product_id, product_name, and quantity_in_stock. A user initiates a transaction to update the quantity in stock for a specific product with product_id = 201 to 50. Which SQL statement should be used to perform this update within the transaction?

CHANGE products SET quantity_in_stock = 50 WHERE product_id = 201;

UPDATE products SET quantity_in_stock = 50 WHERE product_id = 201;

MODIFY products SET quantity_in_stock = 50 WHERE product_id = 201;

ALTER products SET quantity_in_stock = 50 WHERE product_id = 201;

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A user initiates a transaction to retrieve the distinct categories of products from a table named products. Which SQL statement should be used to perform this retrieval within the transaction?

SELECT DISTINCT category FROM products;

GET DISTINCT category FROM products;

SEARCH DISTINCT category IN products;

FIND DISTINCT category IN products;

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

An inventory management system records the quantity of products in a table. A user initiates a transaction to update the quantity of a specific product. If any part of the transaction fails, the system should revert to the state at the beginning of the transaction. Which SQL statement is used to roll back to a savepoint ?

ROLLBACK 

ROLLBACK TO SAVEPOINT 

ROLLBACK TRANSACTION 

UNDO TO SAVEPOINT

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

A user initiates a transaction to update multiple records in a table, and the changes should be isolated from other transactions until the entire transaction is committed. Which isolation level should be set for this transaction?

READ UNCOMMITTED 

READ COMMITTED 

REPEATABLE READ

SERIALIZABLE

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?