Oracle Database

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

1,975 Questions
Software and Applications (non-game)
Oracle Database
File Formats

What is the ER diagram of courier management system?

ER stands for Elimination Related

Database Programming
Oracle Database

Sql query to list all the constraints in the table?

SELECT * FROM user_constraints WHERE table_name='TABLENAME';


Database Programming
Windows 7
Oracle Database

Does Windows 7 support Oracle 9i?

Yes. Download the Oracle instant client (or other versions) from Oracle's website.

Oracle Database

What are the components of er model?

components of er model are :-

1. external entity

2. relationships :-

one to one , one to many , many to one , many to many

3. attributes

4. cardinality

5. participation

Database Programming
Visual Basic Programming
Oracle Database

How do you retrieve the target path of any existing shortcut such as a lnk file in Visual Basic?

Here is how to open a Windows Shortcut file Using VB6. This is a safe and documented method.

Create a New VB6 Project

In the Project References Add "Windows Script Host Object Model"

Place a Command Button on the form named CommandButton1

Click on CommandButton1

Private Sub CommandButton1_Click()

Dim Oshell As New WshShell

Dim Osh As WshShortcut

Dim Fn As String

Dim Otarget As String

'Set the path and file name of the shortcut

Fn = "C:\shortcut path\shortcut filename.lnk"


' If the shortcut file is existing, it will open the existing file


Set Osh = Oshell.CreateShortcut(Fn)

Otarget = Osh.TargetPath


' Using the Watch window see the other properties of Osh object


End Sub

Oracle Database

What is SIDS?

SIDS (Sudden Infant Death Syndrome) is the death of an apparently healthy infant that remains unexplained after a thorough autopsy and death scene investigation. There appears to be no suffering in most cases; death occurs very rapidly, usually during sleep. SIDS is the leading killer of infants between one week and one year with an approximate rate of two per thousand live births (1 in 500). 6,000-7,000 babies die of SIDS every year in the US. The peak age is around two to four months and the majority of the deaths occur during the winter months (October to April in the Northern Hemisphere). Researchers believe that SIDS probably has more than one cause, although the final process appears to be similar in most cases. SIDS can not predicted, prevented, or reversed. [This was excerpted from a FAQ in Copyright 1995, Margaret Gibbs. Use and copying of this information are permitted as long as (1) no fees or compensation are charged for use, copies or access to this information, and (2) this copyright notice is included intact.]

Computer Networking
Local Area Network
Oracle Database

How do you configure Windows 2000 Professional as a server and Windows 98 as a client?

This is really simple. There are probably hundreds of places on the net that tell you how to do this, but the simplest way is to ensure that all of the computers have ethernet cards. Have all of the computers connect to a hub, including the server. Go into the control panel, then networking and setup all of the ethernet cards to support Netbeui. From there, on the server, right click on the folder you want to share and give it a share name. Then right click on my computer on each workstation and select map network drive and use the following pattern to map your drives: \\servername\sharename.

Read this for a more step by step explanation:

First we understand the concept. windows 2000 proffessional is not the server OS. this is the client OS. for client server technology server must be the server OS like windows 2000 server or NT server. client may be any OS. If u configure windows 2000 professional and win98, this is as the workgroup model. this not the client server technology. this is normal networking in LAN.

Database Programming
Microsoft Access
Oracle Database

Advantages of query optimization?

1. Faster processing of query

2. Lesser cost per query

3. High performance of the system

4. Lesser stress on the database

5. Efficient usage of database engine

6. Lesser memory is consumed

Windows XP
Oracle Database

How do you connect Microsoft IIS Oracle 9iAS and MySQL to three computers when two of them are using Linux and the other one Win XP?

