101. What are the four objectives of the selection of a data type? A data type should be selected so that all possible values are represented using minimal storage space. …
May 2016
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-10
by Sby S91. Explain the difference between total specialization and partial specialization. Total specialization exists when every instance of a supertype must also be an instance of a subtype. Partial specialization exists …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-9
by Sby S81. Briefly explain the five components of an Information Systems Architecture and their relationship to data. Processes that manipulate the data. Networks that transport the data. People who process and …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-8
by Sby S71. What is a data mart? A data mart is a collection of data smaller in scope and size than a data warehouse. It is dedicated to data from a …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-7
by Sby S61. Why is XML a better markup language than HTML? XML is a better markup language than HTML, primarily because XML provides a clear separation between document structure, content, and …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-6
by Sby S51. What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the entire database. A differential backup makes a copy of …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-5
by Sby S41. Explain the difference between an exclusive lock and a shared lock. An exclusive lock prohibits other users from reading the locked resource; a shared lock allows other users to …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-4
by Sby S31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built from other tables or views. Views are used to (1) …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-3
by Sby S21. Explain the relationship between entity, entity class, and entity instance. An entity is something that can be identified in the users’ work environment, something that the users want to …
- DBMSInterview Questions and AnswersTechnical Interview Questions and Answers
Database Management System Interview Questions and Answers For Freshers and Experience Part-2
by Sby S11. Discuss the alternative terminology that is used in the relational model. Relations are also called tables, and sometimes by the older data processing term files. A row is known …