Which of the following is the correct WHERE clause restricting the list of authors to those whose last name starts with either L or M, with books published during the 2014-15 time period?

List author’s first and last name, book and course titles, for books published in 2012. Which tables appear in the FROM clause of the query?

The full-outer join of User and Login tables will result in ___ rows?

The one-sided outer join of Login on User tables that includes the guest logins will result in ___ rows?

How many records would the following SQL query produce as a result? SELECT User.UserID, NameFROM User INNER JOIN Login ON User.UserID = Login.UserIDWHERE LoginDTStamp   BETWEEN ‘2030-02-01 12:00:00’ AND ‘2030-02-02 12:00:00’

Which of the following is the best answer about the PersonID and CompanyID keys in the WorksIn table?

Decisions related to improving database pefromance are part of which one of the development phases?

In an ERD, the maximum cardinality of one is represented by which of the following?

Which of the following is the total number of entities in the credit card ERD?

The next seven (7) questions use the User and Login tables, where the NULLs in the Login table represent guest logins.