What Is .Net Framework

The .NET Framework is designed with number of functions to fulfill some important needs of programming world.

It has code-execution environment that reduces the problem of software deployment and versioning.

It provides object-oriented programming environment whether object code is stored and executed locally or via internet, executed remotely.


Code-execution environment provides safe execution of code even if it is being created by semi-trusted third party.

.Net Framework’s code-execution environment has eliminated the performance problems of scripted or interpreted environments.

It provides consistent environment and developer experience across different types of applications, such as Windows-based applications and Web-based applications.

.NET Framework tries to ensure that it can be integrated with any other code.

for more visit
www.teachingdotnetblogspot.com

Teaching dot.net blog is now live

please visit http://www.teachingdotnet.blogspot.com

Question Bank......

Chapter 1

[2 marks question]

1. List the disadvantages of file processing system over DBMS.
2. List the advantages of DBMS over file processing system
3. Define data abstraction and its levels.
4. Enlist various types of data models.
5. List the functions of database administrator.
6. Define data independence and its types.
7. What are component of DBMS.
8. State the characteristics of DBMS[data integrity, data independence ,data abstraction,security,backup and recovery]
9. Explain any one responsibility of database manager.

[4 marks question]

1. Compare Network model and Hierarchical data model.
2. Compare Network model and relational data model.
3. Describe network model by suitable example.
4. Explain types of database users.
5. Explain the client server architecture.
6. Explain overall structure of a DBMS.
7. What is Data abstraction? Explain the levels of data abstraction.
8. What is DBMS? Explain any 2 functions of DBMS.
9. Define Query processor and explain diff. component of query processor.

Chapter 2

[2 marks question]

1. Explain the term database schema
2. Define the terms attribute,domain,tuple,relations
3. Define term primary key, foreign key and candidate key.
4. What is meant by database authorization? give one example
5. Six properties of relational data model

[4 marks question]

1. Explain the term primary key and candidate key with example
2. What is IC ? Explain any one in detail
3. What is revoke and grant privileges?

Chapter 3

[2 marks question]

1. What is statement is used in pl/sql to display the output?
2. Explain the use of truncate statement. Give example
3. Explain the use of create table statement. Give example
4. Explain the use of insert into statement. Give example
5. Explain the use of desc/describe statement. Give example
6. Explain the use of rename statement. Give example
7. Explain the use of alter table statement. Give example
8. Explain the use of select clause with an example
9. Explain the use of from clause with an example
10. Explain the use of where clause with an example
11. Explain the use of group by clause with an example
12. Explain the use of order by clause with an example
13. Explain the use commit and rollback with an example

[4 marks question]

1. Explain sql data type with an example
2. What are aggregate functions? explain with an example
3. Explain string function with an example
4. Explain set operator with an example
5. what is cursor explain different types cursor with an example
6. what is trigger explain with an example
7. explain pl/sql block structure with an example
8. Define the following
1. Weak entity
2. Strong entity
3. Partial key
4. Owner Entity

click on follwing link to dowload doc file
Question bank Doc file

PL/SQL Program

Write a program to display 10 reverse number using for loop

SQL> declare
i number;
begin
for i in reverse 1..10
loop
dbms_output.put_line(i);
end loop;
end;
.
SQL> /
10
9
8
7
6
5
4
3
2
1

PL/SQL procedure successfully completed.

Write a program to display 1 to 10 number using for loop

SQL>declare
i number;
begin
for i in 1..10
loop
dbms_output.put_line(i);
end loop;
end;

SQL> /
1
2
3
4
5
6
7
8
9
10

Functional Dependency

Functional dependency

[1]Functional dependency describes the relationship between
attributes in a relation.

[2]For example, if A and B are attributes of relation R, and B is
functionally dependent on A ( denoted A B), if each value of
A is associated with exactly one value of B. ( A and B may each
consist of one or more attributes.)




The above answer is for 2marks....for 4m giv any real time example along vth above answer

Transaction Notes

View the presentation online, or click on the link at the bottom to download the presentation and watch on your PC.

Transaction Notes

OR
Click on DOWNLOAD

TRANSACTION


****Best of luck ****

TRIGGER

What is trigger ? Explain with an example

A trigger is a pl/sql block structure which is fired when a DML statements like Insert, Delete, Update is executed on a database table. A trigger is triggered automatically when an associated DML statement is executed.

The Syntax for creating a trigger is:

CREATE [OR REPLACE ] TRIGGER trigger_name
[BEFORE | AFTER | INSTEAD OF ]
[INSERT [OR] | UPDATE [OR] | DELETE}]
ON table_name
[FOR EACH ROW]
WHEN (condition)
BEGIN
--- Sql statements
END;

For Example: The price of a product changes constantly. It is important to maintain the history of the prices of the products.

We can create a trigger to update the 'product_price_history' table when the price of the product is updated in the 'product' table.

1) Create the 'product' table and 'product_price_history' table

CREATE TABLE product_price_history
(
product_id number(5),
product_name varchar2(32),
supplier_name varchar2(32),
unit_price number(7,2)
);

CREATE TABLE product
(
product_id number(5),
product_name varchar2(32),
supplier_name varchar2(32),
unit_price number(7,2)
);

2) Create the price_history_trigger and execute it.

CREATE or REPLACE TRIGGER price_history_trigger
BEFORE UPDATE OF unit_price
ON product
FOR EACH ROW
BEGIN
INSERT INTO product_price_history
VALUES
(:old.product_id,
:old.product_name,
:old.supplier_name,
:old.unit_price);
END;

/

3) Lets update the price of a product.

UPDATE PRODUCT SET unit_price = 800 WHERE product_id = 100

Once the above update query is executed, the trigger fires and updates the 'product_price_history' table.

4)If you ROLLBACK the transaction before committing to the database, the data inserted to the table is also rolled back.