What is the diff b/w BTREE INDEX and BITMAP INDEX
What is the diff b/w BTREE INDEX and BITMAP INDEX Answer Question Asked by : ANAND | Last Updated On : Dec 31, 2008 Answers: 7 Filed in : Oracle Architecture Interview Questions
SHARETHIS.addEntry({ title: “What is the diff b/w BTREE INDEX and BITMAP INDEX”, url: “http://techhairball.com/wp/2009/01/01/what-is-the-diff-bw-btree-index-and-bitmap-index/” });
Sphere: Related Content
Find out nth highest salary from emp table - SELECT DISTINCT (a.sal) FROM EMP A WHERE amp;N = (SELECT
Find out nth highest salary from emp table - SELECT DISTINCT (a.sal) FROM EMP A WHERE amp;N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal lt;=b.sal);For Eg:-Enter value for n: 2SAL———3700 Answer Question Last Updated On : Dec 30, 2008 Answers: 25 Filed in : SQL Interview [...]
Starting Oracle Services - How to start Oracle services manually for Oracle database
Starting Oracle Services - How to start Oracle services manually for Oracle database Answer Question Asked by : aman mangat | Last Updated On : Dec 29, 2008 Filed in : Oracle DBA FAQ
SHARETHIS.addEntry({ title: “Starting Oracle Services - How to start Oracle services manually for Oracle database”, url: “http://techhairball.com/wp/2008/12/29/starting-oracle-services-how-to-start-oracle-services-manually-for-oracle-database/” [...]
Hi!!!I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather
Hi!!!I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string…what should i do with login.sql script.. i Put it in /Bin directory..but not working..any… Answer Question Asked by : Nitina | Last Updated On : Dec 27, [...]
The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item
The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. Most customers… Answer Question Asked by : Beena [...]
Scroll bar on tab pages - Can we add scroll bar at on all tab pages in a single canvas If yes then how:
Scroll bar on tab pages - Can we add scroll bar at on all tab pages in a single canvas If yes then how: Answer Question Asked by : niranjansmart | Last Updated On : Dec 24, 2008 Answers: 1 Filed in : D2K Interview Questions
SHARETHIS.addEntry({ title: “Scroll bar on [...]
Maximum PKs and PIs - How many Primary keys and Primary Indexes can we create on a table.How many Foreign
Maximum PKs and PIs - How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table Answer Question Asked by : kiranparsha | Last Updated On : [...]
Maximum PKs and PIs - How many Primary keys and Primary Indexes can we create on a table.How many Foreign
Maximum PKs and PIs - How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table Answer Question Asked by : kiranparsha | Last Updated On : [...]
Is there any way we can change the column name in a table
Is there any way we can change the column name in a table Answer Question Asked by : sheela | Last Updated On : Dec 21, 2008 Answers: 21 Filed in : SQL Interview Questions
SHARETHIS.addEntry({ title: “Is there any way we can change the column name in a table”, url: [...]
Create table based on another table - How to create table emp1 based on emp, except comm column
Create table based on another table - How to create table emp1 based on emp, except comm column Answer Question Asked by : vijaychakaravarthy | Last Updated On : Dec 19, 2008 Answers: 6 Filed in : Oracle SQL FAQ
SHARETHIS.addEntry({ title: “Create table based on another table - How to [...]
Create table based on another table - How to create table emp1 based on emp, except comm column
Create table based on another table - How to create table emp1 based on emp, except comm column Answer Question Asked by : vijaychakaravarthy | Last Updated On : Dec 19, 2008 Answers: 6 Filed in : Oracle SQL FAQ
SHARETHIS.addEntry({ title: “Create table based on another table - How to [...]
Can you add not null column to a table already containing data
Can you add not null column to a table already containing data Answer Question Asked by : be_viral | Last Updated On : Dec 17, 2008 Answers: 5 Filed in : PL/SQL Interview Questions
SHARETHIS.addEntry({ title: “Can you add not null column to a table already containing data”, url: “http://techhairball.com/wp/2008/12/19/can-you-add-not-null-column-to-a-table-already-containing-data-2/” });
Sphere: [...]
Can you add not null column to a table already containing data
Can you add not null column to a table already containing data Answer Question Asked by : be_viral | Last Updated On : Dec 17, 2008 Answers: 5 Filed in : PL/SQL Interview Questions
SHARETHIS.addEntry({ title: “Can you add not null column to a table already containing data”, url: “http://techhairball.com/wp/2008/12/17/can-you-add-not-null-column-to-a-table-already-containing-data/” });
Sphere: [...]
When a database is started, Which file is accessed first
When a database is started, Which file is accessed first Answer Question Asked by : shridhar | Last Updated On : Dec 16, 2008 Answers: 3 Filed in : Oracle DBA Interview Questions
SHARETHIS.addEntry({ title: “When a database is started, Which file is accessed first”, url: “http://techhairball.com/wp/2008/12/16/when-a-database-is-started-which-file-is-accessed-first/” });
Sphere: Related Content
Create a report for the HR department that displays employee last names, department numbers, and all
Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label. Answer Question Asked by : Kanyarat | Last Updated On : Dec 14, 2008 Answers: 3 Filed [...]