How would you DELETE records from the Items table with a "Chair" Type?

DELETE FROM Items WHERE Type = 'Chair'

DELETE Type FROM Items WHERE Type = 'Chair'

DELETE FROM Items WHERE Type = 'Chair'

DELETE ITEMS WHERE Type = 'Chair'

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

Which query would return only the fields DesignerID and Designer?

SELECT DesignerID, Designer FROM Designers

SELECT DesignerID, Name FROM Designers

SELECT DesignerID AND Designer FROM Designers

SELECT DesignerID, Designer FROM Designers

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

SELECT * FROM Items WHERE Price > 50

Sql Server Class 9 MCQ Questions With Answers Quiz

1.

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'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

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

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

1.

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

2.

Which character returns all the data found in a table?

3.

How do we select all rows for the "Designer" table?

4.

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

5.

How would you DELETE records from the Items table with a "Chair" Type?

6.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

7.

Which query would return only the fields DesignerID and Designer?

8.

What is the correct order of clauses in a SQL statement?

9.

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

10.

To remove a record from a table which SQL statement would you use?

11.

In order to amend data in a database we would use which SQL statement?

12.

How would you display Chairs in the Items table that have a Price greater than £50.

13.

Using which word allows you to specify that more than one condition must be met in a query?

14.

How would we script a SQL query to select "Description" from the Item table?

Time

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

2. Which character returns all the data found in a table?

3. How do we select all rows for the "Designer" table?

4. Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

5. How would you DELETE records from the Items table with a "Chair" Type?

6. With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

7. Which query would return only the fields DesignerID and Designer?

8. What is the correct order of clauses in a SQL statement?

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

10. To remove a record from a table which SQL statement would you use?

11. In order to amend data in a database we would use which SQL statement?

12. How would you display Chairs in the Items table that have a Price greater than £50.

13. Using which word allows you to specify that more than one condition must be met in a query?

14. How would we script a SQL query to select "Description" from the Item table?

Time

Report Question

Support mcqmojo.com by disabling your adblocker.

1.

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

2.

Which character returns all the data found in a table?

3.

How do we select all rows for the "Designer" table?

4.

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

5.

How would you DELETE records from the Items table with a "Chair" Type?

6.

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

7.

Which query would return only the fields DesignerID and Designer?

8.

What is the correct order of clauses in a SQL statement?

9.

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

10.

To remove a record from a table which SQL statement would you use?

11.

In order to amend data in a database we would use which SQL statement?

12.

How would you display Chairs in the Items table that have a Price greater than £50.

13.

Using which word allows you to specify that more than one condition must be met in a query?

14.

How would we script a SQL query to select "Description" from the Item table?