Fillin the Blanks Database #8 - Edubirdie

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

106

Pages:

1
Author:

Muthia M.

Fillin the Blanks 1. The ORDER BY clause is used(SORT) to information in a query. [ORDER BY] 2. The letters(DESC) sort a column in descending order. [ORDER BY] 3. The WHERE clause creates (CONDITIONS) on the data in a query. [WHERE] 4. (SINGLE) quotes should be used around any value with text. [WHERE] 5. A LIKE clause is used with a WHERE clause to allow(PATTERN MATCHING) within a query. [LIKE] 6. The (%) symbol is a wildcard that means any number of characters. [LIKE] 7. The BETWEEN keyword allows one to return records between two (VALUES) or dates. [BETWEEN] 8. The BETWEEN keyword is (INCLUSIVE). [BETWEEN] 9. The key to using multiple criteria in a query is to use (LOGICAL correct OPERATORS) given a situation. [AND] 10. The AND clause adds (ADDITIONAL) criteria to an existing query. [AND]

Related Documents

Fillin the Blanks Database #8

Fillin the Blanks Database #8 - Page 1

of 1

Recommended Documents

Quiz 4: Data Visualization - Evaluation & Reflection

Quiz 4: Data Visualization - Evaluation & Reflection

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #3

Data Analytics Practice Exam #3

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #2

ITS Databases Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #19

Data Analytics Practice Exam #19

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #20

Data Analytics Practice Exam #20

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam 18

Data Analytics Practice Exam 18

American Baptist College CIT370 | Database Design and Processing

Answer Key

TOP DOCUMENT

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

Quiz 1: Fundamental Of Data Visualization - Knowledge And Comprehension

American Baptist College CIT370 | Database Design and Processing

Assignment

TOP DOCUMENT

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

Quiz 3: Fundamental Of Data Visualization - Synthesis And Creation

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #5

Data Analytics Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam

ITS Databases Practice Exam

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #13

Data Analytics Practice Exam #13

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #1

ITS Databases Practice Exam #1

American Baptist College CIT370 | Database Design and Processing

Assignment

New Documents from this Course

SQL Commands and Concepts Review

SQL Commands and Concepts Review

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #17

ITS Databases Practice Exam #17

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #11

ITS Databases Practice Exam #11

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #8

ITS Databases Practice Exam #8

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #7

ITS Databases Practice Exam #7

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #5

ITS Databases Practice Exam #5

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #14

Data Analytics Practice Exam #14

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #12

Data Analytics Practice Exam #12

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #9

Data Analytics Practice Exam #9

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #6

Data Analytics Practice Exam #6

American Baptist College CIT370 | Database Design and Processing

Assignment

Data Analytics Practice Exam #2

Data Analytics Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

Storytelling With Data

Storytelling With Data

American Baptist College CIT370 | Database Design and Processing

Lecture Note