GradePack

    • Home
    • Blog
Skip to content
bg
bg
bg
bg

Author Archives: Anonymous

How many records would the following SQL query produce as a…

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’

Read Details

Which of the following is the best answer about the PersonID…

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

Read Details

Decisions related to improving database pefromance are part…

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

Read Details

In an ERD, the maximum cardinality of one is represented by…

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

Read Details

Which of the following is the total number of entities in th…

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

Read Details

The next seven (7) questions use the User and Login tables,…

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

Read Details

What will be returned from the following query?Hint: Do not…

What will be returned from the following query?Hint: Do not count the NULLs SELECT COUNT(DISTINCT UserID) FROM Login WHERE LoginDTStamp BETWEEN ‘2030-02-01 10:00:00’    AND ‘2030-02-03 10:00:00’

Read Details

_____ describe interactions between _____ that store data in…

_____ describe interactions between _____ that store data in a collection of _____.

Read Details

The next four (4) questions use the following two tables (un…

The next four (4) questions use the following two tables (underline represents the primary key): Company (CompanyID, Name, Type, Location) and WorksIn (PersonID, CompanyID, Name, HourlyRate, AnnualSalary). The Company table describes different companies, the WorksIn table describes who works at which company and how much are they getting paid. HourlyRate is associated with hourly employees and AnnualSalary with full-time benefited employees. You can assume that people can have multiple jobs at the same time, but not at the same company.

Read Details

Which of the following is the problem with the traditional f…

Which of the following is the problem with the traditional flat-file based approach to databases?

Read Details

Posts pagination

Newer posts 1 … 48 49 50 51 52 … 78,219 Older posts

GradePack

  • Privacy Policy
  • Terms of Service
Top