1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ANEK [815]
3 years ago
11

Which of the following statements is valid?SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Ven

dors.VendorIDWHERE InvoiceTotal = MAX(InvoiceTotal)SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorIDWHERE InvoiceTotal = (SELECT MAX(InvoiceTotal))SELECT InvoiceNumber, VendorNameFROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorIDWHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)All of the above
Computers and Technology
1 answer:
vaieri [72.5K]3 years ago
3 0

Correct Answer:

c.

SELECT InvoiceNumber, VendorName

FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID

WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)

Explanation:

All options only differ on the WHERE clause:

a: WHERE InvoiceTotal = MAX(InvoiceTotal)

Fails because aggregate functions (like MAX, COUNT, etc) have to be used on the SELECT clause.

b: WHERE InvoiceTotal = (SELECT MAX(InvoiceTotal))

Fails because the SELECT clause is incomplete.

c: WHERE InvoiceTotal IN (SELECT MAX(InvoiceTotal) FROM Invoices)

This one is correct, and returns the InvoiceNumber and VendorName register with the largest value on the InvoiceTotal field.

You might be interested in
Which of these is NOT an example of lifelong learning?
oee [108]

Answer:

B. having lunch with a friend

Explanation:

Lifelong learning can be defined as a continuous, self-motivated, and self-initiated learning activity that is typically focused on personal or professional development. Thus, it's a form of education that is undertaken throughout life with the sole aim of pursuing knowledge, competencies, and skills for either personal or professional growth and development, especially after acquiring a formal education.

Some examples of lifelong learning includes the following;

I. Reading a trade magazine.

II. Reviewing a textbook.

III. Studying an encyclopedia.

7 0
3 years ago
Given six memory partitions of 300 KB, 600 KB, 350 KB, 200 KB, 750 KB, and 125 KB (in order), how would the first-fit, best-fit,
Inga [223]

Answer:

In terms of efficient use of memory: Best-fit is the best (it still have a free memory space of 777KB and all process is completely assigned) followed by First-fit (which have free space of 777KB but available in smaller partition) and then worst-fit (which have free space of 1152KB but a process cannot be assigned). See the detail in the explanation section.

Explanation:

We have six free memory partition: 300KB (F1), 600KB (F2), 350KB (F3), 200KB (F4), 750KB (F5) and 125KB (F6) (in order).

Using First-fit

First-fit means you assign the first available memory that can fit a process to it.

  • 115KB will fit into the first partition. So, F1 will have a remaining free space of 185KB (300 - 115).
  • 500KB will fit into the second partition. So, F2 will have a remaining free space of  100KB (600 - 500)
  • 358KB will fit into the fifth partition. So, F5 will have a remaining free space of 392KB (750 - 358)
  • 200KB will fit into the third partition. So, F3 will have a remaining free space of 150KB (350 -200)
  • 375KB will fit into the remaining partition of F5. So, F5 will a remaining free space of 17KB (392 - 375)

Using Best-fit

Best-fit means you assign the best memory available that can fit a process to the process.

  • 115KB will best fit into the last partition (F6). So, F6 will now have a free remaining space of 10KB (125 - 115)
  • 500KB will best fit into second partition. So, F2 will now have a free remaining space of 100KB (600 - 500)
  • 358KB will best fit into the fifth partition. So, F5 will now have a free remaining space of 392KB (750 - 358)
  • 200KB will best fit into the fourth partition and it will occupy the entire space with no remaining space (200 - 200 = 0)
  • 375KB will best fit into the remaining space of the fifth partition. So, F5 will now have a free space of 17KB (392 - 375)

Using Worst-fit

Worst-fit means that you assign the largest available memory space to a process.

  • 115KB will be fitted into the fifth partition. So, F5 will now have a free remaining space of 635KB (750 - 115)
  • 500KB will be fitted also into the remaining space of the fifth partition. So, F5 will now have a free remaining space of 135KB (635 - 500)
  • 358KB will be fitted into the second partition. So, F2 will now have a free remaining space of 242KB (600 - 358)
  • 200KB will be fitted into the third partition. So, F3 will now have a free remaining space of 150KB (350 - 200)
  • 375KB will not be assigned to any available memory space because none of the available space can contain the 375KB process.
8 0
3 years ago
A Configuration Management System is a collection of formal documented procedures used to apply the following items EXCEPT:
RoseWind [281]

Answer: (C) Confirm project requirement

Explanation:

 The configuration management is the type of system and it is collection of the formal document that is use to applying for the technical direction. It is the subsystem of the management system of the project.

It basically record each change occur in the project and then report the each change status in the project. It also control various physical characteristics in the project.

It identify all the physical and the functional characteristics of any type of service, result and product in the project document. It basically include the tracking system that is used for the document authorizing and also for the controlling purpose.  

4 0
3 years ago
Which statement is true? Group of answer choices Variables cannot be assigned and declared in the same statement Variable names
mote1985 [20]

Complete Question:

Which statement is true? Group of answer choices

A. Variables cannot be assigned and declared in the same statement

B.  Variable names must contain at least one dollar sign

C. Variable names can be no more than 8 characters long

D.  It is incorrect to initialize a string variable with a number

Answer:

D. It is incorrect to initialize a string variable with a number

Explanation:

  1. Options A-C are not correct
  2. Variables can be declared and assigned values on same statement like this int a =5;
  3. Variable names must not contain the dollar sign as this declaration int num =0; is legal without a dollar sign
  4. Variable names are not restricted to 8 characters long they can be longer
  5. In option D if you declare a variable of a particular type, you must assign a value of that type for example int s ="John" is wrong
3 0
3 years ago
How media platform drives globalization.<br> Advantages and disadvantages of using media platforms?
nirvana33 [79]

Answer:

Increasingly, technology has also been propelling globalization. Technology allows for quick communication, fast and coordinated transport, and efficient mass marketing, all of which have allowed globalization—especially globalized media—to take hold. Much globalized media content comes from the West, particularly from the United States.

Explanation:

7 0
3 years ago
Other questions:
  • A ___________ lists all possible packet switches and gives a next hop for each.
    12·1 answer
  • I need to figure out exactly how to make this figure while coding.
    6·1 answer
  • What is the purpose of a register in a CPU? Describe three types of registers.
    12·1 answer
  • Sort short_names in reverse alphabetic order.
    11·1 answer
  • A working model of a new product for testing purposes.
    15·1 answer
  • Assume we have a two-class learning problem where the labeled data consists of 1,000 data points from one class, and 10 data poi
    15·1 answer
  • What file does a aac run under
    11·1 answer
  • What type of data uses numbers that can be used in the arithmetic operations?
    14·1 answer
  • How does video conferencing change the way we work today?
    6·1 answer
  • If you need to change the typeface of a document, which menu will you choose?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!