answersLogoWhite

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 are the advantages of database management system?

management is a system of authority. infact management won't exist without proper and appropriate authority.Authority is power to get the work done by others and compel them to work systematically.Management cannot perform in absence of authority.Authority and responsibility generally depends upon the position of the managers ( viz. general manager , sales manager , departmental manager , finanace manager ) in the organization.

What security measures should you implement on your website to ensure customers data is protected?

One way to tell whether a website offers security to help protect your sensitive data is if they have a security certificate for the site matches the name of the site.

What is difference between Excel and RDBMS?

Excel is a spreadsheet application. RDBMS is a Relational Database Management System. Excel has databasing capabilities, but does not have the capabilities of a relational database. There are many facilities in a RDBMS that Excel cannot do or can only do to a very limited amount. Excel is for numerical analysis and manipulation, which is what a spreadsheet is for. Databases are for managing lists of data. So while they both can manipulate data, they are for different kinds of jobs.

What is a stand-alone database system?

A computer that is not part of any network, typically Local Area Network, is considered stand-alone computer. Please note that, depending on the situation, a computer that is not part of LAN, but has access to the internet may or may not be conisdered a stand-alone. The term stand-alone is usually by computer security people. A computer that is not part of LAN is usually configured in such a way that all unnecessary ports/services that can allow access to the computer are blocked in order to secure it.

Which tags are used to add rows to your tables?

Inset Into your_table ( fileld1, field2,.....,fieldn) values (value1,value2,.....,value n)

What are the four main functions of a computer?

1.) Input - Information you put into the computer by way of keyboard, mouse, or stylus. 2.) Processing (CPU) - Also known as the "Brain" of the computer. Processes the information you put in into human readable form. A.) There are 3 C's of processing. 1.) Calculate - Addition, Subtraction, Multiplication, and Division 2.) Copy - happens many times with each instruction that is processed, between registers in the CPU, Devices in the system, and different addresses in the memory. 3.) Comparing - Everytime data is copied, the original data set must be compared to the new data set and when data is being sorted, values in the database compared to the sort string. When datasets are being searched, the database must be compared to the search stream. 3.) Output - The information you put into the computer is seen on the monitor screen and can be printes out on paper and is readable. 4.) Storage - Either the computers memory, CD's, DVD's, Floppy Disc's, USB Flash Drives, ZIp DIsc's, etc.

What is the difference between Oracle and Microsoft Access?

Microsoft Word is a word processor - a program used to create textual documents (e.g. letters, essays, books, manuals). Its end product is designed for a human reading it. Some of its competitors are WordPerfect and KWord.

Microsoft Access is a database - a program used to store relational information (e.g. customer data, payroll, scientific data, financial data) in the computer and retrieve parts of it according to a user's need. Some of its competitors are mysql and Oracle.

What is the common problem in manual inventory system?

Disadvantages In Bullet Points:

- Time consuming.

- Chances of Human error. - Paper work results in need of lot of space to keep the data.

- Possibility of data duplication as there's no repetition check like in computer software's e.g Microsoft Access.

- Not more then one person can access data at the same time but in Computerized Information system many people can access the same data on the same time through networking.

How do you retrieve phone numbers when mobile phone will not turn on?

you can't, its impossible as they have been wiped off the phones hard drive/flash drive

Steven. Samsung support

How do you create a freqency table in excel?

You need your actual values that you are getting your frequencies from first. Then you need a table of the category ranges that you want to get the frequencies within, such as having 10, 20, 30 etc., to see the amount of values within each range. Arrange these in a column. Then select the blank cells beside that column. With those blank cells still selected, in the first of them start the formula by typing =FREQUENCY( and then select the cells that you are trying to get frequencies for. Then press the comma key and then select the range with the categories. Then press the ) key. Then press Ctrl - Shift and Enter and the formula will fill out into the selected cells.

What is query in access?

The purpose of a query is to extract information from a table or tables, which can be based on some criteria. It can be something simple, like list all names in a table, or something a little more complex, like list all products that are priced over certain amount. A query can be very simple or very complex, depending on your requirements.

What are the advantages of PostgreSQL over MySQL?

The main difference that I see is Postgres' advanced support for things like Views, Stored Procedures, Transactions and other more advanced database functions. This is not to say that MySQL does not support these, however Postgres' advanced features are tuned to be highly performative.

Also, Postgres supports more concurrent users than MySQL.

That all being said, if you web application is a relatively simple, mostly read-only, and doesn't require large number of concurrent connections, MySQL is probably the better way to go, as it is performatively optimized for reading, and is simpler to install, maintain, and has better third-party tool suppport.

:)

Queue in a sentence?

He added the download to the queue.

(Line)


I saw a queue in the park

(waiting line)

What is file base system?

What is a file base system?

It is how a computer organizes its (your) files. I believe that the two main (possibly only) file base systems are fat32 and NTFS. Of the two, one is more dependable, and that might be fat32, maybe.

What is the most commonly used database application?

Oracle, MS SQL Server, Informix, Sybase, DB2, MySQL

And for "toy" applications, MS Access.

Data processing concepts and techniques?

The process of collecting, storing, and recovering some information to produce a set of outputs is called Data processing. Data processing software incorporates data management, different methods of data processing software package, writing process for several programming languages, and file and database systems.

What is the difference between sql and pl-sql?

  • Platform dependency-

The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..

  • Clustering technology-

Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.

  • Locking and concurrency -

Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."

  • File system-

Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database.

  • Replication -

SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

  • Administration-

SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.

by....... Sankar

What port does ftp use?

Generally port 21 is for FTP

22 for FTP using SSH

990 FTP using SSL

What is need for normalization in dbms?

DBMS stand for data base management system

We normally use dbms systems to improve the management of the data and accesss of the data too.

well if the data is in normal form it is very easy to access it as well as manage it for the system.

In the process of normalization we increase the normality of the data by removing the dependencies redundancy applying the entity integrity and referential integrity.

there are many stages of Normalization process..:

1. 1NF

2. 2NF

3. 3NF

4. BC NF

5. 5NF...etc..

-----------------------------------------------------------------------------------------------

Addendum:

While the above answer is not incorrect, I don't believe it properly answers the question in a way that anyone who is not already a database expert would understand. The question is this: Why do we need to normalize data in a database. Here is the answer:

First, in order to answer this you have to understand what normalization is. Normalization is the process of removing duplicate information and dependent information from a database.

Lets say for example you have two tables, one called 'employees' and another called 'addresses'. In the employees table you include a field called 'city' and you also include this field in the addresses table. The reason you might do something like this is that you want to be able to get a basic idea of where your employee lives without having to look up the address so you include it in both locations.

Why is this bad? well it should be obvious but here it is. Its bad because it allows for inaccuracies. What if the employee moves and changes his address and you forget to change the city listed in the employees table (or your system crashes while you trying to do it)

the proper way to do this would be to not have the 'city' field in the employee table and instead have a reference to the address table. When querying this info you need to join the two tables and this will ensure that you always have the correct info.

-Dallas Caley

What is bigger a KB or a MB?

KB = kilobyte , while MB = megabyte

kilobytes are smaller than megabytes.


1 kilobyte = 1,024 bytes

1 megabyte = 1,048,576 bytes