Database Programming

View in SQL is a virtual table.It is possible to add SQL functions ,WHERE and JOIN statements to a view.This will help in presenting the data as if coming from a single table.It is possible to update the view also .We can drop a view also if not needed.

yes this is wath i would like to know i would like to receive my will and testement from the London scottish bank and he is asking me to send a big amount of money for me to receive my will.please advise if he is a official from the bank.thank you

It provides a better and faster method to search a particular item you are looking for. When you issue a select statement to have a particular item with some condition, it searches the whole DB to get the answer for you. Instead if you have some indexes to it, the searching is done faster.

FALSE....

cuz in && operator the compiler chk both of the expression if any of the expression is false then answer will be false..

for true result both of d expression must be true...

by warrior2pnk

Advantages of Distributed Systems over Centralized ones

1:Incremental growth:Computing power can be added in small

increments

2:Reliability:If one machine crashes, the system as a whole can

still survive

3:Speed:

A distributed system may have more total computing power than a

mainframe

4:Open system:

This is the most important point and themost characteristic point

of a distributed system.

Since it is an open system it is always ready to communicate with

other systems.

an open system that scales has an advantage over a perfectly closed

and self-contained system.

Economic:ANd Microprocessors offer a better price/performance than

mainframes

Disadvantages of Distributed Systems over Centralized ones

1:As i previously told you distributed systems will have an

inherent security issue.

2:Networking:If the network gets saturated then problems with

transmission will surface.

3:Software:There is currently very little less software support for

Distributed system.

4:Troubleshooting:Troubleshooting and diagnosing problems in a

distributed system can also become more difficult, because the

analysis may require connecting to remote nodes or inspecting

communication between nodes.

To design my own distribute system i would do the following:

1:Distributed users always pose a threat to be exposed by

hackers.Therefore I'l create groups of users and will provide them

constrained access to data.

2:Authentication required by all users who use the system.

3:encryption..that is for message protection,

4:The whole Domain is also to be protected via firewalls..so i

would install good Firewalls.

5:Would install good anti viruses on my machines which are a part of the distributed system, as these systems are prone to the domino effect that is if one system gets effected the whole network will be susceptible to becoming effected.

6:Design:

As far as possible I'll keep the design simple and as local as possible.Will probably use a virtual private network.

Will use machines that are compatible with each other.

Will enforce secure access on all users.

Will probably save the most important, the database on another well equipped machine so that it has a system that is only dedicated to look after the database.

without you will not be able to create a relationship

The qualifier signed or unsigned may be applied to char or any integer. unsigned numbers are always positive or zero, and obey the laws of arithmetic modulo 2n, where n is the number of bits in the type. So, for instance, if charsare 8 bits, unsigned charvariables have values between 0 and 255, while signed charshave values between -128 and 127 (in a two's complement machine.) Whether plain charsare signed or unsigned is machine-dependent, but printable characters are always positive.

unique key

The term SQL alone implies Structured Query Language as per the ANSI standard. Every Database Management System (DBMS) has its own "software" that makes it work. That being said, the term "SQL DBA" alone does not make any sense without mentioning the vendor specific DBMS you are managing. So, an SQL Server DBA is an administrator of Microsoft's SQL Server.

160 characters it all depends on what phone

Simplicity is more complex, it makes the design look clean, and professional.

There are lots of programs that can be used to create databases. People use programs like Microsoft Access. They use Oracle. They use dBase. They use MySQL. They use many others. People can also write their own programs to do it.

Normalization is a process of reducing redundancies of data in a database. If you don't normalize you will have to repeat data entry.

s

Because 4nf minimize the redundancy as well as make storage management..

1. Yale University
2. University of Michigan

Sales inventory,

Shipment time frame,

customer service,

Replace Inventory,

Track sales persons selling list

#include <stdio.h>

static int statv;

int main (void)

{

int localv;

printf ("static at %p, automatic at %p\n", &statv, &localv);

return 0;

}

businesses need report beacuse they are useful

30

Disclosed which assists in finding errors in a reference database by making comparisons to an interchange database. The reference and interchange databases containing first and second groups of related data strings. The data strings from the first groups are compared to find matching datmatch. When no matching conditions are detected, an error indication is generated.

mhgm hgm

dBm is defined as power ratio in decibel (dB) referenced to one milliwatt (mW). It is an

abbreviation for dB with respect to 1 mW and the "m" in dBm stands for milliwatt.

dBm is different from dB. dBm represents absolute power, whereas in audio engineering the

decibel is usually a voltage ratio of two values and is used then to represent gain or attenuation

of an audio amplifier, or an audio damping pad.

There are following types of users:

§ Database Administrators

§ Security Officers

§ Network Administrators

§ Application Developers

§ Application Administrators

§ Database Users