Every Interview Asked SQL Question

What is DBMS?

Database Management System. It is a program that controls creation, use of database. DBMS manages data in database.

What is DATABASE?

Database is organized form of data for easy access, storing, retrieval and managing of data. Ex: School Management Database

What is Primary Key?

Primary Key is constraint which identify uniquely records in a table. Primary Key values cannot be null.

What is Foreign Key?

Foreign key is one table which can be related to the primary key of another table.

What is join & their types

It is a keyword used to query data from more tables based on relationship between fields of table. Types are 1. Inner join         2. Outer join  3.cross join 4.self join

Difference betweern delete 7 truncate

Delete used to remove roes from table. Truncate remove all rows from table.

What is subquery?

A query written another query is known as subquery. Outer query is main query and inner is subquery.

LOOKING FOR LATEST JOB CHECKOUT LATEST IT JOBS FOR FRESHERS AND APPLY NOW