#2
| |||
| |||
Re: HCL Database Interview Questions
Some questions for preparation for Database Interview of HCL Technologies are as follows: What is DBMS? What is RDBMS? What is SQL? What are the different type of SQL's statements? What are the Advantages of SQL? What is a field in a database? What is a Record in a database? What is a Table in a database? Define Trigger Define stored procedure. Explain - a.) Storage Manager b.) Buffer Manager c.) Transaction Manager d.) File Manager List some advantages of DBMS. Explain the various types of normalization. What are the advantages of normalizing a database. What is Denormalization? Differentiate between Delete and Truncate table. Differentiate between Extension & Intension. Explain Data Independence & its types. Explain a. Entity b. Entity Type c. Entity Set Explain a.) Partial key b.) Alternate key c.) Artificial key d.) Compound key e.) Natural key Explain Phantom Deadlock. What is a view? What are the advantages of views in a database? What are the disadvantages of views in a databa What do you mean by Cluster and Non cluster Index? What are B-trees? What is Table Scan and Index Scan? Explain Database partitioning. What is its importance? What are properties of a transaction? |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
BNP Paribas Interview Questions for MBA | Saksham | Online MBA Discussions | 2 | 18th April 2018 10:03 AM |
MBA Graduates Interview Questions | payal | Online MBA Discussions | 2 | 17th April 2018 04:22 PM |
UAE Embassy Interview Questions | mamta | Online MBA Discussions | 2 | 8th April 2018 04:08 PM |
Questions of MBA Interview | mamta | Online MBA Discussions | 2 | 7th April 2018 01:00 PM |
IIT Kanpur MBA Interview Questions | payal | Online MBA Discussions | 2 | 7th April 2018 11:14 AM |
LG Interview Questions for MBA | payal | Online MBA Discussions | 2 | 2nd April 2018 10:34 AM |
DBA Oracle Interview Questions | kavita | Online MBA Discussions | 2 | 28th February 2018 11:57 AM |
TCS Technical Interview Questions | Unregistered | Main Forum | 1 | 4th November 2015 11:58 AM |
Rsm MBA interview questions | Saksham | Main Forum | 0 | 22nd October 2015 09:20 AM |
Hal Interview Questions Instrumentation | Tearmalap | Main Forum | 2 | 30th September 2013 11:18 AM |
EIL Interview Questions | Harinderf | Main Forum | 1 | 30th March 2013 12:27 PM |
CDS Interview Questions Answers | Jigishas | Main Forum | 1 | 30th March 2013 09:36 AM |
MBA HR Subject Interview Questions | shailja dixitmk | Main Forum | 1 | 15th March 2013 11:52 AM |
IIM Interview Questions | gksahu3 | Main Forum | 1 | 16th February 2013 01:38 PM |
NIIT interview questions | Rajani Kanagond | Main Forum | 1 | 21st January 2013 03:01 PM |
VB 100 Interview Questions | Unregistered | Main Forum | 1 | 17th December 2012 04:42 PM |
NIIT Interview Questions Qtp | gsudeep.j | Main Forum | 1 | 31st October 2012 10:25 AM |
Typical MBA Interview Questions | dipjyoti.t | Main Forum | 1 | 30th October 2012 12:25 PM |
APGENCO Interview Questions | Sintayehu Denbi.u | Main Forum | 1 | 28th October 2012 12:08 PM |
SSC Interview Questions CGL | Unregistered5 | Main Forum | 1 | 25th August 2012 03:40 PM |
Thread Tools | Search this Thread |
|