Data Information Management Quiz 4.doc...
Data___Information_Management_Quiz_4.docx.pdf-When using NOT IN to solve
Showing 6-9 out of 9
Data Information Management Quiz 4.docx.pdf-When...
Data___Information_Management_Quiz_4.docx.pdf-When using NOT IN to solve
Data Information Management Quiz ...
Data___Information_Management_Quiz_4.docx.pdf-When using NOT IN to solve
Page 6
Value expression
Search condition
WHEN
ELSE
Which of these three database systems does not support the CASE syntax? (Points : 2)
Microsoft SQL server
Microsoft Access
MySQL
All of these support the CASE syntax
None of these support the CASE syntax
In a CASE statement that uses a searched when clause, what follows CASE? (Points : 2)
Value expression
WHEN
Search Condition
ELSE
A CROSS JOIN will return a total number of rows that equals the product of the total number of
rows in the first table times the total number of rows in the second table and is known as what?
(Points : 2)


Page 7
A Cartesian product
A NATURAL JOIN
An OUTER JOIN
A UNION
What has SQL defined to execute a query multiple times in a loop? (Points : 2)
LOOP
WITH RECURSIVE
WHEN
THEN
When testing for true or false, what value do most database systems use for false? (Points : 2)
0
1
-1
Using a driver table enables you to pivot data, making it appear as what? (Points : 2)
A form
A report


Page 8
A spreadsheet
A list
A JOIN that returns all rows from the first table matched with all rows from a second table is
known as a what? (Points : 2)
INNER JOIN
OUTER JOIN
NATURAL JOIN
CROSS JOIN
A table used to provide lookup values is known as what? (Points : 2)
Lookup table
Driver table
Secondary table
Primary table


Page 9
A spreadsheet
A list


Ace your assessments! Get Better Grades
Browse thousands of Study Materials & Solutions from your Favorite Schools
Texas A %26 M University-...
Texas_A_%26_M_University-Corpus_Christi
School:
Data_Management
Course:
Great resource for chem class. Had all the past labs and assignments
Leland P.
Santa Clara University
Introducing Study Plan
Using AI Tools to Help you understand and remember your course concepts better and faster than any other resource.
Find the best videos to learn every concept in that course from Youtube and Tiktok without searching.
Save All Relavent Videos & Materials and access anytime and anywhere
Prepare Smart and Guarantee better grades

Students also viewed documents