ITS Databases Practice Exam #14 - Edubirdie

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

2024
Views:

76

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Which are benefits of using Stored Procedures? (Choose two) A. Bandwidth B. Speed C. Complex code can be reused D. Accessibility E. Compatibility 2. A database needs to have all potential customers entered into the customers table as the potential customers are now current customers. Which SQL statement accomplishes this task? A. INSERT INTO customers SELECT * from potential_customers B. INSERT INTO customers VALUES SELECT * from potential_customers C. INSERT INTO customers WHERE* from potential_customers D. SELECT * INTO customers from potential_customers 3. You are trying to build a query that will return the last name, first name, and the number of classes to which each student has enrolled. Only students that have enrolled in at least one class should show in the query results. The classID column needs show as "Classes." Which queries will show the correct results? (Choose two) A. SELECT lastname, firstname, classID Classes FROM students INNER JOIN classes on students.studentid = classes.studentID B. SELECT lastname, firstname, classID NAME Classes FROM students INNER JOIN classes on students.studentid = classes.student|D C. SELECT lastname, firstname, classID ALIAS Classes FROM students INNER JOIN classes on students.studentid = classes.studentlD D. SELECT lastname, firstname, classID as Classes FROM students INNER JOIN classes on students.studentid = classes.studentID 4. In a database, a customers table has 300 rows. A potential_customers table has 10 rows. 2 rows are identical in both tables. The following query is run: SELECT lastname, firstname FROM customers UNION SELECT lastname, firstname FROM potential_customers How many records does the query return? A. 2 B. 310 C. 308 D. 302 5. Of the backup types available for databases, which backup is the fastest? A. Incremental B. Differential C. Snapshot D. Full

Related Documents

ITS Databases Practice Exam #14

ITS Databases Practice Exam #14 - Page 1

ITS Databases Practice Exam #14 - Page 2

of 2

Recommended Documents

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

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

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

Quiz 4: Fundamental Of Data Visualization - Evaluation And Reflection

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

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

Quiz 5: Fundamental Of Data Visualization - Application To Real-World Scenarios

American Baptist College CIT370 | Database Design and Processing

Assignment

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

Quiz 8 : Fundamental Of Data Visualization – Effectiveness Of Chart Usage

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #12

ITS Databases Practice Exam #12

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

Data Analytics Practice Exam #16

Data Analytics Practice Exam #16

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

ITS Databases Practice Exam #2

ITS Databases Practice Exam #2

American Baptist College CIT370 | Database Design and Processing

Assignment

ITS Databases Practice Exam #10

ITS Databases Practice Exam #10

American Baptist College CIT370 | Database Design and Processing

Assignment

New Documents from this Course

ITS Databases Practice Exam #5

ITS Databases Practice Exam #5

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

Data Analytics Practice Exam #17

Data Analytics Practice Exam #17

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

Data Analytics Practice Exam #10

Data Analytics Practice Exam #10

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

Storytelling With Data

Storytelling With Data

American Baptist College CIT370 | Database Design and Processing

Lecture Note