Q. Explain the use of the Join keyword and its various types.




Answer:-. The join keyword is very powerful in SQL. It can be used to combine rows from multiple tables by using common values in certain fields. The type of join decides which rows are to be selected, while the select statement specifies which fields to include in the combination table.

Inner Join
This is the default type of join. It picks all rows that have matching fields, or in other words, that meet the join condition.

Outer Join
·         A right outer join picks all rows from the table on the right, even if they do not meet the join condition. Some fields in such rows may have null values in the resulting table.
·         A left outer join returns all rows of the left-side table, irrespective of their match with the right-side table.
·         A full outer join returns all rows of the left- and right-side tables.

Self Join
This is a special type of join where a table joins to itself.

Cross Join
This is the Cartesian product of rows from the tables included in the join query statement. In other words, every row from the first table is combined with every row of the second table, one at a time.

Q. What are Database ACID properties and their full form?

Answer:-
 Database ACID properties are:
A-Atomocity
C-Consistency
I-Isolation
D-Durability

Atomicity-Atomicity refers to the ability of the database to guarantee that either all of the tasks of a transaction are performed or none of them are.

Consistency-The consistency property ensures that the database remains in a consistent state before the start of the transaction and after the transaction is over (whether successful or not).

Isolation-Isolation refers to the requirement that other operations cannot access or see the data in an intermediate state during a transaction.


Durability-Durability refers to the guarantee that once the user has been notified of success, the transaction will persist, and not be undone. This means it will survive system failure, and that the database system has checked the integrity constraints and won't need to abort the transaction. 

Q. Can Primary key is a Foreign Key on the same table?

Answer: Yes, Primary key can act as  a Foreign Key on the same table.
For Example:-

CREATE TABLE T (
   GroupID int not null,
   ItemID int not null,
   ParentItemID int null,
   constraint PK_T PRIMARY KEY (GroupID,ItemID),
   constraint FK_T_Parent FOREIGN KEY (GroupID,ParentItemID) 
 references T (GroupID,ItemID)
)

What are non-perfoming assets?

What are non-perfoming assets? 
Answer:   Non-performing assets, also called non-performing loans, are loans,made by a bank or finance company, on which repayments or interest payments are not being made on time. A debt obligation where the borrower has not paid any previously agreed upon interest and principal repayments to the designated lender for an extended period of time. The nonperforming asset is therefore not yielding any income to the lender in the form of principal and interest payments.

What is Linked Account?

Linked Account
Any account linked to another account in the same bank where funds can be transferred electronically between accounts and carry out other specified services as well.

What is SEZ or Special Economic Zone?


What is SEZ  or  Special Economic Zone?
Answer : SEZ means Special Economic Zone is the one of the part of government’s policies in India. A special Economic zone is a geographical region that economic laws which are more liberal than the usual economic laws in the country. The basic motto behind this is to increase foreign investment, development of infrastructure, job opportunities and increase the income level of the people.