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

Database Interview Questions and Answers

1
Explain what is SQL LITE?

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

2
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.

3
List out the standard SQL Lite commands?

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

  • SELECT
  • CREATE
  • INSERT
  • UPDATE
  • DROP
  • DELETE

Based on their operational nature these commands can be classified.

4
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.
5
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.
FOLLOW US