CET_TARDE - MTA Database - E_COMANDS

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*) FROM Product WHERE Quantity > 18

What is the value returned by this statement?

You have the following table definition:
CREATE TABLE Product (ID INTEGER PRIMARY KEY, Name VARCHAR(20), Quantity INTEGER)

The Product table contains the following data.

You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL

How many rows are returned?

17. You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)

The Road table contains the following data:

You execute the following statement:
INSERT INTO Road VALUES (1234, 36)

What is the result?

You accept an IT internship at a local charity. The charity asks you to keep a record of its
volunteers by using a database table named Volunteer. The table has the following
columns and rows:

You need to list the name and price of each product, sorted by price from highest to lowest.
Which statement should you use?

You have a table named Customer. You need to add a new column named District. Which
statement should you use?

You need to populate a table named EmployeeCopy with data from an existing table named Employee.
Which statement should you use?

Which statement creates a composite key?

You are creating a database object named Student to store the following data:

Which syntax should you use to create the object?

You have a database table named SongInformation as defined below:

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer. When volunteers ask to be removed from mailing lists, the table must be updated. You need to use a transaction to ensure that the database has data integrity and referential integrity. Which statement should you use?

You have the database table named Cars as defined below:

How many rows are returned by the SQL statement?

Your database contains a table named Customer. You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?

You have the following table definition:
CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))

You need to insert a new product. The product’s name is Plate and the product’s ID is 12345. Which statement should you use?

Which statement deletes the rows where the employee’s phone number is not entered?

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126. Which statement should you use?

You have a table named Product that contains the following data.

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following statement:
INSERT INTO Product VALUES (3296, ‘Table’, 4444)

What is the result?

You have a table named Employee that includes the following columns:
EmployeeID
Smp1oyeeName
Which statement should you use to return the number of rows in the table?

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.
You need to change the ProductCategory value for all the spoons in the Product table to 43.
Which statement should you use?