Correct answer is it depends.
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table
Only we can update a view in one base table.
A database view is a searchable object in a database that is defined by a query. Types of view in a database management system:
A. Simple view
B. Complex view
C. Readable view
D. Force view
E. Materialized view
F. Inline view
Following are the tier types in a client server application:
a. 1 tier application:All the processing is done on one machines and number of clients are attached to this machine (mainframe applications)
b. 2 tier application: Clients and data base on different machines.Clients are thick clients i.e.? processing is done at client side.Application layer is on Clients.
c. 3 tier application.Client are partially thick.Apart from that there are two more layers application layer and database layer.
d. 4 tier application: Some clients may be totally non thick clients some clients may be partially thick and further there are 3 layers web layer, application layer and database layer.
Avinash
Nov 24th, 2012
If I am not wrong
Class variables are variables which we create inside a class.
&
Class member are the variables & function declared inside class.
Manoj Kumar Chagantipati
Jun 12th, 2012
In Two tier there will be Presentation layer and Data base layer
Where as in Three tire there will be Presentation layer,Data access layer and Data base layer
Adding 2 cents
1) DELETE is DML command because it does not change data dictionary (Every command which changes data dictionary tables
is called DDL command ) TRUNCATE is DDL command is changes stor...
Ashakant Kendre
May 9th, 2016
1>TRUNCATE is a DDL command whereas DELETE is a DML command.
2>TRUNCATE is much faster than DELETE.
Reason: When you type DELETE. All the data get copied into the Rollback Tablespace first, then del...
Ans