All categories

3 years ago

"what do you perform when you want to recall specific records from a database"

Computers and Technology

1 answer:

Ivan3 years ago

5 0

A select query

select column1, column2, columnN
from table
where condition
order to be pretty;

You might be interested in

Consider an implementation of the instruction set architecture P1 has a clock rate of 4.8 GHz and CPIs (Cycles Per Instruction)

Anestetic [448]

Answer:

a) 3.3

b) 3

Explanation:

As we know ,

CPI = sum of ( instructions× clock cycle)

= 50%(1) + 30%(4) + 20%(8)

= 50% + 120% + 160%

= 330%

= $\frac{330}{100}$ = 3.3

⇒CPI = 3.3

Let a = number of cycles on average

As given,

a 10% improvement in performance of P1,

⇒New CPI = 3

⇒3 = 50% + 30% (x) + 20%(8)

⇒3 = 50% + 30% (x) + 160%

⇒3 = 210% + 30%(x)

⇒3 = 2.1 + 0.3x

⇒3 - 2.1 = 0.3x

⇒0.9 = 0.3x

⇒x = $\frac{0.9}{0.3}$ = 3

⇒x = 3

∴ we get

Number of cycles on average = 3

6 0

3 years ago

The following section of psudo code inputs a number n, multiplies together 1 x 2 x 3 x ..... x n, calculates input number/sum an

xenn [34]

Answer:

INPUT n

sum = 1

FOR mult = 1 TO n

sum = sum*mult

result = n/sum

PRINT result

Explanation:

sum should not be defined inside the for loop because it will reset to the initial number after every loop iteration which is not what is desired. Sum should not be 0 if it is being multiplied then divided. This will cause an error. Result should be calculated after sum has settled on a final number, after the loop has finished.

4 0

3 years ago

While reviewing a Web site about a medical condition your aunt was just diagnosed with, you decide to check on the writer of the

kipiarov [429]

Answer:

This is a characteristic of a reputable author

4 0

3 years ago

Text in a cell can be algined as dash

Anit [1.1K]

Answer:

Text and numbers can be aligned to the left, right or center of a cell, as well as to the top, middle and bottom.

6 0

3 years ago

Count the number of films spoken in English. You must not hard code English's language_code. Give two solutions for this problem

dedylja [7]

Answer:

Explanation name has given below

Explanation:

In sub query we have to take Film Language .From Film Where code is equal to language code and language is English.

FROM Film F,FilmLanguage L1,

WHERE C.Code = L1LanguageCode

AND L1.Language = 'English';

Join table:

code | film_name | Language * where E = English & N = no

--------+----------------------+------------

01 | Forrest Gump | E

02 | Good fellas | E

03 | Peter | N

04 | Hotel Rwanda | E

05 | F. Murray | N

06 | The Green Mile | E

07 | Nicole | N

08 | The Godfather | E

09 | Jack | N

3 0

3 years ago