Shathana. S.R.

Cursors are known to be the extensions to result in sets that are the group of rows returned for a statement. They help retrieve one or more blocks of rows from the current position. Similarly, they can […]

Default is the value specified for a column in a database table. This value will be duplicated in all the new records of the column unless there is no other value specified.

Generally, stored procedures are the blocks of codes that can be accessed by simple application calls. At the same time, extended stored procedures help expand the functionality of SQL servers through […]

It is a function that consists of a group of statements, which can be stored and used repeatedly.

The following are the modes of transactions: Autocommit transactions Explicit transactions Implicit transactions Batch-scoped transactions

There are three types of attributes, as mentioned below: Free-form attributes Domain-based attributes File attributes

There are three types of attributes, as mentioned below: Free-form attributes Domain-based attributes File attributes

Attributes are the objects that are included in master data service entities. Also, attribute values are used to describe the members of the entity.

Entities are nothing but objects that are stored in the master data services models.

Entities are nothing but objects that are stored in the master data services models. They are real-world objects that can be distinguishable from other objects.

RDBMS is nothing but – Relational DataBase Management System. It is the software that allows storing, managing, querying, and retrieving data from a relational database.

A relational database is the collection of data that have an established relationship with each other.

A database is a structured form of data storage where data can be retrieved and managed efficiently. It is the collection of tables where the data is stored in an organized way.

In Microsoft Excel, the LOOKUP function returns a value from a range or an array.

Excel provides three ways to protect a workbook: Password protection for opening a workbook Protection for adding, deleting, hiding and unhiding sheets Protection from changing size or position of windows.

Following are the types of report formats Compact Report Tabular

To resize the column, you should change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from […]

Name Box is used to return to a particular area of the worksheet by typing the range name or cell address in the name box.

To add a new Excel worksheet, you should insert worksheet tab at the bottom of the screen.