SQL SERVER INTERVIEW QUESTION & ANSWERS
| 11. |
What is Log Shipping? |
| |
SQL Server now offers integrated log-shipping capabilities. Configuring log shipping creates a "warm" standby server by continually backing up and restoring transaction logs from one database to another. These standby servers
can be used in the event of a server failure or for read-only applications such as reporting, in which activity can be offloaded, eliminating the impact on the primary server. |
| 12. |
What is MASTER Data Base? |
| |
The Master database is the primary configuration database in SQL Server. It contains information on all the databases that exist on the server, including the physical database files and their locations. The Master database also contains
SQL Server’s configuration settings and login account information. |
| 13. |
What information does MASTER Data Base contains? |
| |
- Server Registrations and Remote Logins
- Local Databases and Database Files
- Login Accounts
- Processes and Locks
- Server Configuration Settings
|
| 14. |
Define TempDB. |
| |
SQL Server uses the TempDB database for working storage of temporary tables and temporary stored procedures. Temporary stored procedures and tables can be created by users, applications, or the system to support query requests.
The TempDB database is recreated each time SQL Server starts, so the TempDB should not be used for persistent data storage. Temporary tables and procedures that are generated by SQL Server are automatically dropped when connections are closed; therefore, under no connection activity, the TempDB is empty. |
| 15. |
Explain msdb. |
| |
The msdb database is a system database that is used by several SQL Server components such as the SQL Server Agent service. In addition to SQL Server Agent configuration and task information, replication, log shipping, and maintenance plan data are stored in the msdb database. |
