Need help with SQL

 

QUESTION 1

 

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?

 

INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith';

 

INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');

 

INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith');

 

INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith';

 

INPUT INTO STUDENT (123, 'Jones', 'Smith');

 

 

QUESTION 2

 

The order of the columns returned by an SQL SELECT statement is determined by the:

 

ORDER BY clause.

 

 

SORT BY clause.

 

 

order they are listed in following SELECT.

 

 

order they are listed in following WHERE.

 

 

order they are listed in following FROM.

 

 

r

QUESTION 3

 

Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query?

 

 

UNIQUE

 

 

SORT

 

 

ORDER BY

 

 

DISTINCT

 

 

REDUCE

 

 

1 points  Save Answer

 

 

Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query?

 

 

SELECT

 

 

FROM

 

 

WHERE

 

 

ORDER BY

 

 

GROUP BY

 

 

Question 5

 

 

Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column?

 

 

WHERE Hours = MIN(10) and MAX(50)

 

 

WHERE Hours IN [10, 50]

 

 

WHERE Hours = 10 and Hours = 50

 

 

WHERE Hours BETWEEN 10 AND 50

 

 

WHERE Hours RANGE 10 TO 50

 

 

 

QUESTION 6

 

Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character?

 

 

% (percent sign)

 

 

! (exclamation mark)

 

 

_ (underscore)

 

 

? (question mark)

 

 

; (semi-colon)

 

 

 

QUESTION 7

 

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

 

 

% (percent sign)

 

 

! (exclamation mark)

 

 

_ (underscore)

 

 

? (question mark)

 

 

; (semi-colon)

 

 

 

QUESTION 8

 

Which SQL keyword can be used in conjunction with wildcards to select partial values?

 

 

SELECT

 

 

SEARCH

 

 

FIND

 

 

SUBSTRING

 

 

LIKE

 

r

QUESTION 9

 

Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?

 

 

SORT BY Department

 

 

REVERSE Department

 

 

ORDER BY Department DESC

 

 

SORT BY Department DESC

 

 

SORT BY Department REVERSE

 

 

QUESTION 10

 

Which of the following is not one of the five SQL built-in functions?

 

 

MODE

 

 

SUM

 

COUNT

 

MAX

 

AVG

 

QUESTION 11

 

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve the Name and Phone Number of customers?

 

 

SELECT CUSTOMER-Name AND CUSTOMER-PhoneNum

 

 

SELECT (CUSTOMER-Name AND CUSTOMER-PhoneNum

 

 

SELECT Name, PhoneNum

 

SELECT (Name, PhoneNum)

 

SELECT *

 

QUESTION 12

 

Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?

 

 

WHERE CUSTOMER-AcctBalance > 50

 

 

WHERE (CUSTOMER-AcctBalance > 50)

 

WHERE AcctBalance > 50

 

WHERE (AcctBalance > 50)

 

HAVING AcctBalance > 50

 

QUESTION 13

 

Which SQL keyword is used to apply conditions to restrict groups that appear in the results of a SELECT query that uses GROUP BY?

 

 

WHERE

 

HAVING

 

LIKE

 

SORT

 

DISTINCT

 

r

QUESTION 14

 

Given the tables STUDENT(StudentID, StudentName, AdvisorID) and ADVISOR(AdvisorID, AdvisorName, Office, Phone), which of the following SQL statements would be used to implant a join between the two tables?

 

 

WHERE STUDENT MATCH ADVISOR

 

WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID

 

WHERE STUDENT = ADVISOR

 

 

WHERE STUDENT JOIN ADVISOR

 

 

WHERE STUDENT.AdvisorID = ADVISOR.AdvisorID

 

 

QUESTION 15

 

Which of the following SQL commands would be used to remove only the data from a table named STUDENT while leaving the table structure intact?

 

 

DROP TABLE STUDENT;

 

DELETE TABLE STUDENT;

 

 

REMOVE TABLE STUDENT;

 

 

SELECT * FROM STUDENT THEN DROP;

 

 

DELETE FROM STUDENT;

 

r

QUESTION 16

 

The SQL keyword(s) ________ mean(s) that a value must be supplied before a new row can be created.

 

 

 

QUESTION 17

 

The SQL command used to add new data to a table is ________.

 

 

 

 

QUESTION 18

 

The values of existing data can be modified using the SQL ________ command, which can be used to change several column values at once.

 

 

 

QUESTION 19

 

The values of existing data can be removed from a table using the SQL ________ command, which can even be used to remove all the data in the table at one time.

 

 

 

QUESTION 20

 

A complete table, including both the table structure and any data in the table, can be removed from the database by using the SQL ________ command.

 

 

 

QUESTION 21

 

Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

 

 

QUESTION 22

 

Given the table CUSTOMER(CustID, Name, PhoneNumber, AccountBalance), write the standard SQL query to retrieve the Name and Phone Number of customers whose name begins with 'S'.