+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

Database Interview Questions and Answers

Explain what is SQL LITE?

SQL LITE is a mostly ACID compliant relational database management system contained in a relatively small C programming library.

Comment on Transactions.

- Using transactions we can group all SQL commands into a single unit.
- The transaction begins with some task and finishes only when all tasks within it are over.
- The transaction gets over successfully only when all commands in it are successfully over. Even if one command fails, the whole transaction fails.
- The BEGIN TRANSACTION, ROLLBACK TRANSACTION, and COMMIT TRANSACTION statements are used to work with transactions.
- A group of tasks starts with the begin statement.
- In case of any problem, the rollback command is executed to abort the transaction.
- If all the tasks run successfully, all commands are executed through commit statement.

List out the standard SQL Lite commands?

The standard SQL Lite commands interact with relational databases are similar to SQL. They are

  • DROP

Based on their operational nature these commands can be classified.

Define the "integrity rules"?

There are two Integrity rules.

  • Entity Integrity: States that "Primary key cannot have NULL value"
  • Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.
What is database?

A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.