In a Relational Database Management System (RDBMS), data is logically organized and stored in which form? MCQ with Answer and Explanation

Question

Share Report Error

In a Relational Database Management System (RDBMS), data is logically organized and stored in which form?

A. Tables

B. Trees

C. Graphs

D. Flat text files

Answer: Option A

Solution (By JKSSB Mock Tests)

In an RDBMS, data is organized into relations, which are logically represented as two-dimensional tables consisting of rows and columns.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

What does the EXISTS operator do in SQL?

A. Checks if a value is null

B. Performs arithmetic

C. Tests for the existence of rows returned by a subquery

D. Compares two values

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
EXISTS returns TRUE if the subquery returns at least one row, otherwise FALSE.

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

Question #2

Which SQL function returns the current date and time?

A. GETDATE()

B. NOW()

C. CURDATE()

D. All of the above depending on the DBMS

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Different DBMSs have different functions: MySQL NOW(), SQL Server GETDATE(), etc. But all return current date/time.

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

Question #3

Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time?

A. Trigger

B. Index

C. Cursor

D. View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Cursor is a database control structure that allows an application or script to traverse over the records of a query result set row by row.

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

Explore All Database Management System (DBMS) MCQs