1) What is Index and types of Index?
Ans: - An index is an internal part of the database that provides a quick access to the rows of a tabl based on the value of one or more columns.
There are two types of index.
i) Cluster Index.
ii) Non Cluster Index.
2) What is Cursor?
Ans: - Cursor is a database object that can be helps tp accessing and manipulating the data in a given result set.
3) What is locking in database?
Ans:- Locking can be used in the database to ensure transactional integrity and database consistency.
4) What is Deadlock?
Ans: - Deadlock is a situation I which two users have locks on separate objects and each user is wetting for a Lock on the other objects.
5) What is Schema Locks?
Ans: - Schema Locks can be used by the database when any Data Definition Language (DDL) operation is being performed on a table.
6) What is Transactions?
Ans: - Transactions can be defined as a sequence of operations performed together as a single logical unit of work.
There are four types of properties i.e ACID.
i) Atomicity.
ii) Consistency.
iii) Isolations.
iv) Durability.
7) What is Trigger?
Ans: - A trigger is a block of code that are activate in response to certain action. i.e any DML statements (Insert, Update, Delete) can executed it is automatically fired.
8) What is Join and types of Join?
Ans: - It is a operation that includes the retrieval of data from more than one table at a time.
i) Inner Join..
ii) Outer Join.
iii) Cross Join.
iv) Equi Join.
v) Natural Join.
vi) Self Join.
9) What is View?
Ans: - View is a virtual table which gives access a subset of columns from one or more tables.
10) What is Database? How many types of system Database?
Ans: - A database is a collection of tables and objects such as Index, View, Stored Procedure and Triggers.
There are four types of System Databases.
i) Master
ii) Tempdb
iii) Model
iv) Msdb.
11) The Data and objects in a database are stored in hw many types of files and what are they?
Ans: - The data and objects in a database are stored in 3 types of files.
i) Primary Data File.
ii) Secondary Data File.
iii) Transaction Log File.
A database must consist of a Primary data file and Transaction Log File.
12) What is a constraint? Types of constraints?
Ans: - The constraints are creating to ensure the data integrity. It defines the rules that must be followed to main the consistency are correctness of data.
Types of Constraints: i) Primary Key Constraints.
ii) Unique Constraints.
iii) Foreign Key Constraints.
iv) Check Constraints.
v) Default Constraints.
13) What is Data Integrity and Types of Integrity?
Ans: - Data Integrity ensure the Consistency and correctness of data stored in a database.
Types of Integrity: - i) Entity Integrity.
ii) Domain Integrity.
iii) Referential Integrity.
iv) User-defined Integrity.
14) What is stored procedure? Types of procedure?
Ans: - A stored procedure is a collection of T-SQL statements and control of flow language that is store under one name and executed as a single unit. It helps in improving the performance of a query.
Types of stored procedure: - i) User defined stored procedure.
ii) System stored procedure.
iii) Temporary stored procedure.
iv) Remote stored procedure.
v) Extended stored procedure.
No comments:
Post a Comment