0
Oracle Database
Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.
690 Questions
If you are talking about Oracle Database then some of them are:
Microsoft SQL Server
IBM UDB
Mysql (Which is also owned by Oracle)
If you meant Oracle as a company then the list is huge, Oracle Corporate have many solutions in many areas, Software (Databases, Security, Monitoring and more) and Hardware (Sun).
sql allow their implementation using various sql commands
Is a primary key a unique identifier?
NO, unique identifier allows null values.. so u dont called as primary key...
primary key means it doesn't allow null n repeated values....
so we dont call unqiue identifier is a primary key...
Different types of automation?
computer system, distributed control system, operating system, lighting system e.t.c
What is the fullform of oracle?
Oak Ridge Automatic Computer and Logical Engine
Regards,
Manikandan Selvarajan
dB Professionals India Pvt Ltd,
Chennai-40,
India.
What are the advantages and disadvantages of billing system?
Computerized billing systems:
Advantages:
Generates the claim
Records all charges & payments in the system
Automatically posts to patients accounts
Reduces paperwork
Minimized errors
Disadvantages:
High Initial Cost
Special Trainings for Personnel
Viruses
Losing data from power failure
Hackers
Computer fraud
Sequential data is when things are stored and accessed in order, starting from the beginning (or end) of the file. So to access a given record, you would have to access everything before that point. Sometimes this is the only way to access things, such as items stored on tape.
E-R diagram for library management system?
An ER-Diagram is used for developing databases.
But if you want us, to develop an database for an library management system - then you are at the wrong forum.
How you create er diagram for shopping cart?
An ergonomic diagram for a shopping cart can be made by using a map of the store where purchases will be made. Many major grocery stores have printed maps for customers. Another way to diagram a shopping cart is to make a grocery list while in the store, noting the different things in each department and the store layout.
Advantage and disadvantage of oracle dbms?
Advantages:
- It allows for better quality data, as you restrict what data goes into a column or a table.
- It allows for data to be linked between tables, using foreign key constraints
Disadvantages:
- Takes a little longer to set up a table as the constraints need to be identified and added into the script.
What is the difference between mysql server and oracle server?
While these three products are very similar, there are some differences. MySQL does not have a GUI interface while the other two do, it is also the only open source product of the three. SQL Server only runs on Windows, while the other two run on a variety of operating systems. Language support differs among the three, with each having some unique language support.
Where can one download Oracle 11i?
To get Oracle 9i, go to www.oracle.com. Go to the downloads page for 11g, scroll to the bottom, and select Previous database releases, Oracle 9i.
What is a n Er diagram for payroll system?
Drawing Entity Relationship diagram between the various entities of any Payroll System. Example relationship between departments and employee, Leaves and Employee, etc., Drawing the same will help to normalize and improve the Database Design.
What is Oracle's stock symbol?
The stock symbol for software and technology company Oracle Corporation is ORCL.
Advantages and disadvantages of management information system?
A good information system allows the user to access, understand and respond to information quickly and effectively. Whenever necessary, users can get the most accurate information needed to do an activity. A good information system also offers users a variety of ways to change and present information, as well as perform different tasks.
Information systems may not always function properly. This happens for a number of reasons. Systems break down, interrupting smooth operations and causing customer dissatisfaction. For instance, customers may be charged for the wrong services or for merchandise that they did not order. Also, defective information systems can deliver the wrong information to other systems, which could create further problems for the company and its customer
Why we are using oracle instead of mysql?
This question is very broad subject and in few lines, we should not answer... For the answer, you must have through idea/knowledge about the Organization like, Budget, IT, Technical Competencies, Capacity Planning, IT infrastructure... If any of the above mentioned area is lacking with funds then you may compromizing with the quality, security or the productivity... In the market, you may find so many products which are promising to handle your organizations Data Management but the best RDBMS is Oracle... Hope it helps... Cheers !!
Star Nirav
+91 9227258878
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 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 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.
What is written in Redo Log Files?
The most crucial structure for recovery operations is the redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.
Is oracle a database or language?
Answer:
Oracle is a data base
Hope this helps!
Inclus - We provide indivdual and coporate trainings
Educate, Learn & Serve
www.Inclus.net
