Database Administration Questions

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.

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

Oracle SQL developer is an Oracle Database IDE.

"The moon smiled at me" is the example of personification in the given options.

Personification is a technique in which we give objects human traits like emotions, gestures, speech,... by using metaphor. 

Here moon is an object which cannot smile but using metaphor sense, we gave that sense to it.

There are two IP address assigned to each device on a Wi-Fi network.

An Internal (Private) and an External (Public) IP address.

Internal IP address is used for communication between Your computer and a smartphone or whatever devices that are connected to that Wifi network. This is unique for each. If they are same the system cannot differentiate between each device.

While, the External IP address is that visible to the the internet - the websites, the internet connected Apps so on. By default, Routers with NAT (all routers today have it) assign same Public IP address to all devices under its network.

China has been by far the biggest coal producing country over the last three decades. The country produced about 3.6 billion tonnes (Bt) of coal in 2012 accounting for over 47% of the world's total coal output.

XPath is an expressions to select a xml node in an XML document.

It allows the navigation on the XML document to the straight to the element where we need to reach and access the attributes.