All categories

2 years ago

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

2 answers:

8 0

Structured Language Query ( SQL ) query helps retrieving the data by using its SELECT keyword which specifies the table name to select while retrieving data.

By using where clause you can filter data as well. Also it has aggregate functions to help development like sum() function. And it can format the data to be displayed as well.

melisa1 [442]2 years ago

4 0

A Structured query has clauses to retrieve data, filter those to get the desired output.

Select clause --> specifies the list column(s) that need to be selected and displayed

From clause--> contains the table(s) from which the data needs to be fetched

Where clause--> this contains the condition or the filter that needs to be made on the retrieved data before display

Group by --> to display data with sub-total, grand total or any grouping related activities

Having-->this is similar to where clause but this works on grouping.

Order by --> to sort the filtered data in ascending (asc) or descending(desc) order.

You might be interested in

Darcy is creating an instructional manual for her employees. She entered the text in a word processing program and wants to impo

NeX [460]

When Darcy finish creating the instructional manual for her employees, she can copy paste her content from the word processing program to DTP by :
a) Press Ctrl a to select all the content from the word processing program;
b) Press Ctrl c to copy everything from the word processing program;
c) open DTP
d) Press Ctrl v to paste everything, word by word, page by page from the word processing program to DTP.

5 0

2 years ago

Which of the following statements is true? A. Interpreted programs run faster than compiled programs. B. Compilers translate hig

alina1380 [7]

Answer:

Explanation:

Computer programs are written in high level languages. Every language has its own set of syntax and semantics.

Computer only understands instructions in machine language which is written using strings of 0 and 1.

Thus, for execution of a high level language program, it is mandatory to convert high level instructions into machine instructions.

This translation into machine language is done in two ways – compilation or interpretation.

Some languages are compiled while others are interpreted.

Both compilers and interpreters are programs and process the high level language program as needed.

Compiler

Any program written in high level language is compiled.

The program is first analyzed before compilation. This process takes time. The analysis phase is called pre processing.

The program compilation stops only when the program is completely analyzed. Hence, it is difficult to locate the error in the program. This makes debugging easy.

Debugging is defined as removal of errors in the programs.

A compiler is responsible for converting high level language code into machine level code.

The complete program undergoes compilation at the same time.

A compiled program executes faster than an interpreted program.

A compiled program produce machine code which is a collection of 0 and 1, hence, it takes less time to execute.

Examples of compiled languages are C and C++.

Interpreter

Some high level languages are interpreted.

The high level language code is translated into an intermediate level code. This intermediate code is then executed.

The analysis of the program takes less time and takes place before interpretation begins. The analysis phase is called pre processing.

An interpreted program is translated one line at a time.

The program interpretation stops when an error is encountered. This makes debugging easy.

Debugging is defined as removal of errors in the programs.

Examples of interpreted languages include Python and Ruby.

6 0

2 years ago

Read 2 more answers

Write a method called printRangeOfNumbers that accepts a minimum, maximum numbers as parameters and prints each number from mini

timama [110]

Answer:

The method in python is as follows:

class myClass:

def printRange(min,max):

for i in range(min, max+1):

print("{"+str(i)+"} ", end = '')

Explanation:

This line declares the class

class myClass:

This line defines the method

def printRange(min,max):

This line iterates from min to max

for i in range(min, max+1):

This line prints the output in its required format

print("{"+str(i)+"} ", end = '')

5 0

2 years ago

There is a function we are providing in for you in this problem called square. It takes one integer and returns the square of th

anastassius [24]

Answer:

xyz = 25

result = square(xyz)

print(result)

The above code assigns the value 25 to variable xyz as 5*5=25. Then next statement is a function call to square() function passing xyz to this function in order to compute the square of 25. The output is:

625

Explanation:

The above code can also be written as:

xyz = 5*5

result = square(xyz)

print(result)

The difference is that xyz is assiged 5*5 which is equal to 25 so the output produced will be the same i.e. 625.

The result variable is used to store the value of square of 25 after the square() method computes and returns the square of 25. So print(result) prints the resultant value stored in the result variable i.e. 625

3 0

2 years ago

Cloud-based services can open doors to leveraging Artificial Intelligence (AI) without dramatically increasing risk. Which clien

vladimir1956 [14]

Answer:

Explanation:

The clients that would be best suited for this opportunity would be small business or business' that do not have the hardware/space resources necessary to create the computing power that they need. Instead, they can simply pay for these cloud-based services which provide all of the necessary computing/hardware power and resources necessary so that the company can easily fulfill all of their tasks without any problems. Bigger companies can easily pay for and implement their own hardware to solve their problems which may benefit them even more in the long-term.

7 0

1 year ago