Podcast
Questions and Answers
Which type of synonym allows referencing objects without the need to specify schema?
Which type of synonym allows referencing objects without the need to specify schema?
- Alias synonyms
- Schema synonyms
- Public synonyms (correct)
- Private synonyms
What is the correct syntax for creating a public synonym?
What is the correct syntax for creating a public synonym?
- create schema synonym
- create alias synonym
- create private synonym
- create public synonym (correct)
Which command is used to list tables and views for the current schema?
Which command is used to list tables and views for the current schema?
- List objects
- List views
- List schema
- List tables (correct)
What command is used to view table columns and data types?
What command is used to view table columns and data types?
What do User-defined Types (UDTs) allow us to do?
What do User-defined Types (UDTs) allow us to do?