Other
INF3707 Assignment 4 memo 2024
- Institution
- University Of South Africa (Unisa)
INF3707 Assignment 4 memo 2024
[Show more]
Content preview
UNISA 2024 INF3707-24-Y Welcome Message Assessment 4QUIZ
Started on Thursday, 5 September 2024, 6:27 PM
State Finished
Completed on Thursday, 5 September 2024, 7:17 PM
Time taken 49 mins 55 secs
Grade 80.00 out of 100.00
Question 1
Complete
Mark 4.00 out of 4.00
The user Alice wants to grant all users query privileges on her Orders table. Which SQL statement accomplishes this?
a. Grant select on Orders to all_users
b. Grant select on Orders to_all
c. Grant query on Orders to_public
d. Grant select on Orders to public
Question 2
Complete
Mark 4.00 out of 4.00
Which of the following will display the new retail price of each book as 20 percent more than its originally cost?
a. SELECT title, retail*.2 "New Retail Price" FROM books
b. SELECT title, retail+.20 "New Retail Price" FROM books
c. SELECT title, cost*.20 "New Retail Price" FROM books
d. SELECT title, cost*1.20 "New Retail Price" FROM books
, Question 3
Complete
Mark 4.00 out of 4.00
What does the following query?
SELECT isbn, title FROM books
WHERE (pubid, category) IN
(SELECT pubid, category
FROM books WHERE title LIKE ‘%ORACLE%’);
a. It determines which publisher published a book belonging to the oracle category and then lists all other books
published by the same publisher.
b. It lists all publishers and categories containing the value oracle
c. It lists the ISBN and title of all books belonging to the same category and having the same publisher as any book
with the phrase ORACLE in its title
d. The query contains a multiple row operator and because the inner query only returns one value, the select statement
will fail and return an error message.
Question 4
Complete
Mark 0.00 out of 4.00
Where can subqueries be used? Choose the best answer.
a. Field names in the SELECT statement
b. For constraints statements only
c. The GROUP BY clause in the SELECT statement
d. The WHERE clause in only the SELECT statement
Question 5
Complete
Mark 4.00 out of 4.00
Which of the following commands eliminates only the user ELPOEZ’s ability to enter new books in the BOOKS table?
a. Revoke insert on books from elopez
b. Revoke insert from elopez
c. Revoke insert into from elopez
d. Drop insert into books from elopez
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller foxNotes. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R69,33. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
68175 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 15 years now