Question 321 – What is a Full Database Backup type in SQL?

With this backup you are backing up the entire database and will be able to restore the entire database from just this backup.

Question 322 – What is a Differential Database Backup type in SQL?

• A differential backup will record all of the data that has changed since the last database backup.
• You must have a database backup in place to use a starting point for your differential backup.
• Differential backups have several limitations including the following:
• They do not provide point-in-time restore capabilities
• They may only be restored after a complete database backup is restored
• They may not be performed on the master database

Question 323 – What is a Transactional Log Database Backup type in SQL?

Transaction log backups record all transactions that have been recorded against the database since the last transaction log backup.

Question 324 – What is a Log Database Backup type in SQL?

• File backups involve backing up individual files within a database.
• This can be the quickest way to restore, but it also has a lot of overhead associated with it.
• You must keep track of your file backups as well as use these file backups in conjunction with transaction log backups.

Question 325 – What are the advantages of NoLock in SQL?

Applying nolock in select statement will increase concurrency and performance in fetching.

Question 326 – What are the disadvantages of NoLock in SQL?

It doesn’t consider the transaction scenario, even if the transaction is under process not yet committed or rollback it will fetch the current record.

Question 327 – What is GRANT command in SQL?

• It is a command used to provide access or privileges on the database objects to the users.
• Syntax – GRANT privilege_name ON object_name TO {user_name |PUBLIC |role_name}
• Example – GRANT SELECT ON Table1 TO User1

Question 328 – What is REVOKE command in SQL?

• It removes user access rights or privileges to the database objects.
• Syntax – REVOKE privilege_name ON object_name FROM {user_name |PUBLIC |role_name}
• Example – REVOKE SELECT ON Table1 TO User1

Question 329 – What is Privileges command in SQL?

• It defines the access rights provided to a user on a database object. There are of two types.
• System privileges – This allows the user to CREATE, ALTER, or DROP database objects.
• Object privileges – This allows the user to EXECUTE, SELECT, INSERT, UPDATE, or DELETE data.

Question 330 – What is Cascade command in SQL?

• While dropping a parent table , it is required to drop the corresponding child table also.
• Parent table cannot be deleted if there is any child for it. So the cascaded drop or delete helps in deleting the child and then the parent.
• When you give a “drop table” command, it will not drop the table that has dependencies unless you include the “cascade” command in the statement.

Disclaimer – F5debug Interview Questions & Answers Series:

You may recopy extracts from these pages (“the material”) to individual third party websites or to any intranet websites, but only if:
You acknowledge www.f5debug.net as the source of the material. Such acknowledgment should include reference to www.f5debug.net in the copy of the material and should also include “© Karthikeyan Anbarasan, www.f5debug.net “. You inform the third party that these conditions apply to him/her and that he/she must comply with them.