Database Administration Questions


Q:

In OSI network architecture, the routing is performed by

A) transport layer B) session layer
C) network layer D) data link layer
 
Answer & Explanation Answer: C) network layer

Explanation:

in_osi_network_architecture_the_routing_is_performed_by1553604163.jpg image

 

In networking, the Open Systems Interconnection is commonly called as OSI model. It has a 7 layer architecture for the communication.

 

In OSI network architecture, the routing is performed by network layer which is layer number 3 with the help of intermediate routers.

Report Error

View Answer Report Error Discuss

4 7416
Q:

Out of three numbers, the first is twice the second and is half of the third. If the average of the three numbers is 56, what will be the sum of the highest number and the lowest number?

A) 120 B) 160
C) 80 D) 60
 
Answer & Explanation Answer: A) 120

Explanation:

Let the three numbers be x, y, z.

From the gien data,

x = 2y ....(1)

x = z/2 => z = 2(2y) = 4y .....(From 1)  ...........(2)

Given average of three numbers = 56

Then,

 

x + y + z3 = 562y + y + 4y3 = 56  (From 1 & 2)7y = 56 x 3y = 24

Now,

x = 2y => x = 2 x 24 = 48

z = 4y = 4 x 24 = 96

 

Now, the highest number is z = 96 & smallest number is y = 24

 

Hence, required sum of highest number and smallest number

= z + y

= 96 + 24

= 120.

Report Error

View Answer Report Error Discuss

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

15 7387
Q:

Order of basicity of amines in gaseous state?

A) 2'> 1'> 3' > NH3 B) 3' > 2' > 1'> NH3
C) 1' > 2' > 3'> NH3 D) 2'> 3'> 1' > NH3
 
Answer & Explanation Answer: B) 3' > 2' > 1'> NH3

Explanation:

The order of basicity in ammonia is different in gaseous phases vs. aqueous phases due to hydrogen bonding.

 

So in gaseous phases it's the well known: 3' > 2' > 1'> NH3. Just so we're on the same page, this is due to the inductive effect of electron donating alkyl groups--they destabilize the lone pair on nitrogen atom, making nitrogen more basic.

 

But in aqueous phase, the order is slightly different: 2'> 1'> 3' > NH3.

Report Error

View Answer Report Error Discuss

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

6 7363
Q:

Iteration is most similar in meaning to

A) Looping B) Starting
C) Ending D) None of the above
 
Answer & Explanation Answer: A) Looping

Explanation:

Iteration means doing something again and again, repeatedly,... 

 

Hence, looping is a process of repeating a method and so it is similar in meaning to Iteration.

Report Error

View Answer Report Error Discuss

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

3 7289
Q:

Social engineering attacks are best identified by

A) Ransomware B) Phishing
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

Social engineering is the art of tricking users into performing certain harmful activities or attacks, users must be trained to identify social engineering. Social engineering attacks typically involve some form of psychological manipulation, fooling otherwise unsuspecting users or employees into handing over confidential or sensitive data. Commonly, social engineering involves email or other communication that invokes urgency, fear, or similar emotions in the victim, leading the victim to promptly reveal sensitive information, click a malicious link, or open a malicious file. Because social engineering involves a human element, preventing these attacks can be tricky for enterprises.

 

Report Error

View Answer Report Error Discuss

6 7259
Q:

12 boys decided to constribute Rs. 750 each to an Orphange. Suddenly few of them boys dropped out and consequently the rest had to pay Rs. 150 more. Then the number of boys who dropped out?

A) 4 B) 6
C) 2 D) 3
 
Answer & Explanation Answer: C) 2

Explanation:

Total money decided to contribute = 750 x 12 = 9000

Let 'b' boys dropped

The rest paid 150/- more

=> (12 - b) x 900 = 9000

=> b = 2

Hence, the number of boys who dropped out is 2.

Report Error

View Answer Report Error Discuss

Filed Under: Average
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration

26 7186
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

8 7185
Q:

The brain of any computer system is

A) CPU B) Memory
C) Control D) ALU
 
Answer & Explanation Answer: A) CPU

Explanation:

Central Processing Unit (CPU) is the brain of any computer system.

Report Error

View Answer Report Error Discuss

19 7178