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

Question

Share Report Error

What is a synonym in database terms?

A. A foreign key

B. A data type

C. An alias for a table or view

D. A type of index

Answer: Option C

Solution (By JKSSB Mock Tests)

A synonym is an alternative name for a database object, allowing simpler references.

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 is a composite key in a database?

A. A key that is made up of multiple columns

B. A key that references another table

C. A key that is a single column

D. A key that is always a foreign key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A composite key is a primary key that consists of two or more columns to uniquely identify a row.

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

Question #2

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

A. Data is accessed via SQL

B. Relationships are represented through keys

C. All of the above

D. Data is stored in tables

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
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)

Question #3

What is the purpose of the SQL 'UNION' operator?

A. To combine the results of two or more SELECT statements, removing duplicates

B. To filter duplicates

C. To aggregate data

D. To join tables horizontally

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UNION concatenates the result sets of two or more queries, eliminating duplicate rows. UNION ALL keeps duplicates.

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

Explore All Database Management System (DBMS) MCQs