What is a relation in relational database terms? MCQ with Answer and Explanation

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?

A. WHERE

B. ORDER BY

C. GROUP BY

D. HAVING

View Answer & Solution Discuss

Correct Answer: Option A

---

Explanation:
The WHERE clause is used to filter records based on a specified condition before any grouping takes place.

---

This question belongs to: Computer Database Management System (DBMS)

Report Question Issue

Help us improve! Please select the issue with this question:

-- Select an Issue -- Incorrect Answer Provided Formatting / Spelling Mistakes Incomplete Question or Options Question is in the Wrong Topic Explanation is incorrect/unclear Other Issue

Additional Details (Optional)

Cancel Submit Report

Question #2

Share Report

What is a column in a relational database table formally called?

A. Degree

B. Attribute

C. Entity

D. Tuple

View Answer & Solution Discuss

Correct Answer: Option B

---

Explanation:
A column in a database table represents a property or characteristic of the entity and is formally known as an attribute.

---

This question belongs to: Computer Database Management System (DBMS)

Report Question Issue

Help us improve! Please select the issue with this question:

-- Select an Issue -- Incorrect Answer Provided Formatting / Spelling Mistakes Incomplete Question or Options Question is in the Wrong Topic Explanation is incorrect/unclear Other Issue

Additional Details (Optional)

Cancel Submit Report

Question #3

Share Report

What does the ROLLBACK statement do?

A. Creates a savepoint

B. Saves the changes

C. Starts a new transaction

D. Undoes all changes made in the current transaction

View Answer & Solution Discuss

Correct Answer: Option D

---

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.

---

This question belongs to: Computer Database Management System (DBMS)

Report Question Issue

Help us improve! Please select the issue with this question:

-- Select an Issue -- Incorrect Answer Provided Formatting / Spelling Mistakes Incomplete Question or Options Question is in the Wrong Topic Explanation is incorrect/unclear Other Issue

Additional Details (Optional)

Cancel Submit Report

Explore All Database Management System (DBMS) MCQs

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'u220813639_questions.youtube_shorts' doesn't exist in /home/u220813639/domains/ask.jkexamlibrary.in/public_html/templates/partials/sidebar.php:55 Stack trace: #0 /home/u220813639/domains/ask.jkexamlibrary.in/public_html/templates/partials/sidebar.php(55): PDO->query() #1 /home/u220813639/domains/ask.jkexamlibrary.in/public_html/templates/question.php(278): require('/home/u22081363...') #2 /home/u220813639/domains/ask.jkexamlibrary.in/public_html/index.php(53): require_once('/home/u22081363...') #3 {main} thrown in /home/u220813639/domains/ask.jkexamlibrary.in/public_html/templates/partials/sidebar.php on line 55