ITS Databases Practice Exam #17 | American Baptist College - Edubirdie

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

2024
Views:

193

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. You have a column that will only contain values from 0 to 1024. What is the most economical data type to use for the column? A. INT B. TINYINT C. DECIMAL(3) D. SMALLINT 2. You need to store whole numbers ranging from 1 to 100. This number range will never change. Which data type should you choose? A. Bit B. TinyInt C. Smallint D. Integer 3. Evaluate the following query: SELECT LastName, FirstName FROM Employees WHERE EmployeeID = ALL (SELECT EmployeelD from Sales WHERE Amount > 50000); The sales amounts in the sales table have varying amounts, with three sales topping 50000, from two different employees. How many records will be returned? A. NULL B. 3 C. 0 D. 2 4. Using drag and drop, arrange the steps for creating an index, named idx_lastname, on the customers table, using the lastname field. Not every option will be used. Answer: Step 1: CREATE INDEX idx_last_name Step 2:ON Step 3:customers(lastname) 5. A developer is adding a table to a database for line items on orders and wants to ensure all order quantities are 1 or higher. Which SQL statement fulfills this requirement? A. CREATE TABLE OrderDetails ( OrderID INT ProductID varchar(10) Qty INT HAVING (Qty >=1) ) B. CREATE TABLE OrderDetails ( OrderID INT ProductID varchar(10) Qty INT UNIQUE (Qty >=1) ) C. CREATE TABLE OrderDetails ( OrderID INT ProductID varchar(10) Qty INT CONSTRAINT (Qty >=1) ) D. CREATE TABLE OrderDetails ( OrderID INT ProductID varchar(10) Qty INT CHECK (Qty >= 1) )

Related Documents

ITS Databases Practice Exam #17

ITS Databases Practice Exam #17 - Page 1

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