ITS Databases Practice Exam #9 - Edubirdie

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

2024
Views:

313

Pages:

1
Author:

Muthia M.

Answer these question bellows. 1. Which SQL statement will delete a table named testtable from a database? A. TRUNCATE TABLE testtable B. DELETE TABLE testtable C. DROP TABLE testtable D. REVOKE TABLE testable 2. An organization storing climate data needs to have its database tables be in third normal form. Which statement best defines a table in third normal form? A. The table faithfully represents a relation and has no repeating groups. B. No non-prime attribute in the table is functionally dependent on a proper subset of a candidate key. C. Every non-trivial join dependency in the table is implied by the superkeys of the table D. Every non-prime attribute is non-transitively dependent on every candidate key in the table. 3. You are the assistant database manager at a local amusement park. Amusement Park ticket prices are being raised this season by 10%, and you have been tasked to update the database Park table. Which would be the correct statement to raise Ticket prices 10% in the Park table? A. UPDATE Park SET Ticket = Ticket * 1.1 B. UPDATE Ticket SET Park = Ticket * 1.1 C. UPDATE Park SET Ticket = .10 D. UPDATE Park SET Ticket = increase 10%

Related Documents

ITS Databases Practice Exam #9

ITS Databases Practice Exam #9 - 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