SQL INTERVIEW QUESTION & ANSWERS
31. |
Can multiple conditions be used in the WHERE clause? |
|
Yes. multiple conditions can be specified in the WHERE clause of SELECT,
INSERT, UPDATE, and DELETE statements. |
32. |
Is SQL a procedural or non-procedural language? |
|
SQL is non-procedural, meaning that the database decides how to execute the SQL statement. The extensions discussed during this hour were procedural. |
33. |
Define the term data dictionary? |
|
Data dictionary is a repository of information describing the data in the database, that is the metadata. Data dictionary is a file that contains Metadata or data about data. |
34. |
What are the various types of databases? |
|
The different types of databases are:
- Multimedia database
- Spatial database (Geographical Information System Database)
- Real–time or Active Database
- Data Warehouse or On–line Analytical Processing Database
|
35. |
Define Data Model? |
|
It is a collection of concepts that can be used to describe the structure of a
database. The datamodel provides necessary means to achieve the abstraction i.e., hiding the details of data storage.
|