Skip to content

Search for:

GK Quiz
Sports Quiz
Space Quiz
Festivals Quiz

Python Quiz
GK Quiz
Space Quiz
Sports Quiz

Search for:

Test Your Knowledge

SQL Quiz
0

Quiz on SQL Synonyms

by Quiz Orbit Team

A synonym in SQL is an alias, or alternate name, for a database object, such as a table, view, sequence, or stored procedure. It provides abstraction, simplifies access, and supports easier migration or cross-schema references.

Time limit: 0

Quiz Summary

0 of 15 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 15 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Current
Review / Skip
Answered
Correct
Incorrect

Question 1 of 15
1. Question
What is a synonym in SQL?
- A duplicate table
- A virtual table with data
- An alias for another database object
- A keyword for join operation
Correct
Incorrect
Question 2 of 15
2. Question
Which SQL command is used to create a synonym?
- NEW SYNONYM
- CREATE SYNONYM
- DEFINE SYNONYM
- MAKE SYNONYM
Correct
Incorrect
Question 3 of 15
3. Question
Which of the following database systems supports synonyms by default?
- Oracle
- MySQL
- PostgreSQL
- SQLite
Correct
Incorrect
Question 4 of 15
4. Question
What is the syntax to create a synonym for a table?
- SYNONYM table_name FOR alias_name;
- CREATE SYNONYM alias_name FOR table_name;
- CREATE TABLE synonym_name AS table_name;
- DEFINE alias AS table;
Correct
Incorrect
Question 5 of 15
5. Question
What is a public synonym in SQL?
- A synonym created for temporary tables
- A synonym accessible by all users
- A synonym for encrypted views
- A synonym used in triggers
Correct
Incorrect
Question 6 of 15
6. Question
Which command is used to remove a synonym?
- DROP
- DELETE
- REMOVE
- DROP SYNONYM
Correct
Incorrect
Question 7 of 15
7. Question
Which of the following is true about private synonyms?
- Accessible only by the user who created them
- Stored in a global schema
- Automatically indexed
- Cannot be dropped
Correct
Incorrect
Question 8 of 15
8. Question
Why are synonyms used in SQL?
- To store more data
- To optimize joins
- To simplify SQL access and abstract object names
- To enforce primary keys
Correct
Incorrect
Question 9 of 15
9. Question
Can a synonym be created for a view?
- No
- Only if it's materialized
- Yes
- Only in joins
Correct
Incorrect
Question 10 of 15
10. Question
What will happen if you try to access a synonym that points to a dropped table?
- It will return NULL
- Synonym will auto-refresh
- Error: Invalid object
- It will create a new table
Correct
Incorrect
Question 11 of 15
11. Question
Can you create a synonym for a remote table (via DB link in Oracle)?
- No
- Yes
- Only in MySQL
- Only with public synonyms
Correct
Incorrect
Question 12 of 15
12. Question
Which of the following can synonyms NOT be created for?
- Tables
- Views
- Indexes
- Sequences
Correct
Incorrect
Question 13 of 15
13. Question
What privilege is required to create a public synonym in Oracle?
- SELECT ANY TABLE
- CREATE TABLE
- CREATE PUBLIC SYNONYM
- CREATE ANY INDEX
Correct
Incorrect
Question 14 of 15
14. Question
Can two users create synonyms with the same name in the same schema?
- Yes
- No
- Only if it's a view
- Only for functions
Correct
Incorrect
Question 15 of 15
15. Question
What is one limitation of using synonyms?
- Slower performance
- Cannot be used in SELECT queries
- Dependency on the underlying object
- No support for tables
Correct
Incorrect

Summary

This quiz on SQL Synonyms helps learners understand the concept of aliasing database objects, including syntax, use cases, and limitations. It focuses on both private and public synonyms, primarily in Oracle and enterprise-level RDBMS systems.

Tags: mcq on sql synonyms quiz on sql synonyms quiz on synonyms in sql SQL Quiz sql quiz on synonyms sql synonyms mcq sql synonyms quiz

Quiz Orbit Team

At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Δ

Next story Quiz on Connecting to CSV in Power BI
Previous story Quiz on Connecting to Excel Data in Power BI

About Us
Contact Us
Privacy Policy
Disclaimer

Quiz Orbit © 2026. All Rights Reserved.