0
Oracle Database
Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.
690 Questions
What server can use PHP and Oracle?
Oracle is a database server and is independent from the web server. This means that any server capable of running natively or through CGI/FastCGI php can also use Oracle.
Where can one find oracle interview questions?
One can find oracle interview questions at the Oracle site. Other sites one can find Oracle interview questions are the Glass Door site as well as the Indiabix site.
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
What company created the Oracle E Business Suite?
The company Oracle can be credited for creating the Oracle E Business Suite. Oracle is a major company that is also credited for creating Java. Oracle is a large, widely known company in today's internet world.
A view is generally used to provide a subset view of a table. This can be for security or clarity. For example, you have a payroll table like so:
nameaddresscitystatezipphonesupervisorsalarylast_paycheck_dateno_demeritsnotes
And you only want to have an employee see name, address, phone number, and supervisor, then they can't see hr information. Similarly, if you have multiple tables and need only 5 or 6 fields, then you can use a view to select only those fields.
A view also has the advantage that it uses less resources on the SQL server side because the SQL code is already compiled, and (in some cases), the SQL server keeps the data references up-to-date, so as not to have to find them every time it's run.
This is a very basic overview, but covers the gist of the question.
How do you get oracle certification?
The OCA DBA 11g certification proves one's expertise to perform all basic Oracle tasks for database administration or application development. It's a basic Oracle qualification that helps candidates consolidate their skills to install, implement, administer and troubleshoot Oracle database, which in turn brings industry recognition.
IT professionals, armed with OCA DBA 11gcertificate find it easier to get the job profile and salary as per their expectations.
The targeted audience for this credential includes database administrator, database analyst, and database developer
This certificate is a prerequisite for those IT professionals who want to graduate to Oracle Certified Professional (OCP) level and further move on to Oracle Certified Master (OCM) level.
To receive OCA DBA 11g Certification, one must pass two exams- one core exam and one elective exam: Oracle Database 11g: SQL Fundamentals I - 1Z0-051 Oracle Database 11g: Administration Workshop I 1Z0-052
What are the benefits of PL or SQL?
SQL and iSQL* Plus Sql is command language for communication with the Oracle server any tool or application Oracle Sql contains many extensions iSQL* Plus is an Oracle Tool that recognizes and submits SQL statements to the Oracle serverfor execution and contains its own command language
Whereas PL is Procedural Language when used in conjunction with SQL is termed PL/SQL.
The benefit of PL is it gives programming and logical capability to Oracle , (in other words tight integration with Oracle) . You can create variables variables, arrays etc. and handle exceptions which are not otherwise handled but just thrown back to user in oracle.
You can create a logical block of code to do specific task within databse. Functionality of SQL is quite limited when it comes to providing a flexibility of programming language, for that PL/SQL was developed. Not only you can write your code to do specific tasks and extract meaningful information from databse(by doing logical operations on set of data) but you can reuse your code when similar tasks need to be done.
Difference between oracle asap and oracle brm?
Oracle ASAP is an application for provisioning network elements (OSS), while Oracle BRM is a billing application (BSS). The first one deals with work orders and the protocols for the elements to be provisioned (TELNET, FTP, Web Servcies,...). The second one focuses on defining rating plans, discounts, currencies, taxes, and many other billing information.
Which Oracle software uses SQL server tools?
SQL Server Tools are tools for the Microsoft SQL Server (MSSQL). Oracle is another company that develops database systems and offer Oracle tools to manage Oracle databases.
What benefits might a company have from using Oracle Identity Management?
Oracle Identity Management provides centralization of users and password management. Users' information and profiles are kept in one location for all the applications creating stronger security and administrative convenience. The password management allows companies to establish rules for users which in turn create a safer and secure network environment.
What is the difference between oracle dba and Oracle Production DBA?
Development database is where you allow your developers to develop their applications and SQL and to test it out. If you lose your development database, you generally just rebuild it.
Your production database is where your end-users will be using this system. Production databases contain core data that must be safeguarded and protected. Some companies, such as AMAZON.COM and EBAY.COM uses a production database that must be available 24 hours / 7 days a week. One cannot afford to lose or have their production databases go down for extended periods of time.
Generally, the databases should look similar. The code base is developed in your developer database and, at some point, promoted to your production database. Your production database is your controlled environment
database is a structured collection of records or data that is stored in a computer system. A database usually contains software so that a person or program can use it to answer queries or extract desired information.[1] The term "database" refers to the collection of related records, and the software should be referred to as the database management system (DBMS). Other terms for DBMS are database manager or database system. When the context is ambiguous, however, many database administrators and programmers use the term "database" to refer to both the data collection and the software that enables it to be accessed. Typically, for a given database, there is a structural description of the type of facts held in that database: this description is known as a schema. The schema describes the objects that are represented in the database, and the relationships among them. There are a number of different ways of organizing a schema, that is, of modeling the database structure: these are known as database models (or data models). The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships (see below for explanation of the various database models). Database management systems are usually categorized according to the database model that they support. The data model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failures. In these areas there are large differences between products.
What is Categorization in database management system?
modeling of a single sub class with a relationship that involve more than one super class each called categorization.
What company wanted to acquire Oracle?
The only one I can think of would be IBM. In general Oracle is very large. They normally do the acquisitions.
What Logical data independence and physical data independence?
Logical Data Independence : The ability to change the logical schema without changing the external schema or application programs is called as Logical Data Independence.
Physical Data Independence : The ability to change the physical schema without changing the logical schema is called as Physical Data Independence.
Logical Data Independence :being able to maintain change at external layer without having to make any change at the concept.
Physical Data Independence : we want to be able to make any change on the conceptual level to deal without any change at the physical
What is control file in oracle?
if maintain the database structure in six different location and we cannot change this file.
Are there any job opportunities for someone familiar with Oracle?
Oracle is a database system. Any company that uses this type of database system or another type would probably be willing to hire someone with Oracle experience.
oracale is safely softwere nd also use on security programing
When did the Oracle corporation acquire Sun Microsystems?
Oracle Corporation acquired Sun Microsystems in 2009. They announced in April 2009 that Oracle Corporation would be purchasing Sun Microsystems stock at $9.50 per share.
What are the do's and dont's of dataflow diagram?
First of all you need to understand what a process is before you start. Then decide if you're going to do a physical diagram (Names of People and/or Departments), or a logical dfd (verbs like Call Customer, Validate Order, etc...). Steps:
- The way to start it is to place every process on a large diagram and show the data that moves from one process to another. They don't have to be databases or even electronic data.
- Then after you've drawn that, decide what parts of your process will be automated by a system. That helps define the scope of your system.
- Take the portion of your process that will be automated it, and summarize the processes into no more than 7 processes. The rule of thumb is that if you can describe it in one page, you don't need to diagram any lower.
- Draw the sub-diagrams for those processes that were summarized as sort of drill downs of the larger diagram. Keep in mind that the same rule of 7 applies.
- After you've identified all of the flows, then create your context diagram as one process with all of the flows coming from the sources outside of the process (e.g., Customer, Vendor, etc...).
Hints:
- Validate every process by asking yourself the question about each output coming out of the process, "Do I have all of the ingredients coming out of the process that are required to generate the output?"
- If you have a process that has one flow in and one flow out, is really necessary to perform that process? Does it really produce value?
- Keep the diagrams simple and easy for the business to understand. Every diagram should be quickly understood by anyone looking at it.
