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 ...
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
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
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.
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...
What is difference between trigger and a stored procedure?
triggers start their execution when given condition or event is met in prog. but a stored procedure occurs when a programmer make call to it .
Triggers Triggers provide a way of executing PL/SQL code on the occurrence of specific database events. For example, you can maintain an audit log by setting triggers to fire when insert or update op...
Difference between simple view and complex view?
Here are few differences between simple and complex views. 1. A Simple view selects from one table. A Complex view selects from one or more tables. 2. A Simple view does not contain functions but Com...
| Feature | Simple Views | Complex Views |
| Number of tables | One | One or more |
| Contain functions | No | Yes |
| Contain groups of data | No | Yes |
| DML operations through a view | Yes | Not always |
Regards,
Rajakumar.N
How to monitor the database ?Why shmmax and semaphore parameters are used whenever we are installing database on LINUX?
while installing oracle software this parameters we need to set kernel parameters of shmax, semosphere its is compatible with memory of o/s and oracle database memory. while installing oracle softwar...
Using the third party tool OEM we can monitor the database.
What is the data type used to store videos and pictures?
In an Oracle database, you use the BLOB (Binary Large Object) to perform an inline storage of a video or picture file. Alternatively, you can use an externally-stored object in conjunction with the Oracle datatype "BFILE."
Read Best Answer
Editorial / Best Answer
Answered by: msvkrishna
View all questions by msvkrishna View all answers by msvkrishna
Member Since Feb-2009 | Answered On : Feb 11th, 2009
Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.
Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.
Go for Replication using either Oracle Streams or Quest Shareplex
What is the difference between DBMS and RDBMS ?
Read Best Answer
Editorial / Best Answer
Answered by: RicGupta1984
View all answers by RicGupta1984
Member Since Sep-2007 | Answered On : Mar 5th, 2008
A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.
RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. This excludes the databases that don't support a tabular structure or don't enforce relationships between tables.
Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.
Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms difine the integrity constraint for the purpose of holding ACID PROPERTY.
DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some un...
DBMS and RDBMS both are the management system instead in
case of RDBMS we use foreign keys, primary keys etc. which
is not possible in case of DBMS
How can your find the Oracle version you are running..?
Select * from v$version
Read Best Answer
Editorial / Best Answer
Answered by: Mohammed Abdul Afroze
Answered On : Sep 27th, 2007To find the Oracle Version:
Sql>Select * from v$version;
To find the Oracle Version:
Sql>Select * from v$version;
Balaji,
If you are Good at Command line use SQL loaded to convert the data.
IF you are GUI specialist use Toad..it's very easy.
Thanks
Venkat
Excel -> CSV -> OracleSave the Excel spreadsheet as file type 'CSV' (Comma-Separated Values). Transfer the .csv file to the Oracle server (usually HP Unix). Create the Oracle table, using the SQL CREA...
How to delete a value of an attribute in the row
What exactly you are looking for....
you can delete complete row in a table by using delete statement using where clause.
you can make it null value in the attribute in a row.
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