In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes? MCQ with Answer and Explanation

In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
A. Relation Card
B. Relation Schema
C. Relation Domain
D. Relation Instance
Answer: Option B
Solution (By JKSSB Mock Tests)
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which SQL keyword is used within a SELECT query to filter records matching a specified pattern using wildcards?
A. IN
B. LIKE
C. EXISTS
D. BETWEEN

Correct Answer: Option B


Explanation:
The LIKE operator is specifically used in a WHERE clause to perform pattern matching on string columns using wildcards (% and _).

This question belongs to: Computer Database Management System (DBMS)
Question #2
A Primary Key in RDBMS must be:
A. Unique and not null
B. Can have null values
C. Always a foreign key
D. Duplicate values allowed

Correct Answer: Option A


Explanation:
A primary key uniquely identifies each record and cannot contain null values.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What does the letter 'D' stand for in the widely accepted ACID properties of database transactions?
A. Data
B. Durability
C. Dependency
D. Definition

Correct Answer: Option B


Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.

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