Questions

Exchange Traded Funds (ETFs) are a relatively new phenomenon and are gaining popularity rapidly. This post outlines the key features of an ETF.

ETFs are like mutual funds because they hold an underlying asset like stocks, debt, commodities future contracts etc. If you are new to the concept of an ETF, think of it as a mutual fund, and build your understanding from thereon. An example of an ETF is the SBI Gold ETF, which holds physical gold as its underlying asset.

The city Chandigarh, being a union territory is the capital city of both Haryana and Punjab. As it is a union territory it is ruled directly by the central government and not by either states.

SQL statements are broadly classified into three. They are

1. DDL – Data Definition Language

DDL is used to define the structure that holds the data. For example, Create, Alter, Drop and Truncate table.

2. DML – Data Manipulation Language

DML is used for manipulation of the data itself. Typical operations are Insert, Delete, Update and retrieving the data from the table. The Select statement is considered as a limited version of the DML, since it can't change the data in the database. But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function.

3. DCL – Data Control Language

DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc. Example - Grant, Revoke access permission to the user to access data in the database.

A locked file can be accessed by only one user.