Database Administration Questions


Q:

6 divided by 2(1 + 2) =

A) 1 B) 0
C) 9 D) Can't be determined
 
Answer & Explanation Answer: C) 9

Explanation:

The given expression can be simplified as

÷ 2 (1 + 2)

The expression can be simplified further by the order of operations, using BODMAS rule.

 

First evaluate Parentheses/Brackets, then evaluate Exponents/Orders, then evaluate Multiplication-Division, and finally evaluate Addition-Subtraction.

 

Now, the expression becomes ÷ 2 (3)

 

According to the order of operations, division and multiplication have the same precedence, so the correct order is to evaluate from left to right. First take 6 and divide it by 2, and then multiply by 3.

6 ÷ 2 × 3

= 3 × 3

= 9

But not  6÷2×3 = 6 ÷ 6 = 1

Screenshot_(21)1528090844.jpg image 

 

Hence, 6 ÷ 2 (1 + 2) = 9.

Report Error

View Answer Report Error Discuss

3 2538
Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

6 2534
Q:

An increase in the quantity demanded means that

A) The demand curve shifted to right B) Price of the product has declined
C) Increase in consumer income D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:
Report Error

View Answer Report Error Discuss

1 2530
Q:

Which datatype in c language has least storage?

A) char B) double
C) int D) float
 
Answer & Explanation Answer: A) char

Explanation:

Data types are used for declaration of variables in computer programming languages. These determine the type and size of data associated with variables.

Data types examples - int, char, float, etc...

 

char datatype is the least storage data type with 1 byte.

int with 2 or 4 bytes.

float with 4 bytes

double with 8 bytes.

datatype_in_c_language_has_least_storage1562156854.png image

Report Error

View Answer Report Error Discuss

Filed Under: Computer
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

2 2528
Q:

Which of the following is a correctly written compound word?

A) Spur of the moment-decision B) Thirty one
C) Quickly-running D) Self-evident
 
Answer & Explanation Answer: D) Self-evident

Explanation:

Compound word means when two or more words join together to make a single word that gives a new meaning.

 

Here in the options, Self-evident is the compound word.

Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

0 2524
Q:

What is the distance around a circle called

Answer

The distance around a circle is called as Circumference. And that in the case of square or rectangle it is called as Perimeter.

Report Error

View answer Workspace Report Error Discuss

4 2522
Q:

Which memory needs refresh?

A) DRAM B) SRAM
C) ROM D) All of the above
 
Answer & Explanation Answer: A) DRAM

Explanation:

Memory refresh is the process of periodically reading information from an area of computer memory and immediately rewriting the read information to the same area without modification, for the purpose of preserving the information.

DRAM1532669979.png image

Memory refresh is a background maintenance process required during the operation of semiconductor dynamic random-access memory (DRAM), the most widely used type of computer memory.

Report Error

View Answer Report Error Discuss

2 2519
Q:

What does microprocessor speed of a computer depends on?

A) bandwidth B) clock speed
C) number of instructions D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

The computers microprocessor speed depends on all the factors like clock speed, bandwidth and the number of instructions it processes.

Report Error

View Answer Report Error Discuss

2 2517