With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT * FROM Persons WHERE FirstName LIKE 'Peter'

SELECT [all] FROM Persons WHERE FirstName='Peter'

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

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

SELECT*FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

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

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

SELECT [all] FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

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

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

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

INSERT INTO Persons (LastName) VALUES ('Olsen')

INSERT ('Olsen') INTO Persons (LastName)

INSERT INTO Persons ('Olsen') INTO LastName

INSERT IN Persons ('Olsen') TO LastName

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

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

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

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName=’%a%’

CREATE TABLE employee (id INTEGER ,name VARCHAR (20),salary NOT NULL ); INSERT INTO employee VALUES (1005,Rach,0); INSERT INTO employee VALUES (1007,Ross, ); INSERT INTO employee VALUES (1002,Joey,335); Some of these insert statements will produce an error. Identify the statement.

Insert into employee values (1007,Ross, );

Insert into employee values (1005,Rach,0);

Insert into employee values (1002,Joey,335);

The SQL WHERE clause:

limits the row data that are returned.

limits the column data that are returned.

How can you change 'Thomas' to 'Michael' in the LastName column in the user table

UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

SQL query to find all the cities whose humidity is 95.

SELECT city FROM weather WHERE humidity = 95

SELECT city WHERE humidity = 95

SELECT humidity = 89 FROM weather

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)

SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);

What is the difference between WHERE and HAVING?

HAVING only applies to aggregate functions like GROUP BY

WHERE specifies a GEOGRAPHIC location for a database server

It is faster, safer and better practice to not allow general access to the production database

You should not, they are inefficient

"View" is simply a synonym for the return of the SELECT function

ORDER BY specifies ...................................

how the data is organized (sorted) when it is retrieved.

the criteria you need to find the information

the table(s) that contain(s) the information

the information you want to find within the database

Given the following SQL query, what will be the result of the subquery? SELECT * FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);

All employees with salaries greater than the average

All employees with salaries less than the average

Which query returns the total sales amount for each product but includes only products where the total sales exceed $1000?

SELECT product_id, SUM(amount) FROM sales GROUP BY product_id HAVING SUM(amount) > 1000;

SELECT product_id, COUNT(amount) FROM sales GROUP BY product_id HAVING COUNT(amount) > 1000;

SELECT product_id, SUM(amount) FROM sales WHERE SUM(amount) > 1000 GROUP BY product_id;

SELECT product_id, SUM(amount) FROM sales GROUP BY product_id WHERE SUM(amount) > 1000;

Which SQL query will return the second-highest salary from the employees table?

SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);

SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

SELECT MAX(salary) FROM employees ORDER BY salary DESC LIMIT 1, 1;

SELECT salary FROM employees WHERE salary < MAX(salary);

Which of the following statements are true?

INNER JOIN only retrieves those rows from Cartesian Product that satisfy the JOIN condition

FULL OUTER JOIN is same as CROSS JOIN

SELF JOIN is a special type of OUTER JOIN

Quiz on SQL

Authored by Dr. Sharma

Computers, Engineering

Professional Development

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

45 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

The language used application programs to request data from the DBMS is referred to as __________

DDL

DML

Query Language

All of the mentioned

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is not a type of SQL statement?

Data Manipulation Language (DML)

Data Definition Language (DDL)

Data Control Language (DCL)

Data Communication Language (DCL)

MULTIPLE CHOICE QUESTION

1 min • 1 pt

In existing table, ALTER TABLE statement is used to

Add columns

Add constraints

Delete columns

Delete constrains

All the above

MULTIPLE CHOICE QUESTION

1 min • 1 pt

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

DELETE FROM table_name;

DELETE TABLE table_name;

DROP TABLE table_name;

None

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Correct syntax query syntax to drop a column from a table is

DELETE COLUMN column_name;

DROP COLUMN column_name;

ALTER TABLE table_name DROP COLUMN column_name;

None is correct.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which command is used for removing a table and all its data from the database:

Create command

Drop table command

Alter table command

All of the mentioned

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following language is used to specify database Schema ?

DDL

DML

DCL

None

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

47 questions

MS 900 Review Exam

Quiz

•

Professional Development

43 questions

Azure Quiz 1b

Quiz

•

Professional Development

40 questions

แบบทดสอบคอมพิวเตอร์

Quiz

•

Professional Development

44 questions

IMI G0102k Health and Safety Quiz

Quiz

•

Professional Development

50 questions

Kompetensi Keahlian TKJ

Quiz

•

Professional Development

50 questions

Ujian TIK

Quiz

•

Professional Development

50 questions

Test Mendix 4

Quiz

•

Professional Development

40 questions

Motherboards

Quiz

•

Professional Development

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

22 questions

School Wide Vocab Group 1 Master

Quiz

•

6th - 8th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

12 questions

What makes Nebraska's government unique?

Quiz

•

4th - 5th Grade

Discover more resources for Computers

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

20 questions

NCAA Logo Quiz

Quiz

•

Professional Development

20 questions

Easter trivia

Quiz

•

12th Grade - Professi...

Quiz on SQL

The language used application programs to request data from the DBMS is referred to as __________

Which of the following is not a type of SQL statement?

In existing table, ALTER TABLE statement is used to

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

Correct syntax query syntax to drop a column from a table is

Which command is used for removing a table and all its data from the database:

Which of the following language is used to specify database Schema ?

Which SQL statement is used to delete data from a database?

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

Which SQL statement is used to insert new data in a database?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers