Database Administration Questions


Q:

Define Executive Plan in Database SQL ?

Answer

Executive plan can be defined as:


* SQL Server caches collected procedure or the plan of query execution and used thereafter by subsequent calls.


* An important feature in relation to performance enhancement.


* Data execution plan can be viewed textually or graphically.

Report Error

View answer Workspace Report Error Discuss

7 2459
Q:

What has no beginning, end or middle?

Answer

A Donut or Doughnut. Anything in the shape of a torus.

Report Error

View answer Workspace Report Error Discuss

3 2458
Q:

Is boiling water a chemical change?

Answer

No. Boiling water is not a chemical change. Because in this process it doesn't loss its properties. It just changes its state i.e, from liquid state to gaseous.


 


Hence, Boiling water is a Physiacl change and not a chemical change.

Report Error

View answer Workspace Report Error Discuss

0 2455
Q:

3/8 as a decimal

A) 1.375 B) 2.375
C) 0.375 D) 3.75
 
Answer & Explanation Answer: C) 0.375

Explanation:

Expressing 3/8 as a decimal fraction:

We can convert 3/8 into a decimal fraction by just dividing 3 by 8 or making 3 into 8 parts.

Then, it is 3/8 = 0.375 as a decimal fraction.

 

Other Method::

3/8 as a Decimal :

In this we should convert the denominator into 10, 100, 1000, 10000, 100000,... to make it simple.

Now to make 8 into 1000, we multiply numerator and denominator with 125

 

=> (3 x 125)/(8 x 125) = 375/1000 = 0.375.

 

Report Error

View Answer Report Error Discuss

3 2453
Q:

Data structure suitable for an application discussed in?

A) procedural design B) architectural design
C) data design D) interface design
 
Answer & Explanation Answer: C) data design

Explanation:
Report Error

View Answer Report Error Discuss

1 2446
Q:

What does a VLAN do?

A) Breaks up broadcast domains in a layer 2 switch internetwork B) Provides multiple broadcast domains within a single collision domain
C) Provides multiple collision domains on one switch port D) Acts as the fastest port to all servers
 
Answer & Explanation Answer: A) Breaks up broadcast domains in a layer 2 switch internetwork

Explanation:

virtual LAN (VLAN) is any broadcast domain that is partitioned and isolated in a computer network at the data link layer (OSI layer 2). LAN is the abbreviation for local area network and in this context, virtual refers to a physical object recreated and altered by additional logic.

VLANs work by applying tags to network packets and handling these tags in networking systems – creating the appearance and functionality of network traffic that is physically on a single network but acts as if it is split between separate networks. In this way, VLANs can keep network applications separate despite being connected to the same physical network, and without requiring multiple sets of cabling and networking devices to be deployed.

Report Error

View Answer Report Error Discuss

0 2430
Q:

Which planet is known as the Morning Star or the Evening Star?

A) Jupiter B) Venus
C) Mercury D) Saturn
 
Answer & Explanation Answer: B) Venus

Explanation:

Venus planet is known as the Morning Star or the Evening Star.

Report Error

View Answer Report Error Discuss

5 2387
Q:

Is a square a rhombus?

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Yes, a square is a rhombus. But a rhombus is not a square unless the interior angles are at right angles.


 


We know that, a square is a quadrilateral with all sides equal and all the interior angles are 90 deg i.e, at right angles. 


Whereas


a rhombus is also a quadrilateral with all sides equal but the interior angles are not at right angles. Hence, if the interior angles of a rhombus are all at right angles (90 deg), then it is square.

Report Error

View Answer Workspace Report Error Discuss

0 2387