-
Inversion Key Entry
What is Inversion Key Entry?
skachalia
- Aug 6th, 2009
A column or group of columns used to access data from the table very frequently and may not be unique but?are potential candidate for creating non-unique indexes on them are known as Inversion Entry key.Inversion Entry key is represented by IE notation.
-
Copy MYSQL database from one machine to another
How to copy database from one machine to another machine in MYSQL? Explain with an example?
bagya
- Jul 31st, 2009
Select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql';
soorajVs
- Mar 6th, 2008
Make a dump of the database to be copied : mysqldump -u root -p --databases --opt MyDatabase > MyDatabase.sql
Copy MyDatabase.sql to the second machineImport the database to MysSQL server : mysql -u root -p < MyDatabase.sql -
What is a library?
A library is a collection of subprograms including user named procedures, functions and packages.
orazeb
- Jul 11th, 2009
When some procedures, function are frequently used in your applications, you can create a library containing these functions or procedures, and call them from anyform, to avoid redundancy or writing t...
-
-
How to insert Hindi in SQL/Server database from ASP.Net application form?
nareshgoradara
- May 25th, 2009
Just write N' before value, eg.insert into YourtableName values ( N' हिंदी अनुवाद')
-
-
1st and 2nd Normalization
How to perform 1st and 2nd normalization? Explain with example.
anushandilya123
- May 8th, 2009
For a relation to be in 1st NF the relation should contain atomic attributes only that is they must be single-valued. If its not so break the composite attribute into its parts and for multivalued...
chaitra murthy
- Feb 16th, 2009
1st Normalization specifies if and only if all the attributes of the relation R are atomic in nature.Ex: First (Empno, Prjno, Prjname, Noof Hours, Empname)Empno: Employee numberPrjno: Project nu...
-
How many types of data models are there?
Three types,they are object-based logic models,record-based logic models,and physical models.
anushandilya123
- May 8th, 2009
Data Models:
Object based
Record based
Object Based:
Object Oriented
Entity Relationship Model
Record Based:
Relational
Network
HierarchicalCulver_lake
- Mar 22nd, 2006
There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of ...
-
I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help!
-
Prgma Restrict Reference
What is pragma restrict reference? Give example
-
Block Level Recovery
How can we perform block level recovery in database files?
chaitra murthy
- Apr 16th, 2009
In Oracle this is how you do:-Syntax:-SQL>block recover datafile datafilenumber block blocknumber;Ex:-SQL>block recover datafile 2 block 1234;
-
-
Connect MySQL with XML
How to Connect MySQL with XML?
hanumanbaba
- Mar 21st, 2009
use strict; use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "testuser", "testpass", { RaiseError => 1,...
hanumanbaba
- Mar 20th, 2009
adoConn.Open("Driver={MySQL ODBC 5.1 Driver};Server=VBNET4;Port=3306; Database=netmusk; User=admin; Password=pass123;Option=3; Min Pool Size=5; Max Pool Size=60; Connect Timeout=2;");
-
Hi how to place different column in on columneg:if we have address column in that we have to place addr1,addr2,addr3.
-
Database Backup & Restore
Tell the step by step procedure of taking backup of database & restore the same in case of database crash.
chaitra murthy
- Jan 9th, 2009
Well there are several methods used to backup and recover the database. So it depends on scenario which methods has to be followed.Go through the link given below to learn more about Backup & Restore:-http://download.oracle.com/docs/cd/B10501_01/server.920/a96519/toc.htm
-
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 Idea..?thanx in Advance!!
-
Multi-Dimensional and Relational Database
What is the difference between choosing a multi dimensional database and a relational database?
-
I have student table with fields name,marks1,marks2,marks3 fileds. i want the output as the student details and thier totals and their rank in class, i.e calculated at runtime.please send me the query in sql server or oracle
jmauriciovp
- Dec 18th, 2008
select row_number() over (order by a.marks1+a.marks2+a.marks3 desc) as Ranking, a.sName, a.marks1+a.marks2+a.marks3 total, a.marks1, a.marks2, a.marks3from students aorder by total desc
shubhangig
- Mar 24th, 2006
Try this query for rankingselect s.studentname,count(b.studentname)from studenttable s, studenttable bwhere s.totalmarks<=b.totalmarksgroupby s.studentname;
-
Number of Updated rows from a Procedure
How to find Number of Updated rows from a procedure which is having a Update Query?
prasads_delight1
- Dec 14th, 2008
Add COUNT keyword to the Update queary by which we can get the number of rows effected by the applied update queary. Else by using the front end code we can call the update queary as string which will run after the loop which will count the rows under the given condition. (by using a perameter)
-
Identify Replicating Table
In SyBase, How we identify which table is replicating to warm standby
Oracle Concepts Interview Questions
Ans