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

SQL Interview Questions and Answers

1
What is DBMS?

A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be termed as File Manager that manages data in a database rather than saving it in file systems.

2
SQL stands for

Structured Query Language

3
What are the properties of the Relational tables?

Relational tables have six properties:

  1. Values are atomic.
  2. Column values are of the same kind.
  3. Each row is unique.
  4. The sequence of columns is insignificant.
  5. The sequence of rows is insignificant.
  6. Each column must have a unique name.
4
How is the primary key different from a unique key?

Both the primary and unique keys uniquely identify a record in a database table. One difference is that you can have more than one unique key per table, but only one primary key. Also, the primary key does not allow any null value, while the unique key allows one.

5
What is RDBMS?

RDBMS stands for Relational Database Management System. RDBMS store the data into the collection of tables, which is related by common fields between the columns of the table. It also provides relational operators to manipulate the data stored into the tables.

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