Question 1

Arrange the correct SQL statement to create a new database called testDB

Accepted Answer

create ,database, testDB;

Question 2

The following SQL statement selects the "CustomerName" and "City" columns from the "Customers" table:

Accepted Answer

SELECT ,CustomerName, City ,FROM, Customers;

Question 3

The following SQL statement finds the sum of the "Quantity" fields in the "OrderDetails" table:

Accepted Answer

SELECT ,SUM(Quantity) ,FROM ,OrderDetails;

Question 4

The following SQL statement returns the cities (only distinct values) from both the "Customers" and the "Suppliers" table:

Accepted Answer

SELECT City, FROM ,Customers,UNION,SELECT City ,FROM ,Suppliers,ORDER BY, City;

Question 5

the following SQL statement update the ContactName to "Juan" for all records where country is "Mexico":

Accepted Answer

UPDATE, Customers,SET, ContactName='Juan',WHERE ,Country='Mexico';

Question 6

The following SQL statement selects all customers with a CustomerName that have "or" in any position:

TableName:Customers

Accepted Answer

SELECT * ,FROM, Customers,WHERE, CustomerName, LIKE ,'%or%';

Question 7

The following SQL statement selects all products with a price between 10 and 20. In addition; do not show products with a CategoryID of 1, 3:

TableName: Products

Accepted Answer

SELECT *, FROM ,Products,WHERE ,Price ,BETWEEN ,10 AND 20,AND ,CategoryID ,NOT IN, (1,3);

Question 8

The following SQL creates a PRIMARY KEY on the "ID" column when the "Persons" table is created:

Accepted Answer

CREATE ,TABLE ,Persons ,( ID int NOT NULL ,PRIMARY KEY, FirstName, varchar(25), Age int);

Question 9

The following SQL statement selects all customers that are located in "Germany", "France" or "UK":

Table name: Customers

Accepted Answer

SELECT ,* ,FROM ,Customers,WHERE, Country, IN ,('Germany', 'France', 'UK');

Question 10

The following SQL adds an "Email" column to the "Customers" table:

Accepted Answer

ALTER, TABLE ,Customers,ADD, Email, varchar(30);

Related quizzes