Database FAQ
Oracle 10g installation on window 7 32 bit
While installing Oracle 10g in window 7 it is giving error------ abnormal program termination.An internal error has occurred . Please provide the following files to Oracle support: "unknown" "unknown" "unknown"
Delete duplicate records in teradata
How to delete duplicate records in teradata?
SELECT column names from party group by column names;
Use Distinct or Qualify
How to find if the connected database is asm instance database or not?
check in v$dba_datafiles where the datafiles will start with prefix + are asm data bases
Difference b/w client server and web based applications?
Client server application refers to an application which has client and its own server. Client can be an employee of an organisation and server of that organisation. For example: College SERVER HAS ...
How to find archive log gap from primary to standby?
Hi friends, I m 2012 pass out in cse discipline. And recently joined cybage software as production support engineer. But my ultimate goal lies in database system. So joining cybage was merely to keep relatives shut up and parents happy as well as prepare for my goal. But right now i...
Hope you are aware that being a DBA means working odd hours , indiscriminate routines , erratic week-offs ,etc (occupational hazards ! ) Even then if you wish to take this career option ,here is the w...
I have two table a and b.With table a I fired a query to get a count, and a query with table b to get a count.Now I want total of both count.But I want to this all in one query.Example:- I fired tqo queries as-1- select date(today_date), count(1) from table day1 group by date(today_date);2- select date(yesturday_date),...
You can do it like this
SELECT (SELECT COUNT(1) FROM table DAY1 GROUP BY DATE(Today_DATE)) + (SELECT COUNT(1) FROM table DAY2 GROUP BY DATE(Yesterday_DATE)) AS TotalCount FROM day1 LIMIT 1
Examples of mpp (massively parallel processing) test cases
Greetings friends, i am looking to find examples of test cases for an mpp appliance - basically I am looking to purchase, but must first do a proof of concept against 3 separate mpp appliances. I am looking for some standard test criteria to use in this objective. thanks.
How do you estimate for database testing ?
Write about union operator in SQL?
Union operator in structured query lanhuage
Query to fetch the DDL of a table
I am using teradata SQL assistant.I have a table in SQL server whose table structure I wanna see through SQL assistant.....So please help me out...
I think sphelp stored procedure provided by sql server should of your help here. try sp_help
Hello I was asked to research a test cases on yahoo registration id.... And I have been trying to put the words together on test description, execution steps and and expected behavior but it seems not to come out right. Please any idea???
Plz show me denifiton of nested query , how it work and how optimize with nested query?
What exactly is encoding?
The Decode stage is a processing stage. It decodes a data set using a UNIX decoding command, such as
gzip, that you supply. It converts a data stream of raw binary data into a data set. Its companion stage,
Encode, converts a data set from a sequence of records to a stream of raw binary data.
Steps to apply service packs in SQL server
What are the steps to apply service packs in SQL server2008?
My db is running with out backup and also db is in no archive log mode.How to find out the below issue. the following problem occured during db operation: ora-01115: io error reading block from file 11 (block # 236928) ora-27072: file i/o error additional information: 4 additional information: 236928 additional...
Hello, i am trying to create a database with MySQL : I do not managed to load the .Cvs table into the MySQL : it keeps saying that the table does not exist but I have check the path and it is correct. Can someone help please
How are candidate key that are not primary key indicated in the create table statement?
create table table_name
(ename varchar(9),
eno number(9),
edob date,
egrade varchar(9),
primary key(ename,eno);
Explain the steps involved in creating JDBC connection?
For more details go through this site URL : http://scornik.blogspot.in/2011/05/sql-query-performance-test-with-jmeter.html
Here I'm Using Type-4 Driver to connect to Oracle 10g application and there it goesStep-1: JDBC Driver loading which will be as follows Class.forName("o...
What are the prompts in microstrategy?
During report execution the designer can fill in any part of the report definition such as filter or template. The designer will determine which part of the report to be prompted at the time of report...
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
NH
The question is over 2 years. How can you run windows Compatibility troubleshooter on an Oracle Internal error? It is not possible period. Please revisit Oracle Internal errors documentation at Oracle...
Just open control panel then click to Action Center ..There U will find the Window Programs Troubleshooting Compatibility Click that and browse the program u want to install