SQL statement to verify the updated name field for the publisher with ID 5 SELEC

Question

SQL statement to verify the updated name field for the publisher with ID 5 SELECT * FROM Publisher WHERE PubID=5;

Question 1 options:

Save

Question 2 (1 point)

SQL statement to make the following update to the Publisher table: Phone=888-999-7777 for TEXT AND MORE. UPDATE Publisher SET PubName='TEXT AND MORE' WHERE Phone = '888-999-7777';

Question 2 options:

Save

Question 3 (1 point)

SQL statement to identify the book written by an author with the last name Stewart. Perform the search by using the author name SELECT Title FROM Books WHERE Author LIKE '*Stewart';

Question 3 options:

Save

Question 4 (1 point)

SQL statement to display a list of all the books in the Books table. If a customer has ordered a book, list the corresponding order number and the state in which the customer resides: SELECT Title, Books.ISBN, Orders.ISBN, Customers.CustomerID, Orders.customerID, state FROM Books, Customers, Orders WHERE Customers.CustomerID=Orders.customerID Or Books.ISBN=Orders.ISBN;

Question 4 options:

Save

Question 5 (1 point)

SQL statement to list the customer numbers and names of all the individuals who have purchased books in the children category First define CustomerOrders as follows: CustomerOrders: SELECT Customers.CustomerID, Orders.CustomerID, LastName, FirstName, Category, Books.ISBN, Orders.ISBN FROM Books, Customers, Orders WHERE Customers.CustomerID=Orders.CustomerID And Books.ISBN=Orders.ISBN; Then specify: SELECT Customers.CustomerID, LastName, FirstName, Category FROM CustomerOrders WHERE Category='Children';

Question 5 options:

Explanation / Answer

ANSWER 1: It is true because this query gives you the data of all records who has the id =5.

ANSWER 2: It is true, this is the correct query.

ANSWER 3: It is false in the LIKE it should be '%Stewart%'.

ANSWER 4: It is true.

ANSWER 5: It is also true.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.