SQL - கேள்வி பதில் பகுதி - 1

Q 1 Explain the difference between system objects and user objects.

A. SQL Server creates system objects during the installation process. They are part of the system, and most of them are necessary for SQL Server to function properly. Whereas system objects are part of the SQL Server system, you create user objects. User objects include the databases, stored procedures, functions, and other system objects that you build.

Q2 . Describe normalization.

A. Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Normal forms are a progression of these rules. Each successive level of normal form achieves a better database design than the previous one. It is generally sufficient to apply the first three levels of normal forms to your data.

Q 3 . What is the difference between a DDL trigger and a DML trigger?

A. A DDL trigger executes in response to a change to the structure of a database (for example, CREATE, ALTER, DROP). A DML trigger executes in response to a change in data (INSERT, UPDATE, DELETE).

Q 4. Discuss the advantages of SQL Server 2005 Express.

A. SQL Server 2005 Express is free and is easy to use. It provides the same protection and information management provided by more sophisticated versions of SQL Server. It is easy to install, provides rich database functionality, and sports deep integration with Visual Studio 2005.

Q 5. Name some limitations of SQL Server 2005 Express.

A. SQL Server 2005 Express limits you to one gigabyte of RAM, a four-gigabyte maximum database size, and support for only one CPU. Furthermore, it does not come with either a job scheduling server or a database tuning advisor.

Q 6. Name some advantages of SQL Server 2005 Mobile Edition.

A. SQL Server 2005 Mobile Edition enables you to port applications to mobile devices. It provides full integration with SQL Server 2005, and even includes synchronization functionality. It offers excellent reliability and performance, as well as multi-user support. Finally, it provides full integration with Visual Studio 2005 and increased device support.

Q 7. Explain what the Master database is used for.

A. The Master database is the database of all databases. It keeps track of all the login accounts, linked servers, system configuration settings, and more. It also contains initialization settings for SQL Server.

Q 8. Explain how you utilize the Model database.

A. Model is a very special database. Any objects that you place in Model propagate automatically to any new databases that you create. This provides standardization as well as rapid application development.

Q 9. Describe MSDB and what it does.

A. MDSB stores data, including scheduling information and backup and restore history information.

Q 10. What is the difference between a check constraint and a rule?

A. Both check constraints and rules limit the range of values that a user can enter into a column. Whereas check constraints apply only to the table for which you enter them, you can apply rules to multiple tables.