EveryBrickMatters

SQL Interview Question Set 2

Write a SQL query to print the Name of the managers with id who are having more than 3 employee under him.  employees(EMPLOYEE_ID,FIRST_N...

Joins in Database

Explain all the Joins ? An SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as ...

SQL Complex Queries Interview Question Set 1

Que : You are given a table named Employee with columns EmployeeId, Name , ManagerId in it. Write an SQL statement to find out all the mana...

View in database

What is View in database ? Why do we need to create View ? A view is virtual table which is created from one or many tables which depends ...

Different Anamolies in Database

Without normalization, it become difficult to handle and update the database without facing data loss. Insertion , Updation and Deletion An...

Trigger and Procedure in database

What is a Trigger? A Trigger is a stored procedure that is associated with insert, update or delete operations. The code is executed autom...

Difference between Primary key and Unique Constraints

What is the difference between primary key and unique constraints? Both primary key and unique key enforces uniqueness of the column on w...

Que 1:-Write a query to find the number of employee in each department. Given table is following. Emp_id Emp_name Department ...

DBMS Interview Question Set 3(Key and Integrity Rule)

What is a Key and what are the different type of Keys ? Key is an attribute or a group of attribute which work as a unique identifier to ...

DBMS Interview Question Set 2( Basic )

What are advantages of DBMS over traditional file based systems? Database management systems were developed to handle the following difficu...

DBMS Interview Question Set 1(Logical Question)

Q:-How will you search for a word in a very large database ? 1. First the group of related files are stored in different bucket using hash...