Cram.com Is A Terrible Website

Front 1

What type of SQL field creates a value of the primary key field automatically every time a new record is inserted?

Back 1

Auto_Increment

Front 2

What operator is used to search for a specified pattern in a column?

Back 2

Like

Front 3

what type of JOIN returns all rows from table1, with the matching rows in table2 -- FROM table1 _______________ table2 ON table1.column_name=table2.column_name?

Back 3

Left Join

Front 4

What type of JOIN selects all rows from two tables as long as there is a match between the columns in both tables?

Back 4

Inner Join

Front 5

The GROUP BY statement is used in conjunction with what type of functions to group the result-set by one or more columns?

Back 5

Aggregate functions (ex: min, max, sum, avg, count)

Front 6

What type of JOIN returns all rows from Customers and from Orders -- FROM Customers ______________ Orders ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CustomerName;?

Back 6

Full Outer Join

Front 7

What SQL operator combines the result of two or more SELECT statements?

Back 7

Union

Front 8

What is the SQL statement to select all customers with a City of "Paris" or "London"?

Back 8

SELECT *

FROM Customers

WHERE City IN (‘Paris’, ‘London’);

SELECT *

FROM Customers

WHERE City = ‘Paris’ OR City = ‘London’

Front 9

If you want to create aliases for the tables Customers and Orders in a SELECT query where Customers.CustomerID=Orders.CustomerID, how would you write the query?

Back 9

SELECT o.OrderID, o.OrderDate, c.CustomerName

FROM Customers AS c, Orders AS o

WHERE c.CustomerID=o.CustomerID;

Front 10

What constraint ensures that a field always contains a value?

Back 10

Not Null

Front 11

What is the SQL syntax to copy all columns of a table into a backup table?

Back 11

SELECT *

INTO newtable [IN externaldb]

FROM table1;

Front 12

What is the SQL statement to select the product name and the price rounded to the nearest integer from the "Products" table?

Back 12

SELECT ProductName, ROUND(Price,0) AS RoundedPrice

FROM Products;

Front 13

What values can be used for the range specified with the BETWEEN operator?

Back 13

Anything in the table, if there’s a null then it returns null

Front 14

What is the SQL statement to select the product name and price for today from the "Products" table?

Back 14

SELECT ProductName, Price, Now AS PerDate

FROM Products;

Front 15

What function returns the number of records in a table?

Back 15

COUNT

Front 16

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Joe" and the "LastName" is "Blow"?

Back 16

SELECT *

FROM Persons

WHERE FirstName = ‘Joe’ AND LastName = ‘Blow’;

Front 17

With SQL, how do you select all the records from a table named "Persons"?

Back 17

SELECT *

FROM Persons;

Front 18

In a table, a column may contain many duplicate values; and you want to list only the different values, what is the SQL syntax?

Back 18

SELECT DISTINCT columnname, columnname

FROM table;

Front 19

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Jones" and "Smith" ?

Back 19

SELECT *

FROM Persons

WHERE LastName BETWEEN ‘Jones’ AND ‘Smith’;

Front 20

Can you use both HAVING and WHERE SQL clauses in a single SQL statement?

Back 20

Yes if you want to filter out individual rows before grouping them, start with where and then use a group by statement and having clause

Front 21

Which SQL statement selects all rows from a table called Products and orders the result set by ProductID column?

Back 21

SELECT *

FROM ProductsORDER BY ProductID;

Front 22

Which SQL keyword is used to retrieve the greatest/highest value?

Back 22

MAX

Front 23

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

Back 23

SELECT *

FROM Persons ORDER BY FirstName DESC;

Front 24

When does the OR operator displays a record?

Back 24

First condition

OR

Second condition is true

Front 25

Which SQL statement is used to return only different values?

Back 25

SELECT DISTINCT

Front 26

Which SQL keyword is used to sort the result-set?

Back 26

ORDER BY

Front 27

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

Back 27

INSERT INTO Persons (LastName)VALUES (‘Olsen’);

Front 28

With SQL, how can you insert a new record into the "Persons" table?

Back 28

INSERT INTO Persons (column1, column2)

VALUES (value1, value2);

Front 29

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

Back 29

UPDATE Persons SET LastName = ‘Nilsen’

WHERE LastName = ‘Hansen’;