You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

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

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

Which of the following statements contains an error?

Select empid where empid = 1009 and lastname = ‘GELLER’;

Select * from emp where empid = 10003;

Select empid from emp where empid = 10006;

SELECT * FROM sales WHERE amount > 200.

the query will display all the sales records with amounts greater than 200

the query will display all the sales records with amounts starting from 200 and above

the query will display all the sales records with amounts less than 200

the query will output sales records with the amount equal to 200.

Which of the following query will print all the order number, amount, company name and credit limit of the customers?

SELECT Order_no, amt, company_name, cred_limit FROM Customers INNER JOIN Orders ON Customers.custID=Orders.custID;

SELECT Order_no, amt, company_name, cred_limit FROM Customers FULL OUTER JOIN Orders ON Customers.custID=Orders.custID;

SELECT Order_no, amt, company_name, cred_limit FROM Customers RIGHT OUTER JOIN Orders ON Customers.custID=Orders.custID;

SELECT Order_no, amt, company_name, cred_limit FROM Customers LEFT OUTER JOIN Orders ON Customers.custID=Orders.custID;

Which query can be used to get the above result?

SELECT e.fname as employee, m.fname as manager FROM emp e INNER JOIN emp m ON e.manager_id=m.empno;

SELECT e.fname as employee, m.fname as manager FROM emp1 e INNER JOIN emp2 m ON e.manager_id=m.empno;

SELECT e.fname as employee, m.fname as manager FROM emp2 e INNER JOIN emp1 m ON e.manager_id=m.empno;

SELECT e.fname as employee, m.fname as manager FROM emp e, emp m ON e.manager_id=m.empno;

Which of the following are true with respect to joins?

Columns used in the joins must have compatible data types

Cross join without a WHERE clause returns a cartesian product

Which of the following conditions has to be satisfied for INNER JOIN to work?

Columns used for joining can have same or different name

Columns used for joining must have different names

Columns used for joining must have same name

Columns used for joining can be of different types

Which of the following statement/s are false?

FULL OUTER JOIN is same as CROSS JOIN

SELF JOIN is a special type of OUTER JOIN

RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed

Which of the following SQL statements will retrieve only the records where there is a match between the Customers and Orders tables?

SELECT * FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

SELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

SELECT * FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

How would you modify the following query to display the total number of orders placed by each customer? SELECT Orders.OrderID, Orders.OrderDate, Customers.CustomerName, Customers.Country FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

Add a COUNT function and GROUP BY CustomerName

Add a GROUP BY clause to group by CustomerName

Add a DISTINCT function and GROUP BY OrderID

Add a COUNT function and GROUP BY OrderDate

DBMS SQL

Authored by M. Khandwani

Computers

University

Used 7+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

30 questions

Show all answers

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which statement allows us to add a record to a table?

Add To

Update To

Add Into

Insert Into

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Where does the CREATE Command belong?

DML

DDL

DCL

MULTIPLE SELECT QUESTION

1 min • 1 pt

select all DDL commands are:-

UPDATE

ALTER

DROP

DELETE

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

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 SQL statement would add a record to the database?

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer

INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer

INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

MULTIPLE CHOICE QUESTION

1 min • 1 pt

This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.

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

25 questions

AITECH_1

Quiz

•

University

25 questions

IAS 2 Identity and Access Management Q5

Quiz

•

University

26 questions

IM2 DDL

Quiz

•

University

25 questions

Introduction to Computer System

Quiz

•

University

26 questions

Entrepreneurship

Quiz

•

4th Grade - Professio...

25 questions

HCI - Test Revision

Quiz

•

University

25 questions

Quiz on Cognitive Aspects

Quiz

•

University

25 questions

Quiz No. 2 - The Process of Interaction Design

Quiz

•

University

Popular Resources on Wayground

16 questions

Grade 3 Simulation Assessment 2

Quiz

•

3rd Grade

19 questions

HCS Grade 5 Simulation Assessment_1 2526sy

Quiz

•

5th Grade

10 questions

Cinco de Mayo Trivia Questions

Interactive video

•

3rd - 5th Grade

17 questions

HCS Grade 4 Simulation Assessment_2 2526sy

Quiz

•

4th Grade

24 questions

HCS Grade 5 Simulation Assessment_2 2526sy

Quiz

•

5th Grade

13 questions

Cinco de mayo

Interactive video

•

6th - 8th Grade

20 questions

Math Review

Quiz

•

3rd Grade

30 questions

GVMS House Trivia 2026

Quiz

•

6th - 8th Grade

Discover more resources for Computers

55 questions

Post Malone Addtion (Tres)

Quiz

•

12th Grade - University

20 questions

Disney Trivia

Quiz

•

University

50 questions

AP Biology Exam Review 2017

Quiz

•

11th Grade - University

24 questions

5th Grade Math EOG Review

Quiz

•

KG - University

12 questions

Star Wars Trivia - Easy

Quiz

•

KG - University

215 questions

8th Physical Science GA Milestones Review

Quiz

•

KG - University

40 questions

Famous Logos

Quiz

•

7th Grade - University

14 questions

(5-3) 710 Mean, Median, Mode & Range Quick Check

Quiz

•

6th Grade - University

DBMS SQL

Which statement allows us to add a record to a table?

Where does the CREATE Command belong?

select all DDL commands are:-

In existing table, ALTER TABLE statement is used to

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

Which SQL statement would add a record to the database?

This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.

You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers