Database Administration Questions

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

Examples:

1. GRANT


2. REVOKE

Mushroom.

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.

Anything larger and the computer would need to break the number into smaller pieces.

16-bit is a computer hardware device or software program capable of transferring 16 bits of data at a time.

Today, 16-bit hardware and software has been replaced by 32-bit and 64-bit alternatives, which give the computer more memory to work with; increasing overall performance.

For example, early computer processors (e.g., 8088 and 80286) were 16-bit processors, meaning they were capable of working with 16-bit binary numbers (decimal number up to 65,535).

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.

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.