Database Administration Questions

The second would employ a comma, or semi-colon, and not a colon so it is not properly punctuated.

The third sentence would not be correct because it uses 'like', usually used for comparison. Since you are not comparing two questions, it would not be appropriate.

The fourth sentence has 'is' before the colon, which is a implies declaration and not listing. So, again, it would not be appropriate.

Hence, the first sentence, however, is punctuated correctly.

A promise. 

The Promise made to somebody by you can be break but you cannot touch it.

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

Examples:

1. GRANT


2. REVOKE

Wide-mouth frog is the simplest known key distribution center (KDC) authentication protocol

A computer programming language is nothing but a language which is understand by the computer.

Examples of programming languages are Basic, C, Java, Python, ...

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.