Conditions after the WHERE clause require single quotes around the values for co

Question

Conditions after the WHERE clause require single quotes around the values for columns that have which type of data

money

integer

char (character or text)

data that includes a special character such as a ?, ", etc.

all data in a where clause must be included in single quotes

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

order they are listed in following the SELECT keyword.

SORT BY clause.

order they are listed in following the FROM keyword.

order they are listed in following the WHERE keyword.

In an SQL query, which built-in function is used to compute the number of rows in a table?

Question 13 options:

COUNT

ROWS

AVG

MAX

SUM

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Which of the SQL statements is correct:

SELECT LastName AND FirstName FROM CUSTOM

SELECT LastName,FirstName FROM CUSTOMER WHERE LastName = Smith

SELECT LastName('Smith'),FirstName('John') FROM CUSTOMER

SELECT LastName,FirstName FROM CUSTOMER

Which of the following SQL statements will create a VIEW named STUDENTGRADES?

CREATE VIEW STUDENTGRADES AS SELECT StudentName, StudentGrade FROM STUDENT

CREATE VIEW STUDENTGRADES FROM STUDENT AS (StudentName, StudentGrade)

SELECT StudentName, StudentGrade FROM STUDENT AS STUDENTGRADES

SELECT VIEW STUDENTGRADES AS StudentName, StudentGrade

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid SQL command?

SELECT COUNT(*) FROM EMPLOYEE WHERE Salary < 30000;

SELECT HireDate, COUNT(*) FROM EMPLOYEE GROUP BY HireDate;

SELECT COUNT(EmpNo) FROM EMPLOYEE;

SELECT HireDate, COUNT(*) FROM EMPLOYEE WHERE Salary < 30000;

The result of a SELECT statement is a _______________.

report

file

form

table

Save

Which of the following statements will remove and eliminate the Vehicles table.

REMOVE VEHICLES;

DROP TABLE VEHICLES;

DELETE * FROM VEHICLES;

DELETE FROM VEHICLES;

DROP VEHICLES;

With SQL, how can you insert 100 as the Quantity in the table INVENTORY(ItemID, Description,Price,Quantity)

Question 20 options:

INSERT (100) INTO INVENTORY(Quantity)

INSERT INTO INVENTORY (100) INTO Quantity

INSERT INTO INVENTORY (Quantity) VALUES (100)

INSERT INTO INVENTORY Quantity = 100

money

integer

char (character or text)

data that includes a special character such as a ?, ", etc.

all data in a where clause must be included in single quotes

Explanation / Answer

According to chegg guideline i have to solve first four bits only but i solve 5

1.

Conditions after the WHERE clause require single quotes around the values for columns that have char type of data.

Option 3

2.

The order of the columns returned by an SQL SELECT statement are determined by the order they are listed in following SELECT.

Option 1

3.

In an SQL query, COUNT built-in function is used to compute the number of rows in a table

Option 1

4.

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

True

5.

SELECT LastName,FirstName FROM CUSTOMER WHERE LastName = Smith

SELECT LastName,FirstName FROM CUSTOMER

Option 2 and 4

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.