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

SQL Quiz: 25 MCQs on the Student Table

Quiz

•

University

25 questions

Logical Thinking and MS Word Quiz

Quiz

•

5th Grade - University

25 questions

soal semester 1 kelas 9

Quiz

•

9th Grade - University

25 questions

QUIZ

Quiz

•

University

25 questions

QUIZ PRA UAS_PTIK-PERTEMUAN 15

Quiz

•

University

31 questions

Basic Computer Skills-Northstar

Quiz

•

University

25 questions

Quiz Project Management - IS

Quiz

•

University

25 questions

Phishing Awareness Quiz 2

Quiz

•

6th Grade - University

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

$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

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

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