Database Administration Questions

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.

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

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

Examples:

1. GRANT


2. REVOKE

Mushroom.

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.

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.

With YouTube Analytics, you can track metrics on Playback locations. Playback locations gives you how many views your channel got and what videos they watched. 

With YouTube Analytics we can Find out who's watching, what they like to watch, and which videos could make you the most money.

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