Database Administration Questions

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

Examples:

1. GRANT


2. REVOKE

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.

The Riddle itself has the Answers.

What is a 4 letter word

Yet is written in 3 letters

Everything is written with 9 letters

Then with 4 letters

Rarely has 6 letters

Never is written in 5 letters.

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.

A database is used to store, modify, extract and to search for the data within it.

The first Asian games was held in New Delhi. The Asian Games, were regulated by the Asian Games Federation (AGF) from the first Games in New Delhi, India, until the 1978 Games.

Its a Needle. Needle has an eye but can't see.

Indian state that has the maximum number of Lok Sabha constituencies is Uttar Pradesh with 80 Lok sabha seats.