Deep concepts in database
I am a student. And preparing myself for an interview. Following are some questions regarding databases, which are confusing me and i am unable to get an appropriate answer of these. please answer following questions.
1) Differentiate between database schema, meta-data and data dictionary?
2) DML(Data Manipulation Language) and DDL(Data Definition Language) are common, but what is DCL?
3) Difference between Stored Procedure and UDF?
4) Physical memory is allocated to Views or not?
5) Difference between clustered and non-clustered index? When to use which one?
6) How many possible indexes can be created for a table?
7) Can indexes be for composite keys rather than single key?
8) If I have two Tables: Employees(Emp_Id,Emp_Name) and Contact(Emp_Id,Cell_No), then find
all those employees who don't have contact numbers.
I am a student. And preparing myself for an interview. Following are some questions regarding databases, which are confusing me and i am unable to get an appropriate answer of these. please answer following questions.
1) Differentiate between database schema, meta-data and data dictionary?
2) DML(Data Manipulation Language) and DDL(Data Definition Language) are common, but what is DCL?
3) Difference between Stored Procedure and UDF?
4) Physical memory is allocated to Views or not?
5) Difference between clustered and non-clustered index? When to use which one?
6) How many possible indexes can be created for a table?
7) Can indexes be for composite keys rather than single key?
8) If I have two Tables: Employees(Emp_Id,Emp_Name) and Contact(Emp_Id,Cell_No), then find
all those employees who don't have contact numbers.
No comments:
Post a Comment