I want to wish you the best of luck. I would start off Number one by haveing a really good network admin. If your an Admin then you have some work. Number one Microsoft IIS, Oracle 9iAS, and the SQL server should all be stand-alones. You would have to link computers together with atleast a 10-Base-T hub. Call network something and make all Gateways, ISPs for these "servers". You would also need to have the "Servers" auto-handshake ISPs from other computers. HAve the Linux machines and windows machine tied into network. the windows machine would be easier to config. Make sure that you have made the "workgroup" name for the servers. That's going to help the XP machine reconize the "servers". For the Linux boxes, I have not really worked with Linux sence RedHat 5.0 but more than likely you are going to need to get dynamic ips for those boxes and have those dial direstly to the "SERVER" that you need to use at that piticular time. I hope that this helps minimally, Your taking on a task that most Admin would not you have 5 diffrent platforms that you are wishing to use in this network. The easy ones to takle is the "SERVERS" the ones that is going to be hard is the crossing of Linux and XP.

Database Programming
Oracle Database

How do you find sid of oracle 10g?

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

Stock Market
Cloud Computing
Business & Finance
Oracle Database

What is Oracle's stock symbol?

The stock symbol for software and technology company Oracle Corporation is ORCL.

Database Programming
Oracle Database

What is exact expansion of ORACLE?

What is exact expansion for the term ORACLE?

Oracle Database

What is a 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

Jobs & Education
Oracle Database

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.

Database Programming
HSC Maharashtra Board
Oracle Database

What are attributes and entities in database system management?

Entities are the things you're keeping track of. In an video rental database, you keep track of customers, invoices, titles, copies, etc. These are represented in tables where the rows are individual instances of a customer or title. The columns are the attributes, the things that tell us about the instance in the row. The customer's name, address, city, balance, etc. are attributes that help identify the customer. An invoice's attributes might be price, number, date, paid/unpaid, etc. Databases link entities/tables so that a customer, described by his attributes, can be associated with his invoices, describe by his attributes and selected by the invoices 'unpaid' column. "Here's your bills for the last month, Mr. Smith."

Database Programming
Oracle Database

10 examples of Database Management System?

Ten common software packages that provide DBMS functionality include:

  1. Ingres
  2. Microsoft Access
  3. MongoDB
  4. MS-SQL Server
  5. MS FoxPro
  6. MySQL
  7. NoSQL
  8. Oracle
  9. Postgres
  10. SQLite

A DBMS, or database Management System, is a collection of programs that enables you to store, modify, and extract information from a database.

Database Programming
Oracle Database

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..



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

Oracle Database

Who invented Oracle Database?

Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex Includes - We provide individual and corporate training Educate, Learn & Serve

Database Programming
Oracle Database

What is the Difference between oracle apps technical and functional consultant?

At a very high level

Oracle Apps Functional Consultant -> One who understands business flows/processes and ways to do setup/tweak in oracle application to suite business needs.

Oracle Apps Technical Consultant -> One who understands the oracle application architecture and table-relations etc.

Computer Terminology
Database Programming
The Difference Between
Oracle Database

What is shareplex in oracle?

Shareplex is used to replicate an Oracle database. It uses the redo logs/archive logs to replay the transactions on the replicated database. It is a from Quest Software.

Database Programming
Oracle Database

How many types of database structure are there?

There are 9 database models..
  1. Hierarchical Model
  2. Network Model
  3. Relational Model
  4. Object/Relational Model
  5. Object-Oriented Model
  6. Semistructured Model
  7. Associative Model
  8. Entity-Attribute-Value (EAV) data model
  9. Context Model

Please refer to the link below for more information.

Software and Applications (non-game)
Database Programming
Oracle Database

How do you connect oracle database in javascript?

By using ODBC

Football - American
The Twilight Saga
Oracle Database
Twilight New Moon

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

Software and Applications (non-game)
Oracle Database

What is different between strong entity and weak entity?

strong entity is the entity that can stand alone

weak entity cannot be exist alone.

usually strong entity represent an real world entity such as course , student, patient, ward, department, employee,.... etc


the weak entity represents the relationship between two entities, so in connot be exist alone, there must be two strong entities that the weak entity will connect.

Java Programming
Database Programming
Database Design
Oracle Database

Examples of database system?

Database system is a general term that refers to the combination of a database, a database management system and a data model. This system is responsible for the data manipulation actssuch as data controlling, data retrieving, data maintenance and data definition.


Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.