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
Different types of canvas in oracle forms?
A canvas view is the background object on which you layout the interface items(textitems,check boxes,radio groups and so on)and boilerplate objects that operators see and intaract with as they run you form.At runtime ,operators cansee only those items that have been assigned to specific canvas.each canvas,interm,must be displayed in specific window
Difference between parallel and distributed database?
Centralized Systems: A modern, general-purpose computer system consists of one to a few CPUs & a number of device controllers that are connected through a common bus that provides access to shared memory. The CPUs have local cache memories that store local copies of parts of the memory, to speed up access to data. Each device controller is in charge of a specific type of device (for example, a disk drive, an audio device, or a video display). The CPUs & the device controllers can execute concurrently, competing for memory access. Cache memory reduces the contention for memory access, since it reduces the number of times that the CPU needs to access shared memory.
In a distributed database system, the database is stored on several computers. The computers in a distributed system communicate with one another through various communication media, such as high-speed networks or telephone lines. They do not share main memory or disks. The computers in a distributed system may vary in size & function, ranging from workstations up to mainframe systems.
The main difference between centralized & distributed databases is that the distributed databases are typically geographically separated, are separately administered, & have slower interconnection. Also in distributed databases we differentiate between local & global transactions. A local transaction is one that accesses data only from sites where the transaction originated. A global transaction, on the other hand, is one that either accesses data in a site different from the one at which the transaction was initiated, or accessed data in several different sites.
What is the file name for the Active Directory Database Where is it located?
Windows 2000 Active Directory data store, the actual database file, is %SystemRoot%\ntds\NTDS.DIT
Difference between database approach and file base approach?
begarto haramzado net pe jawab do hmen assignment banani hae.
How do you make an online catalog?
Creating an online product catalog is really very easy - even for beginners.
If you are just starting out, and have very little cash flow, I recommend using an open source solution like Zen Cart or OSCommerce. If you are using Joomla CMS as your website backbone, there is a great component add on called Virtue Mart.
Most of these solutions should be 1 or 2 click installs using Fantasico, if your web host has it in the control panel. I have very successfully used Joomla with Virtue Mart for a large scale, high end software sales site. It is very secure, has excellent support and is extremely customizable. I have also heard very good things about Zen Cart and OSCommerce.
Yahoo Small Business is another excellent choice for a small start up commerce site. Yahoo does charge for their service, however, you are also listed in the Yahoo Directory, which helps jumpstart traffic to the site.
How many bytes is in 1 gigabyte?
well there are
1000 bytes in a kilobyte.
1000 kilobytes in a megabyte.
and 1000 megabytes in a kilobyte.
therefore i would say 3500000000 bytes = 3.5 GB
actually, there are
1024 bytes in a kilobyte
1024 kilobytes in a megabyte
and 1024 megabytes in a gigabyte
therefore 3.5 GB is exactly 3,758,096,384 bytes
A workflow database is a database used to hold the status property of a running workflow. Workflows can take days, weeks and months to run (David completes a task, it is sent to Joe who does his task after 2 days...) The workflow database is a repository for the status of each running workflow instance
What are the advantages and disadvantages of using a computerized database?
Advantages: It's quicker and easier that writing out the full info ex. Green=G. Takes up less space on a website meaning it will also be a faster website. Disadvantage: People can get confused and may not be able to read or understand it ex leaving your site.
What is the product of data processing?
Computer data processing is any computering process that converts datas into information or knowledge. The processing is usually assumed to be automated and running on a computer. Because datas are most useful when well-presented and actually informative, data-processing systems are often referred to as information systems to emphasize their practicality. Nevertheless, the terms are roughly synonymous, performing similar conversions; data-processing systems typically manipulate raw data into information, and likewise information systems typically take raw data as input to produce information as output.Data can be seen as a raw material, which be later coverted to information. i.e For a company that wants to produce bornvita, such company will need to make use of cocoa,which means that cocoa is the raw material for the production of borntiva, likewise data is the raw material for information. Data has to pass through a specific process before it could be changed to information, and it is called a process.
Data processing most often refers to computer processes that convert data into information or knowledge. Data processingmay also refer to: * Information processing; the change (processing) of information in any manner detectable by an observer. * Data analysis; processing data with the goal of highlighting, drawing conclusions, and supporting decision making. * Data entry done by a data entry clerk.
Disadvantage of multiple file compression?
The disadvantage of multiple file compression is that you need to decompress everything, even if you only need one file.
What is the definition of dell?
The company was founded in 1984, named after it's founder Michael Dell.
What are some types of database software?
Microsoft Access is a common example of database software.
there is also Oracle, DB2, Microsoft Report Server, PostgreReport, MyReport, Reportite, FileMaker and Sybase Adaptive Server Enterprise.
What are the types of marketig Information System?
1) Accounting MIS
2) Financial MIS
3) Manufacturing MIS
4) Marketing MIS
5) HR MIS
What are the advantages of a computerized purchasing system?
What are the Disadvantages of management information systems?
Disadvantages of management information system
Unemployment - While information technology may have streamlined the business process it has also crated job redundancies, downsizing and outsourcing. This means that a lot of lower and middle level jobs have been done away with causing more people to become unemployed.
Privacy - Though information technology may have made communication quicker, easier and more convenient, it has also bought along privacy issues. From cell phone signal interceptions to email hacking, people are now worried about their once private information becoming public knowledge.
Lack of job security - Industry experts believe that the internet has made job security a big issue as since technology keeps on changing with each day. This means that one has to be in a constant learning mode, if he or she wishes for their job to be secure.
Dominant culture - While information technology may have made the world a global village, it has also contributed to one culture dominating another weaker one. For example it is now argued that US influences how most young teenagers all over the world now act, dress and behave. Languages too have become overshadowed, with English becoming the primary mode of communication for business and everything else.
Main features of rdbms and evaluate them for importance?
Relational database management system has various following features:-
1-It can solve any complex queries.
2-RDBMS is very secure.A fully RDBMS can prevent from any unauthorized access.
Difference between Oracle 11g and 11i?
1.Simplified and improved automatic memory management
2.New fault diagnosability infrastructure to prevent, detect, diagnose, and help
resolve critical database errors
3.Invisible Indexes
4.Virtual columns
5.Enhanced security for password-based authentication by enabling use of mixed
case in passwords.
6.Tablespace-level encryption
7.Ability to online redefine tables that have materialized view logs
Thease are only few enhancements , you can find more detail in the doc suggested by SaRa.
What is a hierarchical religion?
A Hierarchical religion is a religion where a political influence goes down a hierarchy of ranks.
like with Roman Catholic, the pope is 1st then the cardinals and so on.
Most of the religions which are meant to exert a political influence on the general public and the government have an internal politics that controls it.
Examples of transaction processing system?
A lot of companies in world that use transaction processing system like Emvantage payments private limited, CCAvenue, PayPal, Atom , Citrus, Ebs, transecute and many more.
a query that calculates a statistic for data that is grouped by two diffrent type of information
What is the classification of DBMS and its interfaces?
DBMS Interfaces
User-friendly interfaces provided by a DBMS may include the following. � Menu-Based interfaces for Web Clients or Browsing: These interfaces present user with lists of options, called menus, that lead the user through the formulation a request. Menus do away with the need to memorize the specific commands and syntax of a query language. Pull-down menus are a very popular technique in Web based user interfaces. They are also often used in browsing interfaces, which allows a user to look through the contents of a database. � Forms-Based Interfaces: A forms-based interface displays a form to each user. Forms are usually designed and programmed for naive users as interfaces to canned transactions. Some systems have utilities that define a form by letting the end user interactively construct a sample form on the screen. � Graphical User Interfaces: A graphical interface (GUI) typically displays a schema to the user in diagrammatic form. The user can then specify a query by manipulating diagram. In many cases, GUls utilize both menus and forms. Most GUls use a pointing device, such as a mouse, to pick certain parts of the displayed schema diagram. � Natural Language Interfaces: These interfaces accept requests written in English, Hindi or some other language and attempt to "understand" them. A natural language interface usually has its own "schema," which is similar to the database conceptual schema, as well as a dictionary of important words. � Interfaces for Parametric Users: Parametric users, such as bank tellers, often have a small set of operations that they must perform repeatedly. Systems analysts and programmers design and implement a special interface for each known class of na�ve users. Usually, a small set of abbreviated commands is included, with the goal of minimizing the number of keystrokes required for each request. For example, function keys in a terminal can be programmed to initiate the various commands. � Interfaces for the DBA. Most database systems contain privileged commands that can be used only by the DBA's staff. These include commands for creating account, setting system parameters, granting account authorization, changing a schema, and reorganizing the storage structures of a database.
Why we need conceptual design of Management Information System?
Management is a delicate system. Each decision made by management has the potential to bring big business or keep customers away.
If you do something simple like playing theme park tycoon (or any of them) you will see that all the pieces have to fit perfectly in order for the operation to run smoothly. Each decision that is made could be a potential time bomb. It all has to balance and if something is slightly out of line it could impact your business for a long period of time.
To study business gives you the tools to make the best decisions and to react quickly to the bad ones to alleviate the damage as soon as possible.
We have a bank here where I live. It is not a tiny bank because it has branches in 3 states, but neither is it a huge conglomerate. This bank decided not to take the bailout money that was being offered. The banks that did take it are trying to give it back so fast and this one small tiny bank is waving banners saying "No Bailout Money Needed". This banner reminds its customers that they are stable and their business is growing again.
What is the benefit of using a multiple-bus architecture compared to single-bus architecture?
Multiple bus structure permit several devices to work simultaneously, therefore improving the computer's speed. In addition, it isolate processor from I/O traffic and support wider variety of interfaces.
What is the evolution of data communication?
The 1970s and 1980s saw a merger of the fields of computer science and data communication which has profoundly changed the technology and products . The revolutionary merger has resulted in a new combined computer communication industry.
How does Transaction Processing System differ from management Information System?
Transacton Processing Systems are a kind of information system. They collect, store, modify, and retrieve the transactions of an organization. A Management Information System are used to analyze other information systems applied in operational activities in an organization.
