1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?

 2 3155

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

IBM,

1 3338

can i create trigger on synonym is it possible or not please help me

CGI,

4 9432

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 5745

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

Infosys,

3 10386

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

Saama Tech, TCS,

4 9251

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

IBM, L&T,

3 5851

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

AllState,

1 2711

What are joins, explain all types of joins?

Bravura Solutions,

1718

Do you know about aggregate functions? What is row num function? Can it be used all databases?

Bravura Solutions, Cap Gemini,

1 3521

Write query to fetch second maximum salary from employee table.

Bravura Solutions, HCL,

4 6019

What is your daily office routine?

Data Vision,

1808

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

 1552

Suppose database is running slow, what will you do?

 2085

what is scan listener.

 1805

Un-Answered Questions { Databases }

How to use 'mysql' to run sql statements?

526

What are the advantages of mysql in comparison to oracle?

549

Which version of sql do I have?

558

How do I view views in sql server?

516

What is the meaning of sql server?

526




How can you take the backup and restore a mysql database using php?

479

Mention some of the important characteristics of neo4j?

5

How to provide login information for a new odbc dsn?

536

what is difference between sql plus and sql*plus? (not sql and sql plus).

3342

what is database black box testing? : Mysql dba

579

What is the difference between a unique key and primary key?

515

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

345

Explain mutating triggers.

570

What is difference between server and database?

567

What is the main difference between union and union all?

461

For More Un-Answered { Databases } Questions Click Here