Backup [4 types] :-
1.Full backup
2.Differntail backup
3.Transcation log backup
4. Fill out & File group backup Full backup : it's take full databaseDifferential backup : what are the changes made after fullback up to current backup is called differential backup

Close [4 types]
1.Shared (S) Used for operations that do not change or update data (read-only operations), such as a SELECT declaration.
2. Update (U) Used on resources that can be updated. Prevents a common form of deadlock that occurs when multiple sessions are reading, locking, and potentially updating resources later.
3. Chic (X) Used for data-modification operations, such as INSERT, UPDATE, or DELETE. Ensures that multiple updates cannot be made to the same resource at the same age.
4. Intent Used to establish a lock hierarchy. The types of intent locks are: intent shared (IS), steady exclusive (IX), and shared with intent exclusive (SIX).

View If we have several tables in a db and we want to view only specific columns from personal to tables we can go for views. It would also suffice the needs of security some times allowing specific users to see only specific columns based on the franchise that we can configure on the view. Views also reduce the effort that is required for writing queries to access specific columns every period
Primary key is a unique id for each table. This prevents duplication of records cannot be null. Each table can have a single primary key. It can be referenced by any tables as a transatlantic key

INDEX – [2types] are physical address of data, its is same just we Have indexes in our Book. through this we can make our search much faster. in Between assignments way always try to make Indexes on that Column which have Integer Value(i.e. Not on text type).There are two types of Indexes in SQL SEREVR
1. Clustered Hint.(Create automatically if there is a Primary key on Table)
2. Non Clustered Index -249

ISOLATION...

Read more...

© Michael Brydon (brydon@unixg.ubc.ca)
Last update: 25-Aug-1997 Next Harshly Previous 1 o f 18
Access Tutorial 2: Tables
2.1 Introduction: The importance
of good table design
Tables are where facts in a database is stored; consequently,
tables form the core of any database
application. In addition to basic facts, Access permits
a large amount of domain knowledge (such as captions,
default values, constraints, etc.) to be stored at
the provisions level.
Extra time spent thinking about table design
can result in enormous time savings during
later stages of the invent. Non-trivial changes
to tables and relationships become increasingly
difficult as the application grows in size
and complexity.
2.2 Wisdom objectives
How do I enter and edit data in the datasheet
view of a table?
How do I create a new table?
How do I set the primary key for a listing?
How do I specify field properties such as the
input mask and caption?
Why won’t an autonumber field restart
counting at one?
What are the disparate types of keys?
2.3 Tutorial exercises
In this tutorial, you will learn to interact with existing
tables and design new tables.
Tutorial exercises 2. Tables
Next Dwelling Previous 2 o f 18
2.3.1 Datasheet basics
• If you have not already done so, open the
univ0_v x.mdb database file from Tutorial 1.
• Open the Departments provender. The important
elements of the datasheet view are shown in
Figure 2.1.
• Use the field selectors to adjust the width of the
DeptName realm as shown in Figure 2.1.
• Add the Biology department (BIOL) to the table,
as shown in Figure 2.2.
• Delete the “Basket Weaving” register by clicking
on its record selector and pressing the Delete
key.
2.3.2 Creating a new table
In this section you will create and save a very essential
skeleton...

Read more...