11. What do you mean by schema?
Ans: Friends the description of a data base is called the database schema, which is specified during database design and is not expected to change frequently. A displayed schema is called schema diagram .We call each object in the schema as schema construct.
12. What are types of schema?
Ans: Friends
1. internal schema.
2. Conceptual schema.
3. External schemas or user views.
13. What do you mean by Data independency?
Ans: Friends Data independency is defined as the capacity to change the conceptual schema without having to change the schema at the next higher level. We can define two types of data independence:
1. Logical data independence.
2. Physical data independence.
LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.
PDI is the capacity to change the internal schema without having to change conceptual (or external) schemas.
14. What are different DATABASE MANAGEMENT SYSTEM languages?
Ans: Friends
1. DDL (Data definition language)
2. SDL (Storage definition language)
3. VDL (View definition language)
4. DML (Data manipulation language)
15. What do you mean by data ware housing & OLAP?
Ans: Friends Data warehousing and OLAP (online analytical processing) systems are the
techniques used in many companies to extract and analyze useful information
from very large databases for decision making.
16. What are different types of DATABASE MANAGEMENT SYSTEM?
Ans: Friends
1. DATABASE MANAGEMENT SYSTEM
2. RDATABASE MANAGEMENT SYSTEM (Relational)
3. ORDATABASE MANAGEMENT SYSTEM (Object Relational)
4. DDATABASE MANAGEMENT SYSTEM (Distributed)
5. FDATABASE MANAGEMENT SYSTEM (Federated)
6. HDDATABASE MANAGEMENT SYSTEM (Homogeneous)
7. HDATABASE MANAGEMENT SYSTEM (Hierarchical)
8. NDATABASE MANAGEMENT SYSTEM (Networked)
17. What do you mean by ORDATABASE MANAGEMENT SYSTEM?
Ans: Friends object oriented RDATABASE MANAGEMENT SYSTEM is a relational DATABASE MANAGEMENT SYSTEM in which everything is treated as objects. User can define operations on data as a part of the database definition.
18. What do you mean by an entity?
Ans: Friends an entity is a thing in the real world with an independent existence.
19. What are attributes?
Ans: Friends these are the particular properties that describe an entity.
20. What are diff. types of attributes?
Ans: Friends
1. Composite Vs simple attributes.
2. Single valued Vs multi-valued attributes.
3. Stored Vs derived attribute.
4. Null valued attributes.
5. Complex attributes.
Ans: Friends the description of a data base is called the database schema, which is specified during database design and is not expected to change frequently. A displayed schema is called schema diagram .We call each object in the schema as schema construct.
12. What are types of schema?
Ans: Friends
1. internal schema.
2. Conceptual schema.
3. External schemas or user views.
13. What do you mean by Data independency?
Ans: Friends Data independency is defined as the capacity to change the conceptual schema without having to change the schema at the next higher level. We can define two types of data independence:
1. Logical data independence.
2. Physical data independence.
LDI is the capacity to change the conceptual schema without having to change external schemas or application programs.
PDI is the capacity to change the internal schema without having to change conceptual (or external) schemas.
14. What are different DATABASE MANAGEMENT SYSTEM languages?
Ans: Friends
1. DDL (Data definition language)
2. SDL (Storage definition language)
3. VDL (View definition language)
4. DML (Data manipulation language)
15. What do you mean by data ware housing & OLAP?
Ans: Friends Data warehousing and OLAP (online analytical processing) systems are the
techniques used in many companies to extract and analyze useful information
from very large databases for decision making.
16. What are different types of DATABASE MANAGEMENT SYSTEM?
Ans: Friends
1. DATABASE MANAGEMENT SYSTEM
2. RDATABASE MANAGEMENT SYSTEM (Relational)
3. ORDATABASE MANAGEMENT SYSTEM (Object Relational)
4. DDATABASE MANAGEMENT SYSTEM (Distributed)
5. FDATABASE MANAGEMENT SYSTEM (Federated)
6. HDDATABASE MANAGEMENT SYSTEM (Homogeneous)
7. HDATABASE MANAGEMENT SYSTEM (Hierarchical)
8. NDATABASE MANAGEMENT SYSTEM (Networked)
17. What do you mean by ORDATABASE MANAGEMENT SYSTEM?
Ans: Friends object oriented RDATABASE MANAGEMENT SYSTEM is a relational DATABASE MANAGEMENT SYSTEM in which everything is treated as objects. User can define operations on data as a part of the database definition.
18. What do you mean by an entity?
Ans: Friends an entity is a thing in the real world with an independent existence.
19. What are attributes?
Ans: Friends these are the particular properties that describe an entity.
20. What are diff. types of attributes?
Ans: Friends
1. Composite Vs simple attributes.
2. Single valued Vs multi-valued attributes.
3. Stored Vs derived attribute.
4. Null valued attributes.
5. Complex attributes.
