Match the following terms to the appropriate definition: _________ Equijoina. Undoes changes to a table _________ Natural

Question:

Match the following terms to the appropriate definition:
_________ Equijoin……………………………a. Undoes changes to a table
_________ Natural join………………………..b. user-define data type
_________ Outer join………………………….c. SQL.: 1999 extension
_________ Trigger…………………………….d. return all records of designated table
_________ Procedure………………………….e. keeps redundant columns
_________ Embedded SQL……………………f. makes changes to a table permanent
_________ UDT……………………………….g. process that include SQL statements within a
host language
_________ COMMIT………………………….h. process of making and application capable of
generating specific SQL code on the fly
_________ SQL/PSM………………………….i. does not keep redundant columns
_________ Dynamic SQL………………………j. set of SQL statements that execute understand
conditions
_________ ROLLBACK……………………….k. stored, named collection of procedural and
SQL statements
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Database Management

ISBN: 978-0133544619

12th edition

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

Question Posted: