Database Administration Questions


Q:

Explain Data Control Language

Answer

Data Control Language (DCL):-statements to take care of the security and authorization.


Examples:



    1. GRANT

    2. REVOKE

Report Error

View answer Workspace Report Error Discuss

2 2272
Q:

Permanent hardness of water may be removed by the addition of

A) Alum B) Lime
C) Sodium Carbonate D) Potassium Permanganate
 
Answer & Explanation Answer: C) Sodium Carbonate

Explanation:

Permanent hardness of water may be removed by the addition of Sodium Carbonate.

Report Error

View Answer Report Error Discuss

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

0 2269
Q:

IP addresses are converted to

A) A binary string B) A domain name
C) Alphanumeric string D) A hexadecimal string
 
Answer & Explanation Answer: B) A domain name

Explanation:

IP addresses are converted to a domain name by DNS - Domain Name System.

Report Error

View Answer Report Error Discuss

7 2268
Q:

What kind of Room has No Doors or Windows

Answer

Mushroom.

Report Error

View answer Workspace Report Error Discuss

2 2259
Q:

If you are using C language to implement the heterogeneous linked list, what pointer type will you use?

Answer

The heterogeneous linked list contains different data types in its nodes and we need a link, pointer to connect them. It is not possible to use ordinary pointers for this. So we go for void pointer. Void pointer is capable of storing pointer to any type as it is a generic pointer type.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Exam Prep: GATE
Job Role: Database Administration

0 2259
Q:

What is Log Shipping?

Answer

Log shipping defines the process for automatically taking backup of the database and transaction files on a SQL Server and then restoring them on a standby/backup server. This keeps the two SQL Server instances in sync with each other. In case production server fails, users simply need to be pointed to the standby/backup server. Log shipping primarily consists of 3 operations:


Backup transaction logs of the Production server.


Copy these logs on the standby/backup server.


Restore the log on standby/backup server.

Report Error

View answer Workspace Report Error Discuss

2 2251
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 2246
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 2246