1.
Define SQL?
Answer : SQL
stands for Structured Query Language. SQL is a programming Language designed
especially for managing data in Relational Database Management System (RDBMS).
2.
What is RDBMS? Explain its features?
Answer : A
Relational Database Management System (RDBMS) is the most widely used database
Management System based on the Relational Database model.
Features of RDBMS
1.
Stores data in tables.
2.
Tables have rows and column.
3.
Creation and Retrieval of Table is
allowed through SQL.
3.
What is Data Mining?
Answer :
Data Mining is a subcategory of Computer Science
which aims at extraction of information from set of data and transform it into
Human Readable structure, to be used later.
4.
What is an ERD?
Answer :
ERD stands for Entity Relationship Diagram. Entity
Relationship Diagram is the graphical representation of tables, with the
relationship between them.
5.
What is the difference between Primary Key and Unique Key?
Answer :
Both Primary and Unique Key is implemented for
Uniqueness of the column. Primary Key creates a clustered index of column where
as an Unique creates unclustered index of column. Moreover, Primary Key doesn't allow NULL value, however Unique Key does allows one NULL value.
6.
How to store picture file in the database. What Object type is used?
Answer :
Storing Pictures in a database is a bad idea. To
store picture in a database Object Type ‘Blob’ is recommended.
7.
What is Data Warehousing?
Answer :
A Data Warehousing generally refereed as Enterprise
Data Warehousing is a central Data repository, created using different Data
Sources.
8.
What are indexes in a Database. What are the types of indexes?
Answer : Indexes
are the quick references for fast data retrieval of data from a database. There
are two different kinds of indexes.
Clustered Index
1.
Only one per table.
2.
Faster to read than non clustered as
data is physically stored in index order.
Nonclustered Index
1.
Can be used many times per table.
2.
Quicker for insert and update
operations than a clustered index.
9.
How many TRIGGERS are possible in MySql?
Answer : There
are only six triggers are allowed to use in MySQL database and they are.
1.
Before Insert
2.
After Insert
3.
Before Update
4.
After Update
5.
Before Delete
6.
After Delete
10.
What is Heap table?
Answer :
Tables that are present in the memory are called as
HEAP tables. These tables are commonly known as memory tables. These memory
tables never have values with data type like “BLOB” or “TEXT”. They use indexes
which make them faster.
Has laoreet percipitur ad. Vide interesset in mei, no his legimus verterem. Et nostrum imperdiet appellantur usu, mnesarchum referrentur id vim.
0 comments:
Post a Comment