Sql Invoked Routines Can Be

Question: An equi-join is a join in which one of the duplicate columns is eliminated in the result table.

Answer: False

Question: All of the following are guidelines for better query design EXCEPT:

Answer: use a lot of self-joins.

Question: Extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions are called:

Answer: Persistent Stored Modules.

Question: Figuring out what attributes you want in your query before you write the query will help with query writing.

Answer: True

Question: Persistent Sorted Modules are extensions defined in SQL-99 that include the capability to create and drop modules of code stored in the database schema across user sessions.

Answer: False

Question: A trigger is a named set of SQL statements that are considered when a data modification occurs.

Answer: True

Question: An operation to join a table to itself is called a(n):

Answer: self-join.

Question: A new set of analytical functions added in SQL:2008 is referred to as:

Answer: OLAP functions.

Question: ________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows.

Answer: Exists

Question: SQL-invoked routines can be:

Answer: functions or procedures.