Cipla BioTec Interview Questions and Answers

Temporary tables are stored in tempdb while table variables are stored in memory.

• Temporary tables are created using CREATE TABLE statement while table variables are declared using DECLARE statement.

• Temporary tables can be accessed across sessions while table variables are limited to the scope of the batch, stored procedure or function.

• Temporary tables can have indexes and constraints while table variables cannot.

• Temporary tables can be dropped explicitly while table variables...read more

Synonyms are database objects that allow users to create aliases for other database objects.

• Synonyms can be used to simplify complex queries by providing a shorter name for a table or view.

• They can also be used to provide a layer of abstraction between the user and the underlying database objects.

• Synonyms can be created for tables, views, stored procedures, and other database objects.

• They can be used to reference objects in other databases or even on other servers.

• Synonyms ca...read more

An index is a database object that improves the speed of data retrieval operations on a table.

• Indexes are used to quickly locate data without having to search every row in a table.

• They are created on one or more columns of a table.

• Indexes can be clustered or non-clustered.

• Clustered indexes determine the physical order of data in a table.

• Non-clustered indexes are separate structures that contain a copy of the indexed columns and a pointer to the actual data.

• Indexes can improve...read more

Synonyms are alternate names for database objects. They are used to simplify queries and provide security.

• Synonyms are used to provide an alternate name for a database object such as a table, view, stored procedure, or function.

• They can simplify queries by providing a shorter or more meaningful name for an object.

• Synonyms can also be used to provide security by allowing users to access an object without knowing its actual name or location.

• They are created using the CREATE SYN...read more

Identity property is used in SQL to automatically generate unique values for a column.

• Identity property is used to create an auto-incrementing column in a table.

• It is commonly used as a primary key in a table.

• The identity property can be applied to numeric data types such as INT, BIGINT, etc.

• The identity value starts from a seed value and increments by a specified increment value.

• Example: CREATE TABLE Employees (ID INT IDENTITY(1,1) PRIMARY KEY, Name VARCHAR(50));