BALT6201 HW4 Quiz

 

Your work has been saved and submitted

Written Feb 6, 2025 7:46 PM - Feb 7, 2025 10:05 PMAttempt 1 of 2

Attempt Score	20 / 20 - 100 %
Overall Grade (Highest Attempt)	20 / 20 - 100 %

Question 1

2 / 2 points

________ is a set of commands used to update and query a database.

Question options:

	A)  DML
	B)  DDL
	C)  DCL
	D)  DPL

Question 2

2 / 2 points

The main concept of relational databases was published in 1970 by:

Question options:

	A)  Itzak Ben-Gan.
	B)  Hoffer.
	C)  Mills.
	D)  E.F.Codd.

Question 3

2 / 2 points

The command for removing a table is:

Question options:

	A)  CREATE TABLE.
	B)  REMOVE TABLE.
	C)  DROP TABLE.
	D)  TRUNCATE TABLE.

Question 4

2 / 2 points

The SQL command ________ adds one or more new columns to a table.

Question options:

	A)  CREATE TABLE
	B)  ALTER TABLE
	C)  CREATE VIEW
	D)  CREATE RELATIONSHIP

Question 5

2 / 2 points

What does the following SQL statement do?

ALTER TABLE Customer_T
ADD (Type Varchar (2));

Question options:

	A)  Alters the Customer_T table to accept Type 2 Varchars
	B)  Alters the Customer_T table to be a Type 2 Varchar
	C)  Alters the Customer_T table by adding a field called "Type"
	D)  Alters the Customer_T table by adding a 2-byte field called "Varchar"

Question 6

2 / 2 points

INSERT INTO is an example of ________ code.

Question options:

	A)  DDL
	B)  DML
	C)  DCL
	D)  TIO

Question 7

2 / 2 points

What does the following SQL statement do?

DELETE FROM Customer_T
WHERE state = 'HI';

Question options:

	A)  Deletes all records from Customer_t where the state is equal to HI
	B)  Removes the Customer_T table from the database
	C)  Deletes all records from the Customer_T table
	D)  Doesn't delete anything because of a syntax error

Question 8

2 / 2 points

In an SQL statement, which of the following parts states the conditions for row selection?

Question options:

	A)  SELECT
	B)  FROM
	C)  WHERE
	D)  GROUP BY

Question 9

2 / 2 points

What does the following SQL statement do?

SELECT * From Customer WHERE Cust_Type = "Best"

Question options:

	A)  Selects all the fields from the Customer table for each row with a customer labeled "Best"
	B)  Selects the "*" field from the Customer table for each row with a customer labeled "Best"
	C)  Selects fields with a "*" in them from the Customer table
	D)  Selects all the fields from the Customer table for each row with a customer labeled "*"

Question 10

2 / 2 points

What results will be produced by the following SQL query?

SELECT SUM(Standard_Price) as Total_Price
from Product_V
where Product_Type = 'WOOD';

Question options:

	A)  The total price of all products that are of type wood
	B)  The total price of all products
	C)  The Standard_Price of the first wood product in the table
	D)  The Standard_Price of any wood product in the table