answersLogoWhite

0

Oracle Database

Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.

690 Questions

Can you use SQL to pull data from Oracle?

yes....

example:

select *from employee;

dml command in sql language

What is the difference between sybase and oracle?

difference is only in their name. Sybase is developed by a farmer named sybase and oracle is developed by an actor oracle. sybase is tool which will help farmers and oracle is used to invent the actor inside us.

What are objectives query processing optimization?

main objective is to retrieve data quickly.

Query optimization is the refining process in database administration and it helps to bring down speed of execution. Most of the databases after are built and filled with data, and used come down on speed. The time taken to execute a query and return results exponentially grows as the amount of data increases in the database leading to more waiting times on the user, and application sides. Sometimes the wait times could range from minutes, to hours, and days as well in worst cases.

Technically one of the reasons of slow speeds of executions could be excess normalization leading to multiple tables. More the number of tables, more is the complex nature of joins, and thus leading to more execution times. Sometimes, the complex nature of joins could worse the situation by bring the execution into deadlock.

What is offered by Oracle Business Intelligence?

Oracle Business Intelligence offers analytical tools to help businesses run efficiently. Some of the features of Oracle Business Intelligence include engineered systems, enterprise reporting, and information discovery.

Example for first normal form?

A relation is said to be in 1NF iff each arttribute of the relation is atomic i.e each column must contain only single value.

basic rules for 1NF

1.eliminate duplicate column from the same table

2.create separate table for a gr. of related data and distinguish each row with a unique column or set of column

How many ways are there to contact Oracle support?

There are at least five ways to contact their support team. They offer live chat, email, instant messaging, phone support, and also in person support where a technical worker comes to your site directly.

What is the dominating DBMS?

According to DB Engines regular ranking study, Oracle is the most popular DBMS.

MySQL comes in second, then MS SQL, then a large gap before the rest of the database management systems.

db-engines.com/en/ranking

What is the full form of oracle 9i?

what is difference between oracle 9i and oracle 10g

what is difference between oracle 9i and oracle 10g

What is the Full form of "i" in Oracle 9i

What is the Full form of "g" in Oracle 10g

ans =the oracle 9i the "i" is stands for internet and oracle 10g the " g" stands for grid and new version of oracle 11g was launch in 2007 it provided the special feature rather 8i ,9i other it have a RAC, and network security etc. and good for organization purpose .

What is the difference between while loop and for loop in oracle?

You mean PL/SQL? Well, they are different things, read the manual for details.

Is an index important for spatial database management?

indices r required 4 efficent acces 2 spatial data.traditional index structure sucha as hash indices nd b-trees ,r not suitable since they used 4 only 1-d data,whereas spatrial data r typically 2 or more dimensions.

Placid04

muzaffarpur,bihar,march 2012

Difference between ClinTrial and oracle clinical?

Both are Clinical Data Management Systems (CDMS), developed by different companies. ClinTrial is a product by Phase Forward and Oracle Clinical (OC) is a product by Oracle. Though they have different features, basic functionality is the same Check http://en.wikipedia.org/wiki/Clinical_data_management_system for more details about CDMS Basically CDMS systems are used in case of paper & hybrid (paper and EDC) trials.

Who wrote Lady Oracle?

The novel is writing by Margaret Atwood. She is a Canadian novelist and poet.

How much is the official oracle 11g certification?

The cost is pretty high, though keep in mind that there are deals and events which can lower it as much as 50%. But as a base cost, expect it to be somewhere around two thousand dollars.

What was the significance of the Oracle?

Philosophers and Greeks thought they could tell the future.

What are the features of deductive databases?

There are two primary variations of deductive database systems: expert database systems and knowledge-based database systems. Deductive databases differ from these two types of databases in one major respect: In the case of expert or knowledge-based databases, the data needs to be present in the primary memory of the computer. However, in a deductive database, this restriction is not present. The data can be in primary or secondary memory.

How many records can Oracle Database hold?

It depends how much space you have left on your server; the more space you have, the more records it can hold.

How do you find sid of oracle 10g?

At a Linux prompt type env. Look for $ORACLE_SID. Or type echo $ORACLE_SID.

What is DBMS and what r the features of Dbms?

DBMS stands for data base management system. DBMS is a collection of programs that enables users to create and maintain a database. The DBMS is a general purpose software system used to facilitate the process of defining, constructing and manipulating data bases for various applications.

features of DBMS:

1.Data independence

2.Efficient data access

3.Data integrity & security

4.Data administration

5.Reduced application development time

What was Oracle Identity Manager formerly called?

Oracle Identity Manager was formerly known as two names. One being Oracle Xellerate Identity Provisioning, and the other being Thor Xellerate Identity Manager.

What does oracle open world mean?

Oracle Open world is an event/conference held for people in the technology field. Including businesses as well as IT professionals. It is held annually in 6 different states.

What is the meaning of i in oracle 9i?

The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....