answersLogoWhite

0

Oracle Database

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

690 Questions

How many types of database connectivity occur?

How many types of database connectivity occur? answer: well,There are several types of database 5 kinds considered to be under database types and 4 under the classification by location: n

-1 Single- user:

supports only one user at a time .

-2 desktop:

single=usere database running on a personal computer.

3-Multi-user:

supports multiple users at the same time such tat can be said as "network"where there are more than one computer at a time.

4- workgroup

Multi-user database that supports a small group of users or a single department.

5-Enterprise;

Multi-user database that supports a large group of users or an entire organization

Now is the classification by location database types:

1-centralized:

supports data located at a single site.

2-Distributed :

suporrts data distributed across several sites.

3-Transactional(or production):

supports a company's day to day operations.

4-data warehouse:

stores data used to generate information required to make tactical or strategic decisions.however,often used to store historical data as well as the structure database is quite different.

thanks for reading the artical.MY name is serag zentani if there is any inquire plz do contact me legend1977z@hotmail.com

Distinguish between logical data independence and physical data independence?

logical data : refer to the immunity of the external scheme towards changes in the conceptual scheme.

physical data: refer to the immunity of the conceptual scheme towards changes in the internal scheme.

How to Create Oracle directory object pointing to directory on different server?

Use NFS/CIFS/similar protocol to mount remote directory appearing as local. Then this directory appears as local to the database. This means you don't need to do anything special on the DB side. Just create the directory object as usual, the operating system is responsible for actually moving files back and forth. If you use NFS, it's best to use "hard" option to prevent strange database behaviour when remote machine becomes unresponsible.

What are oracle bones?

Earliest example of Chinese writing found in the Shang dynasty

Example: The kings ask the gods' help using a oracle bone by scratching their questions into there and then, priests place hot metal rods inside causing them to crack. They believed the patterns in the crack was the gods' answer.

What does SLOT mean in the aviation field?

If you're talking about formation flying, the slot position is the position below and aft of the leader and the two wing men, on the centerline of the lead aircraft. This is sometimes referred to as the #4 position.

Alternate AnswerSLOT - A long, narrow, spanwise gap in a wing, usually near the leading edge, to improve airflow at high angles of attack for slower landing speeds.

SLOTTED FLAP - A flap that, when depressed, exposes a slot and increases airflow between itself and the rear edge of the wing.

Crew Slot - I think this term is used to refer to a Flight Schedule for a crew member. Term is similar to a job position.

When is a database is not a database?

the place where we can store the data permanent is called data base..................

the place where we can't store the data permanent is called not data base

a data base is a place for storing data - in particular lines of data that you want to keep together. A telephone directory is an example of a database. A typical database would be Microsoft Access.

There are those who try and use spreadsheets as a database. Microsoft Excel is a typical spreadsheet. The lines of information look similar but you can sort on just one row or column. Consider how useless that would make a telephone list if you sorted the numbers numerically but left the names as they were.

A real database program will not let you do this.

A real database generates reports - something not possible with a spreadsheet.

Database and spreadsheet programs have their own strengths and should not be mixed up.

How do you connect oracle with c?

You'll have to get the object code to link in some of the utilities.

Er diagram of online railway reservation system?

try www.wikipedia.com which will help you for making ER - Diagram ....

and copy past given link below in your browser for detailed description about ER - Diagram :

http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD.htm

If you owned a team what receiver would you want to build your team around?

Present day, it has to be Andre Johnson. He has great hands and run after the catch.

All time would have to be Jerry Rice, work ethic and route running

What is Oracle hrm?

One of the product in Oracle.Oracle HRMS (Human Resource Management System/Human Capital Management(HCM)).It has various modules like core HR,Payroll,Benefits(OAB),Workflow,Absence Mangement,etc..

What companies provide oracle dba training?

To discover what companies provide oracle dba training, it is best to start out on their website, www.oracle.com. One may also do a general search for "companies providing oracle dba training".

What does it mean if you given the word oracle after a belting?

If someone refers to you as an "oracle" after a belting, it typically suggests that you have provided insightful or wise advice following a difficult or intense situation. The term "oracle" implies that you possess knowledge or foresight, often associated with prophetic abilities. In this context, it highlights your ability to offer clarity or guidance despite the emotional turmoil of the moment.

What is selection list in oracle?

In Oracle, a selection list is a SQL feature that allows users to specify which columns they want to retrieve from a database table in a query. It is defined in the SELECT statement, where the user lists the desired column names, separated by commas. For example, in the query SELECT column1, column2 FROM table_name;, column1 and column2 form the selection list. This helps in optimizing data retrieval by limiting the output to only the necessary information.

How exactly does Oracle BPEL work?

Oracle BPEL is a process manager which offers infrastructure for creating, deploying and managing BPEL business processes. It is both comprehensive and easy to use.

What is an Oracle Based Accounting Software?

Oracle-based accounting software refers to financial management solutions that utilize Oracle's database technology and applications to facilitate accounting processes. These systems offer a range of features, including general ledger management, accounts payable and receivable, budgeting, and financial reporting. By leveraging Oracle's robust architecture, the software ensures data integrity, scalability, and integration with other enterprise applications, making it suitable for businesses of various sizes. Additionally, it often includes advanced analytics and automation tools to enhance financial decision-making and operational efficiency.

What is clustered index in database?

The data is stored along side the index keys, so when a query searches by the index, once it's found the "leaf" in the index tree, it usually has gotten the data in the same disk read. So your searches by that key are much faster.

The down-side is that it takes much longer to save data with a clustered index, because it has to make space where the key should be stored for the table data.

Can composite key has null values?

if you want composite key for using the sql use the following sql query:

select distinct(col_name) from table_name where col_name is null;

What is responceblity data warehousing proffeshionel?

what role should HIM professionals play in data warehousing development

What privilege should a user is given to log on to the oracle server?

The CREATE SESSION system privilege

by legrand charles(B.E CSE)

What type of integrity is enforced when a primary key is declared?

By default a primary key is also a unique constraint, that means only one row can contain a specific value for this key (or no duplicates are allowed). Also an index is automatically created for a primary key allowing efficient access.