Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Data.Mgmt.Systems3

Chapter8(AdvancedSQL)

QuestionAnswer
The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called... ...join.
The joining condition is based on equality between values in the common columns with... ...equi-join.
A __________ is the same as an equi-join except that it is performed over matching columns that have been defined with the same name, and one of the duplicate columns is eliminated. Natural Join
Using a(n) ________ produces this information: rows that do not have matching values in common columns are also included in the result table. Outer Join
What uses the result of the outer query to determine the processing of the inner query? Correlated subqueries
A named set of SQL statements that are considered (triggered) when a data modification occurs or if certain data definitions are encountered is called a...? Trigger
What returns one value and has only input parameters? A function
What may have input parameters, output parameters, and parameters that are both input and output parameters? A procedure
The advantages of SQL-invoked routines include: Flexibility, efficiency, sharability, & applicability.
The process of including hard-coded SQL statements in a program written in another language, such as C or java, is... An embedded SQL
The process of making an application capable of generating specific SQL code on the fly while the application is processing is... A dynamic SQL
A system used in transaction-oriented applications that involves real-time processing of SQL transaction is... Online Transaction Processing (OLTP)
The use of a set of graphical tools that provides users with multidimensional views of their data and allows them to analyze the data using simple windowing techniques is... An Online Analytical Processing (OLAP) system
OLAP systems differ from OLTP systems in several ways... Size, data sources, processing, users, queries, normalization, & query tools.
SQL provides the _____ technique, which involves placing an inner query within a WHERE or HAVING clause of another (outer) query. subquery
_____ use the result of the outer query to determine the processing of the inner query. Correlated subqueries
The _____ clause is used to combine the output (union the set of rows) from multiple queries together into a single result table. UNION
The _____ can be constructed using either an expression that equates to a value or a predicate. CASE form
_____ describes all tables in the database. DBA_TABLES
SQL:1999 allows users to define their own data type by making it a subclass of a standard type or creating a type that behaves as an object; this is called _____. User-defined data type (UDT)
SQL:200n includes three new data type: _____, _____, & _____; & removed two traditional data types: _____ & _____ BIGINT, MULTISET, XML; BIT, BIT VARYING
________ are extensions defined in SQL:1999 that include the capability to create and drop modules of code stored in the database schema across user sessions. Persistent Stored Modules (SQL/PSM)
______ brings the promise of addressing several widely noted deficiencies of essential SQL. SQL/PSM
A _____ is a set of SQL statements that are considered (triggered) when a data modification occurs or if certain data definitions are encountered. trigger
Both _____ & _____ consist of blocks of procedural code. triggers, routines
A _____ is a stored block of code that must be called to operate. routine
A _____ returns one value and has only input parameters. function
A _____ may have input parameters, output parameter, and parameters that are both input and output parameters. procedure
The advantages of SQL-invoked routines include: Flexibility, efficiency, sharability, applicability.
_______ is the process of including hard-coded SQL statements in a program written in another language, such as C or Java. Embedded SQL
______ is the process of making an application capable of generating specific SQL code on the fly while the application is processing. Dynamic SQL
______ is used to generate appropriate SQL code on the fly while an application is processing. Dynamic SQL
___________ is a system used in transaction-oriented applications that involves real-time processing of SQL transactions. Online transaction processing (OLTP)
___________ are the use of a set of graphical tools that provides users with multidimensional views of their data and allows them to analyze the data using simple windowing techniques. Online analytical processing (OLAP) systems
OLAP systems differ from OLTP systems in several ways: Size; data sources; processing; users; queries; normalization; & query tools.
Created by: 58800073
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards