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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

51 questions

Roblox (Big quizizz)

Quiz

•

Professional Development

50 questions

Empowerment Technology Summative #1

Quiz

•

Professional Development

45 questions

Mongolian Culture and Traditions Quiz

Quiz

•

Professional Development

50 questions

Ayurveda Itihas.

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Education

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

100 questions

Screening Test Customer Service

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

10 questions

Reading a ruler in Inches

Quiz

•

4th Grade - Professio...

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

12 questions

Valentines Day Trivia

Quiz

•

Professional Development

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