1. Short note: database, data, application, metadata, RDBMAS, data integrity.
Database: A collection of information, preferably related information, and preferably organized.
Data: A term applier to organized information.
Application: A front end tool used by developers, in-house staff, and-users to access a database.
Metadata: data is the data about the data.
RDBMS: Relational database management system.
Data integrity: The validity of data is called Data integrity.
2. Name the different type database.
Ans: Three type of database are available.
1. Transactional.
2. Decision support system (DSS).
3. Hybrid.
3. What do you mean by transitional database?
Ans: A transactional database is a based on small change to the database. Two types database are Client server database & OLTP database.
4. What is database modeling? Write down the different database model techniques?
Ans: A model used to organized and apply structure to other disorganized information.
The different database model techniques are 1. File system 2.Hierarchical 3.Network 4.Relational 5.Object 6. Object-Relational
4. What are the methods you have to follow to design a database?
1. Requirement analysis.
2. Conceptual design
3. Logical design
4. Physical design
5. Tuning phase
5.What are business rules? Write down the aspects of business rule.
Business rule: business rules for an organization are the process & flows whatever is involved in daily working activities of that organization.
Aspects of business rules are:
1.any types of organization policies.
2.any types of calculation or formula.
3.any types of regulation.
6.What is data type? Write down the sections of data type.
Data type: Data type restrict the values in the fields.
Sections of data types are :1.simple data type , 2.complex data type,3.spealized data type.
7.What is constraints? Give some examples
Constraint: Constraints restricts the values that are allowed in the table fields.
Some of examples of constrains are Not null, validation check , keys.
8. Shortly brief the key constrain.
Key constraint: Key constraints include the primary keys ,foreign keys ,unique keys .Key constraints allow the checking and validation of values between the fields in different tables. Primary keys and foreign keys are used in relationships between the parent tables and child tables.
9.What is normalization? Write down its benefits.
Normalization : Normalization removes the duplication of data minimize the chunk of redundant
Benefits of normalization:
(1).physical space is reduced
(2).Data becomes best organized .
(3).A single table record is updated.
10.What are difference between primary key & unique key?
Ans: primary keys:- A primary key is used to uniquely identify a record in a table .A primary key doesn’t allow duplicate & null value.
Unique keys:- A unique key is created on a field containing only unique values trough out an entire table. Unique keys allows null value.
11.Shortly brief : view, index, PK ,UK & FK.
Ans:view :-A logical overlay containing a query , executed whenever the view is accessed . Repeated query execution can make views very inefficient in busy environment.
Index:- An index is usually a copy of a very small section of table , such as a single field & short length field.
PK:- A primary key is used to uniquely identify a record in a table .A primary key doesn’t allow duplicate & null value.
UK:- A unique key is created on a field containing only unique values trough out an entire table. Unique keys allows null value.
FK:- A foreign key define the reference for each record in the child table , referencing back the primary key in the parents table.
12.What do mean by functional dependency?
Functional dependence: “Y” is functionally dependent on ” X” if the value of “Y” is determined by “X”. in other words if Y=X+1, the value of “X” resultant value of “Y”
13.What is SQL?
Ans: SQL means that structure Query Language. It used to access data in a relational database.
Write down the different types of Query Commands and change commands.
14.Write down different types of query commands & data changes commands.
Query commands:- 1.Basic query 2. Filtered query 3. Sorted query 4. Aggregated query 4. Join query 5. Nested query 6. Composite query
Data change commands:- Insert, Update, Delete
15.Define shortly : Nested quire, composite query.
Nested quire: A nested query is also know as a sub query, which is a query contained within another query.
Composite query: A composite query is a query that merges multiple query results together, most often using the UNION keyword.
16.Define shortly: Inner join, Cross join, Outer join and self join?
Inner join: An intersection between two table using matching field values. Retuning records common to both tables only.
Cross join: This is also known mathematically as a Cartesian product. A cross join merges all records in one table with all records in another table, regardless of any matching values.
Outer join: An intersection plus rows outside the intersection, in one table and not in the other table of a join.
self join: A self join simply joins a table to itself, and is commonly used with a table containing a hierarchy of records.
17. Write down the demoralization Tricks?
Ans: – demoralization Tricks are :
1. Separate active and inactive data.
2. Copy fields between tables.
3. Summary fields in parent tables.
4. Separate heavily and lightly accessed fields.
18. What is a star schema?
Ans: The most effective approach for a data warehouse database model is called a star schema.
19. What is a snowflake schema?
Ans: A data warehouse, single fact table structure with dimension tables in multiple layered hierarchies of dimensional tables.
20. What are fact table and Dimension table?
Fact table: A term generally applying to an unstructured file, such as a text file.
Dimension table: A descriptive or static data table in a data warehouse.