Database Administration Questions


Q:

Jio is a big shot at reducing the cost of Internet access in India. The U.S., despite being the richest country in the world, lags far behind in terms of cost and penetration of Internet access. Cheap access to the Internet is an important step in bridging the access gap – access to good education, good healthcare, etc. But the market reaction to Jio is similar to the U.S. market’s reaction to firms announcing their intention to diversify.

(A) The final group of losers is the current shareholders of RIL. On announcement of Jio, the stock price of RIL fell.

(B) It shows that the market’s short-term reaction is usually proven correct in the long-run.

(C) On losing end, the first groups of losers are the shareholders of other telecom companies.

(D) The large amount of revenue the Government of India gets from auctioning off the nation’s natural resources is not necessarily a good thing because the Government does not have a stellar track record when it comes to spending the money. A large fraction of Government spending is wasted.

(E) The second loser is the Government of India. The big money the Indian Government was raking in selling cellular bandwidth was actually coming from the pockets of the cellular consumers. 

(F) The first obvious winners of this scheme are customers.

(G) The second winner is Mr. Ambani; he can potentially make a lasting impact as the man who brought Internet to millions of Indians.

 

Question:

Which of the following supports the decision of other companies opposing Reliance JIO Scheme?

A) Only A B) Both A & B
C) Only C D) Both C & E
 
Answer & Explanation Answer: D) Both C & E

Explanation:

As the arguments C and E states that other companies are on the losing end with this scheme, it is the only appropriate answer to this question.

Report Error

View Answer Report Error Discuss

4 2483
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 2479
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 2479
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 2466
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 2466
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 2465
Q:

4 phases of project management are

Answer

The project management life cycle describes high-level processes for delivering a successful project.


The project management life cycle is usually broken down into four phases:


1. Initiation and Planning,


2. Execution,


3. Project Monitoring and Control, and


4. Project Closing.

Report Error

View answer Workspace Report Error Discuss

11 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 2415