Databases Interview Questions
Questions Answers Views Company eMail

i want table name basis on column name.

5 6760

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

iFlex,

3 6810

In clustered and non clustered indexes which one is faster while executing a query ?

1 6925

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 4161

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

FA, GE, Wipro,

11 23676

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

Polaris,

5 9984

How to create logins using windows Authentication mode?

2 3763

write the query for taking database restore in sql?

2 4642

What is the difference between OLEDB and ODBC

CFCI,

4 11011

What are mdf,ndf,ldf files and how to see the data in those files?

Accenture,

6 58104

what are the API of GL,PO,AP

1772

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

1961

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1976

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

Value Labs,

2082

What is the difference between DTS and SSIS?

Allianz,

3 35847


Un-Answered Questions { Databases }

What is a php database?

451


what is constraints?

626


Difference between oracle's plus (+) notation and ansi join notation?

570


What is meant by database management system?

481


What is local temp table?

551






Is mongodb still popular?

1


Is sql a scripting language?

513


Explain how to maintain a fill factor in existing indexes?

526


Explain the function of optimizer in oracle?

594


Describe the difference between homogeneous and heterogeneous distributed database.

510


What is a private synonym?

1079


how to take backup bcp out for a column in table in sql server?

1638


What is 'write-ahead log' in sql server 2000 ?

625


What is a parameter file in oracle?

557


How to export data from database and import into another?

456