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.