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

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 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

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

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

SELECT * FROM employee WHERE salary>10000 AND dept_id=101; Which of the following fields are displayed as output?

All the field of employee relation

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);

SQL Quiz

Authored by Neeraj Varshney

Computers

University

Used 254+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

19 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is a ‘tuple’?

A row or record in a database table

Another name for the key linking different tables in a database.

An attribute attached to a record.

Another name for a table in an RDBMS.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

The command to remove rows from a table ‘CUSTOMER’ is:

REMOVE FROM CUSTOMER …

DROP FROM CUSTOMER …

DELETE FROM CUSTOMER WHERE …

UPDATE FROM CUSTOMER …

MULTIPLE CHOICE QUESTION

1 min • 1 pt

The command to eliminate a table from a database is:

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included

ONLY

UNIQUE

DISTINCT

SINGLE

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

SELECT [all] FROM Persons

SELECT Persons

SELECT * FROM Persons

SELECT *.Persons

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

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

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

SELECT * FROM Persons WHERE FirstName='Peter'

SELECT * FROM Persons WHERE FirstName<>'Peter'

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

SELECT * FROM Persons WHERE FirstName LIKE '%a'

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 Microsoft

or continue with

Facebook

Apple

Others

Already have an account?

Similar Resources on Wayground

15 questions

Object Oriented Programming Assessment 1

Quiz

•

University

16 questions

Subprograms and ADT

Quiz

•

University

15 questions

Fundamentals of Algorithms - Unit 1 - Test 1

Quiz

•

University

19 questions

DBMS - Fundamentals

Quiz

•

University

15 questions

PICMAKER

Quiz

•

University

17 questions

Kiến thức về trang tính

Quiz

•

7th Grade - University

17 questions

Routing and Networking Quiz

Quiz

•

University

15 questions

8051-MCQ

Quiz

•

University

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade