0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What is the difference between sql server and ms sql 2000 database?
SQL Server is most often referred to as Microsoft SQL Server, but there is also a Sybase SQL Server which was originally created on UNIX in 1987. MS sql 2000 database, or Microsoft SQL Server 2000 is a database server product. So, when you ask what is the difference, I do not see a difference, they are one in the same. Unless your question is asking for the difference between the Sybase version and Microsoft version, or you are wanting to compare different versions of Microsoft SQL Sever. In which case, I think your question must be more specific. arnel... SQL stands for (Structured Query Language). A SQL server can cover a host of products. Oracle is a SQL server however when speaking of Oracle people usually refer to it is Oracle. The server in fact is a SQL server. Microsoft SQL server is often simply referred to as SQL Server not because they 'own' the product or anything, just because of the popularity. I can draw a parallel for you. When you own a SeaDoo watercraft (as I do) people will refer to it as a jetski, same with a Kawasaki, Polaris, or any other brand. The fact is that this name (JetSki) is used interchangable however the Kawasaki Standup model watercraft is the only true 'jetski'. Anyway there are many 'flavors' of SQL server (MYSQL, Oracle, MS SQL Server, Postgress SQL, just to name a few. You can find more information about SQL server, its history and some additional 'flavors' at this link: http://en.wikipedia.org/wiki/SQL Hope that helps. Jwilliamsoh http://jwilliamsoh.spaces.live.com/
Its is the button battery that stores the BIOS settings for your computer.
Typically forms gather two kinds of informations personal data and information?
information specifc to the fourm
What is the meaning of Database security?
Database security refers to the many steps taken by businesses to protect their databases from both internal and external threats. The database, the data it holds, the database management system, and the numerous applications that access it are all covered by database security.
To learn more about data science please visit- Learnbay.co
Why is the computerized system not effective in all situations?
* computerized system is not effective in all situation because it is newer it is not a manual system and it make it own decisions and it use in busnisses markets home etc..
How can you protect your computer from malware?
In order to protect your computer from malware, it is a good idea to have an anti-virus program set up. Try Avast or AVG, as these are both successful and free. You also will need to have a firewall.
Advantages n disadvantages of traditional file system?
A disadvantage of a traditional file system is human error. When a file is filed in the wrong place it can be a long time before the file is located. Another disadvantage is the possibility of fire destroying the records. An advantage to this type of filing system is that there is a hard copy of everything that is filed. A file can be copied for several users of the file.
AutoNumber
What are the Components of A database server?
• Hardware
- Can range from a PC to a network of computers.
• Software
- DBMS, operating system, network software (if necessary) and also the application programs.
• Data
- Used by the organization and a description of this data called the schema.
• Procedures
- Instructions and rules that should be applied to the design and use of the database and DBMS.
• People
- The people that participate in the database environment.
What are the different database available in industry?
There are various types of databases available in the market
- Oracle database belongs to Oracle Coporation
- Sql Server belongs to Microsoft Coporation
- Mysql belongs to MySQL AB (founded 1995, acquired by Sun Microsystems 2008)
- Sybase belongs to SyBase
What is the Difference between a single threaded file server and a multi-threaded file server?
Single thread means that the processor will wait until one 'process' is complete before it opens a new thread or 'process'. Multi-thread can handle multiple threads simultaneously making it faster and more responsive.
What are the advantages and disadvantages of knowledge management systems?
A knowledge management system can be useful in many different ways or strategies and practices. It is commonly used successfully in the Information Technology field and human resource management.
Peer-to-peer
Oracle Fusion Financials Online Training, Rainbow Training Institute having best instructors for Oracle Fusion Financials Online training and it is well known for providing all
Kinds of oracle fusion technologies through online and it is stepping forward in providing best Oracle Cloud Financials Online Training in Hyderabad, Bangalore, Chennai, Noida, Delhi, USA, UK, UAE, Saudi, Europe, India, Canada. Complete Suite of oracle fusion
financials training videos.
Are gigabites larger than megabites?
Yes.
1 Bit = the smallest bit of information. Basically, one character (e.g. letter, number, symbol, space, etc)
1 Byte = about 8 bits
1 Kilobyte (Kb) = 1024 bytes (the first binary number above 1000)
1 Megabyte (Mb) = 1,048,576 bytes (1024 Kb) (1000 x 1000 bytes)
1 Gigabyte (Gb) = 1024 Mb (1000 x 1000 x 1000 bytes)
etc
Basically, most people take each figure as 1000 of the previous thing
After Gigabyte you have Terabytes, Petabytes, Exabytes, Zettabytes, and Yottabytes
Average word document (letter, essay, etc) = under 100 Kb
Average photo from a digital camera (unedited) = under 2Mb
Average 3 minutes MP3/music file = 4Mb
Average USB flash drive/memory stick or iPod/MP3 Player = 1Gb
Average laptop computer = 80-160Gb
You can buy 500 Gb external hard drives (half a terabyte) - which would store many many hours of video, billions of music albums and other documents
Microsoft Office takes up about 1Gb, not including any documents you create.
Photoshop, as well as video editing software, takes up more like 10GB (roughly).
Loads of info about it at http://www.answers.com/topic/byte?cat=biz-fin
500 MB can mean two thing: 500 MEGA BYTES of main (system) memmory or 500 Mega bytes of storage (disk drive). One Megabyte is roughly the equivalent of one full novel. its not exactly 500megabytes, this is due to each value increasing by itself, eg 1,2,4,8,16,32,64,128,256,512.....etc. Answer A byte is a unit of data storage. A megabyte is 1,000,000 bytes. And 500 megabytes is (of course) 500,000,000 bytes. Data storage comes in many forms (disk drives, memory (properly called RAM), flash memory like USB sticks, etc.) but the term 500 MB means the same thing either way. And yes, data storage that is equal to 500 MB is perfectly possible, the person who gave the second answer seems not to realize that multiples of two do not govern everything. RAM is usually retailed in such units (64 MB, 128 MB, 256 MB, etc.), but other methods of storage have no such constraints (like CDs that hold 700 MB, or floppy disks that hold 1.44 MB). AnswerWhoever gave the 3rd answer is forgetting that there is such thing as File System (FS) on mass Storage devices (such as CD's, DVD's, Harddrives, Floppy Disks etc) which take up space. EG if you get a 1GB Pendrive, it will have 0.99GB Space because the file system will take up the 0.01GB. So if you are looking at 500MegaBytes of RAM, there is a different type of file system, which is NOT stored on the RAM sticks, which means you get the full 500MB. :-)
Answer Is this kid serious asking this question? Yes their is such thing as 500 mb. Some people should not be allowed to own a computer...
A manual filing system is filing documents using paper and cabinets. The documents are filed within a folder and then stored, by some means of categorization or another, in a cabinet for later retrieval.
This is the opposite of storing documents within folders on your computer's hard drive. In the computer world the documents are stored in a digital filing system, as opposed to the physical filing system in the manual way.
What is the difference between Table and Relation in Database?
In a table each column attributes are independent, In a table row order & column order are mandatory & that cannot be changed, Table can be of more than 2 dimentions, There may be of rows and columns duplication in a table. Relation: In a Relation in which all attributes are dependent in one or the other way, The row and column orders are not considered, Relation is always 2 dimentional, There cannot be duplication of rows and columns in a relation There is no difference they both refers to the collection of rows and colls which used to store data.
_________________________________________________________
Table The physical instantiation of a relation in the database schema. Relation A logical construct that organizes data into rows and columns.
A table is essentially a two-dimensional matrix. But, a relation need not be so.
What is the role of data in information systems and business?
speed up and simplifies the process of work and management in a business
How do you change the password of a SQL Server login?
Try to use command prompt to change your sql sa password.
First, open a command prompt (Start -> Run -> cmd)
Then, type the follow commands, and press Enter after each line:
Osql -S yourservername -E
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO
Does a database have to be computerized?
No. A database can be manual, like a phone book or a shopping list. For it to be a database it needs to be structured or organised. If you take a phone book, although there are thousands of names in it, you can usually find a phone number you are looking for very quickly. This is because the phone book is structured and organised. So it does not have to be on a computer to be a database. A manual database can be computerised. The data would be entered into a computer.
What ways can you insert an extra row into a table?
On this computer, you go over to the left side of the row. You click on the left side of the row. It highlights the entire row. You go to "Table." You click on it. You click insert. It will insert a row. You let the computer do it for you.
A computer network is defined as two or more computers connected via software and hardware so that they can communicate with each other. Ultimately, a computer network enables the exchange of data among computers.
