SQL Server Architecture Question:

Download Job Interview Questions and Answers PDF

Explain what are the database objects?

MS SQL Server Architecture Interview Question
MS SQL Server Architecture Interview Question

Answer:

Database objects such as tables, primary key, and foreign key describe the structure of the content of a database. These objects also represent the properties of a server. Server side objects are objects that reside on the server but not in the database. Typical examples of server side objects include, logins, user defined error messages etc. The database objects are contained in the database project while the server objects are contained in the server project. These objects are defined in a .sql file. Most of these objects are defined in a separate file depending on the scenario. E.g it is necessary to specify columns in the same file where the table is defined

Download MS SQL Server Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
What is database architecture?What are logical database components?