Database FAQ
How are candidate key that are not primary key indicated in the create table statement?
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...
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"
Just download the Oracle software, check memory for 11g R2 - atleast 4 gigs, and 100 gigs of space.
Set the Oracle home and Sid
Run the installer after you unzip the software.
Create the Oracle 11g R2 base and Oracle Home
Run the DB configuration Assistant to create your database.
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.
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),...
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
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
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.
How to prepare case study for spatial and temporal database?
Which functionality of a database creates alert log?
Server processes will create the alert logfile.
How can we set the backup time in a database?
Among the many databases available in the market which database is providing more user friendly behaviour and why?
MySql Database
What is included in the schema of a relational model?
The overall design of a relational database model is called Relational schema.
What is system table?How is system table different from systable?What is base table?
User Panel
Categories
Ads
Interview Coaching
Connect
Ads
Interview Question
Career Counselling
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, click "Subscribe".
create table table_name
(ename varchar(9),
eno number(9),
edob date,
egrade varchar(9),
primary key(ename,eno);