|
By Nishant Kumar
Describe in brief Databases and SQL Server Databases Architecture.
Databases
-
A database is a structured collection of data.
-
Database can be thought as simple data file.
-
It is more powerful than data file which stores data in organized way.
-
Database organizes the data into a table. It is made up of several tables with
rows and columns.
|
SQL Database Architecture
SQL database is divided into logical and physical components.
Logical Component
Logical components comprises of following:
Database objects,
Collation,
Login, Users, Roles and groups.
Physical component
Physically components exist as two or more files on disk.
Physically files can be of three types.
Primary data files
This is starting point of the database and contain pointer to point
other files. Extension is mainly .mdf .
Secondary data files
It consists of data other than primary data file. Extension is mainly .ndf
.
Log files
It contains log information which is used to recover
database.
SQL Server database architecture - Nov 18, 2008 at 15:30 pm
by Rajmeet Ghai
What are database files and filegroups?
Answer
Database files are used for mapping the database over some operating
system files. Data and log information are separate. SQL server database has
three types of database files:
Primary: starting point of a database. It also points to other
files in database. Extension: .mdf
Secondary: All data files except primary data file is a part
of secondary files. Extension: .ndf
Log files: All log information used to recover database.
Extension: .ldf
The answers to following questions will be made available soon. Keep
visiting.
Describe in brief database architecture.
Explain logical database components.
What are the database objects? Explain them in brief.
Illustrate physical database architecture in brief.
What are pages and Extents?
SQL
Server Interview questions part 2 includes following questions with
answers
Difference between DELETE and TRUNCATE commands in SQL
Server. | What are constraints in SQL Server? | What is an index? | What is
RAID? | Ways to troubleshoot performance problems in SQL Server. | Steps to
secure an SQL Server. | What is a deadlock and what is a live lock? | What is
blocking and how would you troubleshoot it? | Ways of moving data between
servers and databases in SQL Server? | Explian different types of BACKUPs
avaialabe in SQL Server? | What is database replicaion?
It is the process of organizing data into related table. To normalize database,
we divide database into tables.....
The column or columns of the table whose value uniquely identifies each row in
the table is called primary key. You can define column as primary key using
primary key constraint while you create table.....
This is the default and recommended security mode. In this mode, access to SQL
server is controlled by Windows NT.....
It is
system variable that returns error code of the SQL
statement.....
|