Access over 20 million homework & study documents

Mysql Exam

Content type
User Generated
Subject
MySQL
School
Allegany College of Maryland
Type
Homework
Rating
Showing Page:
1/8
A relational database is:
Group of answer choices
A. a collection of forms and reports that support a given purpose.
B. a self-describing collection of related tables.
C. a library of queries and data files for querying.
D. a set of applications and the data sets for those applications.
E. a set of metadata.
The purpose of concurrency control is to:
Group of answer choices
ensure that ASPs do not duplicate JSPs.
ensure that one user's work does not interfere with another's.
ensure that each form has a corresponding report.
ensure that stored procedures do not invoke triggers.
ensure that triggers do not invoke stored procedures.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/8
Using the following diagram, write a SQL Statement to find all books written by authors with the
Jim in their name. Please your initials as an Alias for one of the table names. *** MY Initials
IS A A ****
SELECT books.title FROM
books
INNER JOIN author_books
ON author_books.book_id = books.id
INNER JOIN authors
ON author_books.author_id = authors .id
WHERE authors .name = "Jim";

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/8

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 8 pages?
Access Now
Unformatted Attachment Preview
A relational database is: Group of answer choices A. a collection of forms and reports that support a given purpose. B. a self-describing collection of related tables. C. a library of queries and data files for querying. D. a set of applications and the data sets for those applications. E. a set of metadata. The purpose of concurrency control is to: Group of answer choices ensure that ASPs do not duplicate JSPs. ensure that one user's work does not interfere with another's. ensure that each form has a corresponding report. ensure that stored procedures do not invoke triggers. ensure that triggers do not invoke stored procedures. Using the following diagram, write a SQL Statement to find all books written by authors with the Jim in their name. Please your initials as an Alias for one of the table names. *** MY Initials IS A A **** SELECT books.title FROM books INNER JOIN author_books ON author_books.book_id = books.id INNER JOIN authors ON author_books.author_id = authors .id WHERE authors .name = "Jim"; Q4: Using this diagram, What does the following SQL Statement do? SELECT a.name, Count (ab.book_id) FROM authors AS a, authors_books AS ab WHERE a.id = ab.author_id GROUP BY a.name It will retrieve author's name and number of books written by them. First it will join two tables-authors and authors_books based on author id, that is, a.aid=ab.author_id. Then it will count the no. of book id from authors_books table and author's name from authors table and print them on t ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4