amisha_me

 Profile Answers by amisha_me Questions by amisha_me

• Dec 27th, 2007

Only the size differs in nvarchar2 length is much more compare to varchar2

Answer Question  Select Best Answer

What is the difference between Case and Decode?In what situation we can use Case and Decode

veerisetty

 Profile Answers by veerisetty Questions by veerisetty

• Jun 18th, 2008

DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode looks for a value.regardsveerisetty

Answer Question  Select Best Answer

How can I copy a table from one database instance to another database instance

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

By using Db link

Answer Question  Select Best Answer

Which one is strongest normal form? Why?

kumaranvp

 Profile Answers by kumaranvp Questions by kumaranvp

• Jul 12th, 2008

Boyce codd normal form is the strongest normal form.........

Answer Question  Select Best Answer

If 1000 users are connected to the db, and Listener is up and running suddenly system is hanging what will do ?

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 15th, 2009

In real time environment if a DB goes hang or degrades automatically the DB is allocated to next available instance. This is known as RAC i.e Real Application Cluster.

Answer Question  Select Best Answer

What is Inversion Key Entry?

skachalia

 Profile Answers by skachalia Questions by 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.

Answer Question  Select Best Answer

How to migrate db2 data to notepad?

swaroopbns

 Profile Answers by swaroopbns Questions by swaroopbns

• Apr 30th, 2008

Do you mean that you want to unlaod a db2 table into a notepad or textpad, then you can probably try this:db2> export to yourdirectory/abc.txt of del select * from tablename with ur

Answer Question  Select Best Answer

What is a tree relationship and give an example

narendranaidu.g

 Profile Answers by narendranaidu.g Questions by narendranaidu.g

• Oct 16th, 2008

It is ahierarchical relation ship. In this structure parentnode (rootnode) and then child nodes, siblings etc

Answer Question  Select Best Answer

How to find Number of Updated rows from a procedure which is having a Update Query?

prasads_delight1

 Profile Answers by prasads_delight1 Questions by 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)

Answer Question  Select Best Answer

Tell the step by step procedure of taking backup of database & restore the same in case of database crash.

chaitra murthy

 Profile Answers by chaitra murthy Questions by 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

Answer Question  Select Best Answer

How to delete duplicate records in Teradata?

ram

• Apr 2nd, 2013

SELECT column names from party group by column names;

Use Distinct or Qualify

Answer Question  Select Best Answer

When users are not able to log onto database, What are all the probable reasons?

Arpit Narula

 Profile Answers by Arpit Narula Questions by Arpit Narula

• Sep 14th, 2009

1. Database server is not up.2. User not aware of the correct credentials.3. TNS entry is not proper.4. Some network problem.

Answer Question  Select Best Answer

Where are the Background processes logging information written to?

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 12th, 2009

The information about the background process are stored in alertlog file.

Answer Question  Select Best Answer

How can we perform block level recovery in database files?

chaitra murthy

 Profile Answers by chaitra murthy Questions by 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;

Answer Question  Select Best Answer

What are the three key properties of RDBMS

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 12th, 2018

Implicit properties of Relational Database. An RDBMS is easily accessible using Structured Query Language (SQL) commands in them to manipulate data. SQL is the ISO standard language for interacting w...

Answer Question  Select Best Answer

What is included in the schema of a relational model?

Deepaklathwal

 Profile Answers by Deepaklathwal Questions by Deepaklathwal

• Apr 20th, 2010

The overall design of a relational database model is called Relational schema.

Answer Question  Select Best Answer

Which functionality of a database creates alert log?

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

Server processes will create the alert logfile.

Answer Question  Select Best Answer

Among the many databases available in the market which database is providing more user friendly behaviour and why?

maha_g3

 Profile Answers by maha_g3 Questions by maha_g3

• Jun 17th, 2010

MySql Database

Answer Question  Select Best Answer

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), count(1) from table DAY2 group by DATE(Yesturday_DATE);Here both table give separate...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jan 3rd, 2013

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

Answer Question  Select Best Answer

farhad alam

• May 22nd, 2012

Global Index : A single index covering all partitions. Local Index : Separate indexes for each partition. A local index can be unique. However, in order for a local index to be unique, the par...

Answer Question  Select Best Answer