Which answer is NOT a type of table index?
The keywords AND, IN, LIKE, and between all belong to a category called what?
What is the result of this series of statements?
SELECT 'Foo' AS Result;
SELECT 'Bar' AS Result;
Given these two tables, which query generates a listing showing student names and the department office location where you could reach each student?
What is an example of a DDL command in SQL?
Given the Games table pictured, which query generates the results shown?
Which answer is a possible result of the sequence of commands below?
DECLARE @UniqueID uniqueidentifier = NEWID();
SELECT @UniqueID AS Result;
You need to find all students that are not on the "Chemistry Cats" team. Which query does NOT work for this task?
You need to write a query that returns all Employees that have a LastName starting with the letter A. Which WHERE clause should you use to fill in the blank in this query?
Which query shows the first name, department, and team of all students with the two lowest points?
What is the result of this statement?
Which is the best approach to update the last name of the student Donette Figgins to Smith
Which of these data types is an approximate numeric?
You need to remove all data from a table name Products. Which query fully logs the removal of each record?
What is the result of the following query? SELECT 1 / 2 AS Result;
which data type will most efficiently store a person's age in years?
What is the result of this query?
def' AS Result;
To select a random student from the table, which statement could you use?
What result is returned after executing the following commands?
DECLARE @MyVariable int;
SET @MyVariable = 1;
Which statement creates a new database schema named Sales and establish Sharon as the owner?
The result of a CROSS JOIN between a table with 4 rows, and one with 5 rows, will give with ____ rows.
You need to write a query that returns all products that have a SerialNumber ending with "10_3". Which WHERE clause should you use to fill in the blank in this query?
SELECT ProductID, ProductName, SerialNumber
FROM Products______ ;
When no join type between multiple tables in a query's FROM clause is specified, what type of join is assumed?
How many bytes of storage does the int data type consume?
What does a RIGHT JOIN ensure?
You execute the following three queries. What is the result?
Create table students(id int identity(1000,1), firstname varchar(20),
insert into students(firstname,lastname)values('mark','twain');
select \*from students;
Which Query returns all student names with the highest grade?
create table students( studentname varchar(50), grade int);
What role does "inventory" play?
select bookid, boooktitle, bookauthor,quantityonhand from inventory.books;