Which of the following is a characteristic of the relational model? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a characteristic of the relational model?

A. Data is accessed via SQL

B. Data is stored in tables

C. Relationships are represented through keys

D. All of the above

Answer: Option D

Solution (By JKSSB Mock Tests)

The relational model organizes data in tables, uses keys for relationships, and is queried using a language like SQL.

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

Which of the following is a valid SQL statement to create a table?

A. Both A and B

B. CREATE TABLE table_name (column1 datatype, column2 datatype);

C. Neither

D. CREATE TABLE table_name AS SELECT ...;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both syntaxes are valid: direct CREATE TABLE with columns, and CREATE TABLE ... AS SELECT to create a table from a query result.

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

Question #2

Which of the following is a valid SQL function to convert a string to uppercase?

A. UCASE()

B. TO_UPPER()

C. UPPER()

D. Both A and C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
UPPER() is standard SQL; some DBMS also support UCASE().

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

Question #3

A view in DBMS is:

A. A physical copy of the table

B. A virtual table based on the result of a query

C. A backup of the database

D. An index on the table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A view is a virtual table derived from one or more base tables.

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

Explore All Database Management System (DBMS) MCQs