×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operation is called a/an:
SELECT EmployeeID, FirstName, DepartmentName
FROM Employee, Department
This type of operation is called a/an:
2.
Which command should you use to add a column to an existing table?
3.
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?
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?
4.
You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?
5.
You execute the following statement: This statement is an example of a/an:
6.
Which keyword would you use in a select statement to return rows that meet a specific condition?
7.
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 execute the following statement:
SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?
8.
Which command should you use to remove a table from a database?
9.
You need to store the contact information for each student in your school database. You should store each student's information in a:
10.
Which category of SQL statements is used to add, remove, and modify database structures?