IMO (LEC) FINAL EXAM: Practice Reviewer
True
A row cannot be removed if the view has a group by function.
True
Caching sequence values in memory gives faster access to those values
TRUE
Database is an organized collection of logically related data
Metadata
Information is a data that describes the properties and context of user data
True
Users can create nonunique indexes on columns to speed up access to the rows
variables
What are temporary storage of data in PL/SQL?
Sequence
What is a database object that generates numeric values
index
What is a database object that improves the performance of data retrieval queries?
Synonym
What is a database schema object that gives an alternative name to objects?
False
You can use NextVal and Currval in a select statement with distinct keyword