You query the table with this commandSELECT nameFROM employeeWHERE name LIKE '_a%'; Which names are displayed?

Names containing “a” as second character

Names containing “a” as any letter except the first

Names starting with “a” or “A”

How does a TRUNCATE TABLE statement differ from an unrestricted DELETE? Select all that apply.

Using TRUNCATE all the values in the table will be deleted but not the structure whereas as In Delete a particular row can be deleted but not the structure

Using TRUNCATE all the values in the table will be deleted and the structure as well but whereas as In Delete a particular row can be deleted but not the structure

Using TRUNCATE all the values in the table will be deleted but not the structure whereas as In Delete a particular row can be deleted and the structure as well

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

DELETE ROW FirstName='Peter' FROM Persons

DELETE Persons WHERE FirstName = 'Peter'

Which of the following statements contains an error?

SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

SELECT * FROM emp WHERE empid = 493945;

SELECT empid FROM emp WHERE empid= 493945;

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

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

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

Choose correct syntax to insert values into r4r_team table

INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);

INSERT IN r4r_team VALUES (1, ‘r4r01’, ‘2’);

INSERT INTO r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

INSERT INTO table r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

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

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

INSERT INTO Persons ('Olsen') INTO LastName

INSERT ('Olsen') INTO Persons (LastName)

INSERT IN Persons ('Olsen') INTO LastName

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 Persons values ('Jimmy', 'Jackson')

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

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 LIKE 'a%'

SELECT FROM Persons WHERE FirstName='%a%'

SELECT FROM Persons WHERE FirstName LIKE '%a'

SELECT FROM Persons WHERE FirstName='a'

With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

DELETE FROM Persons WHERE FirstName = 'Peter'

DELETE FirstName='Peter' FROM Persons

DELETE ROW FirstName='Peter' FROM Persons

The FROM SQL clause is used to…

Specify what table we are selecting or deleting data from.

Specify range for search condition

Which of the following SQL statements is correct?

SELECT CustomerName, COUNT(CustomerName) FROM Orders GROUP BY CustomerName

SELECT CustomerName, COUNT(CustomerName) FROM Orders

SELECT CustomerName, COUNT(CustomerName) FROM Orders ORDER BY CustomerName

Which of the following 3 SQL statements is correct?

SELECT Username, Password FROM Users

SELECT Username AND Password FROM Users

SELECT Username, Password WHERE Username = 'user1'

What does follow after the SQL WHERE clause?

Definition of the condition to be met for the rows to be returned.

A list of columns to be selected.

The name of the table we are selecting from.

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.

What is the purpose of the SQL AS clause?

The AS SQL clause is used change the name of a column in the result set

The AS clause is used with the JOIN clause only.

The AS clause defines a search condition.

The IN SQL keyword…

Determines if a value matches any of the values in a list or a sub-query.

Is used with the DISTINCT SQL keyword only.

Defines the tables we are selecting or deleting data from

The UPDATE SQL clause can…

Update more than one row at a time.

Delete more than one row at a time.

Delete only one row at a time..

SQL Fundamentals_Amr

Authored by Amr Alengbawy

Education

Professional Development

Used 36+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What does SQL stand for?

Structured Query Language

Standard Query Language

Strong Query Langauge

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

EXTRACT

Get

OPEN

SELECT

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which SQL statement is used to update data in a database?

MODIFY

SAVE AS

UPDATE

SAVE

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

Modify

DELETE

MOVE

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

ADD RECORD

INSERT NEW

INSERT INTO

ADD NEW

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

_______used to Create, Manage database objects in the database.

DDL

DML

DCL

DQL

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

You issue the following query: SELECT empno, ename FROM emp WHERE empno = 7782 OR empno = 7876; Which other operator can replace the OR condition in the WHERE clause

BETWEEN.. AND..

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

54 questions

St.JOSEPH'S CISCO IDEATHON ROUND 1 ONLINE ASSESSMENT @ 23/6/24

Quiz

•

Professional Development

51 questions

Trial Test pt 1

Quiz

•

Professional Development

50 questions

Cho Xuan Kosa kata 3-1-2025

Quiz

•

Professional Development

52 questions

Exam for Selection of NCC Cadets for 2020-23

Quiz

•

Professional Development

45 questions

TDES Evaluation Quiz

Quiz

•

Professional Development

50 questions

SOAL UJIAN RATING D VERSI 2

Quiz

•

Professional Development

53 questions

HỘI THI NÂNG CAO NĂNG LỰC TIẾNG ANH CHO ĐOÀN VIÊN/ HỌC SINH

Quiz

•

Professional Development

Popular Resources on Wayground

5 questions

A Home on the Shore

Quiz

•

3rd Grade

28 questions

US History Regents Review

Quiz

•

11th Grade

6 questions

A Horse Tale

Quiz

•

3rd Grade

20 questions

Math Review

Quiz

•

3rd Grade

10 questions

Juneteenth History and Significance

Interactive video

•

5th - 8th Grade

20 questions

Dividing Fractions

Quiz

•

5th Grade

55 questions

A Long Walk to Water Final Review

Quiz

•

6th - 8th Grade

10 questions

Equation Word Problems

Quiz

•

7th Grade

Discover more resources for Education

40 questions

Flags of the World

Quiz

•

KG - Professional Dev...

SQL Fundamentals_Amr

What does SQL stand for?

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

Which SQL statement is used to update data in a database?

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

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

_______used to Create, Manage database objects in the database.

You issue the following query: SELECT empno, ename FROM emp WHERE empno = 7782 OR empno = 7876; Which other operator can replace the OR condition in the WHERE clause

Roll Back segment is not used in case of:

You query the table with this commandSELECT nameFROM employeeWHERE name LIKE '_a%'; Which names are displayed?

How does a TRUNCATE TABLE statement differ from an unrestricted DELETE? Select all that apply.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Education