0
Oracle Database
Oracle Database is a Relational Database Management System produced by Oracle Corporation. It was first released in 1977.
690 Questions
How do you get the unique records without using DISTINCT keyword in oracle?
A UNION clause between two (or more) SELECT statements will default to returning only unique records, as will MINUS and INTERSECT.
By comparison, UNION ALL will return duplicate records that are in any of the component SELECT statements.
The Delphic oracle's statement comes true. (Apex)
CRS is Oracle's Cluster Ready Services.
For more information research Oracle Clusterware.
A DBMS snapshot in Oracle can also be referred to as a materialized view. Basically a snapshot is a refreshable view that can be refreshed on command or commit.
What is a good sentence for compile?
Example sentence - I will compile the details for the report once I have all of the facts.
Why use truncate over delete while deleting all rows?
For performance. Truncate will release the tablespace used by the table that the data is being removed from and delete will not release this space.
What restrictions apply to the use of aggregate function within the select?
Aggregate functions:
COUNT, SUM, MIN, MAX, AVG
NOTE: It can be used only in the SELECT list and in the HAVING clause. Using it anywhere else will be incorrect; also you cannot nest aggregate functions.
What is composite data type in plsql?
Composite types have internal components that can be manipulated individually, such as the elements of an array, record, or table.
Oracle TimesTen In-Memory supports the following composite data types:
Associative array (index-by table)
Nested table
Varray
Record
What does Lord Phoebus or the Oracle of Delphi want the people of Thebes to drive out?
he wanted the people to drive out the killer of the former king
When a user creates an object without a tablespace clause where will oracle store the segment?
It will go in the default tablespace of the user that creates the object.
Main characters in oracles of delphi keep?
The earl, Theo, Carl, Ian, Thatcher, Perry, Proffesor Nutley, Magus, the Hellhounds, Jaavad, and others.
What is precompiler in oracle?
The Oracle Precompilers are used to process C, COBOL, or PL/I programs before passing them to their native compilers. Oracle Precompilers translate embedded SQL statements in the programs into the appropriate native language statements and calls necessary to access the Oracle9i database server.
Sequence of triggers firing in oracle forms?
Trigger Firing sequence:
Order as follows
First Logon Triggers are fired
1.PRE-LOGON
2.ON-LOGON
3.POST-LOGON
After that Pre Triggers
4. PRE-FORM
5. PRE-BLOCK
6. PRE-TEXT
After that WHEN-NEW Triggers
7. WHEN-NEW-FORM-INSTANCE
8. WHEN-NEW-BLOCK-INSTANCE
9. WHEN-NEW-ITEM-INSTANCE
After that ITEM Level Triggers
After this focus is on the first item of the Block. If you type some data and press the tab key following trigger will fire in sequence
10.KEY-NEXT-ITEM (This trigger is present on the item level).
11.POST-CHANGE (This trigger is present on the item level).
12.WHEN-VALIDATE-ITEM (This trigger is present on the item level).
13.POST-TEXT-ITEM (This trigger is present on the item level).
14.WHEN-NEW-ITEM-INSTANCE (Block Level Trigger).
Now focus will go the next item present on the form.
If there are no further items present on the screen them if we enter data and press tab key then only KEY-NEXT-ITEM is fired. Now suppose we close the form then the item level triggers are fired.
POST TRIGGERS
15.POST-BLOCK
16.POST-FORM
Now the form will be closed.
What is OORDBMS in Oracle Database?
An Object Oriented Relational Database Management System. An adapted form of the earlier RDBMS, in which it is made possible to work with Objects.
How do you convert oracle data into DBF file?
There are many other programs for working with dbf files. But one day came into a tool, which to my great surprise solved out my old troubles with dbf files. I hope it might help in present situation.
What are the alternatives to oracle database?
Reasonable alternatives would be MS/SQL, MySQL, PostgreSQL, and other server-based relational databases. Somewhat less reasonable options that might work for small single-user applications are FileMaker Pro and Microsoft Access (among others).
The i stands for "Internet". Oracle 8i and 9i has the i suffix because it was released during the Internet boom and it's trying to capitalize it. Since 10 the suffix has becoming "g" which stands for grid. Again, it's try to ride the whole grid computing marketing that's happening throughout the IT industry.
A trigger is executed automatically when database modification done.
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 is collection in oracle 11g?
Collection is a composite datatype in oracle and it can also be called as pl/sql table which is used to store collection of similar datas as like an array of C.There are three types in collections
1.Associative array
2.Nested Table
3.Varray
What is the difference between oracle and oracle erp?
Oracle is a database corporation that has many products such as Database, BI and ERP
