Blog

NCVS measures:

Whom does Woolf claim to have killed in “Professions for Women”?

A primary key for a table can have duplicate values within that table. 

(true OR false) AND true

  Select all products that cost more than 10 dollars.  Sort results by SupplierID descending and then quantity descending. 

Consider the below create table statement: CREATE TABLE Employees (EmpID INT PRIMARY KEY,FirstName VARCHAR(50) NOT NULL,MiddleName VARCHAR(50),LastName VARCHAR(50) NOT NULL,Fax VARCHAR(12),Email VARCHAR(75) NOT NULL);   Which fields cannot be left empty.  Check all that apply. 

Consider the above table.   Which query would select only FacultyName and Salary from the table?

  Consider the above table.  If I wanted to remove all faculty from department 3 from the table which of the below queries would I use?

  Consider the above table.   Which query would select all the products that are supplier 1 and have a quantity of at least 20. 

Consider the above table. Which of the below queries would select all faculty whose named ended with the letter ‘n’