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