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


Databases Interview Questions
Questions Answers Views Company eMail

statement string in open is null or 0 length ORA-40735

RoboSoft, Unilog,

1 8828

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

Microsoft,

8 50880

How can your resolve deadlocks?

IBM, IMS, Iron Mountain, NuWare,

4 13643

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

Microsoft,

1 4913

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

 2 4697

How we can copy one table data into another table whose name same as table but in differ database

 8 15787

WHAT IS INDEXING?

Patni,

3 5856

What is the concept of Virtual field?

EDS,

1628

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

Microsoft,

7 10622

what is the difference between db2start command and start database manager command?

 1 4574

write query for fourth maximum salary from employee table

Mind Tree, SP Software,

14 20622

types of indexes and the rationale behind choosing a particular index for a situation.

 1986

how the indexes are stored in the Oracle Database?

 1742

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

Oracle,

1832

various types of hints and their usage

 2135

Un-Answered Questions { Databases }

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

656

What are the four objects in a database?

510

dear sir please provide what question will be asked in bank it officer interview

1726

What is the difference between commit and rollback?

510

Explain system rowset functions?

564




Explain what is the function of sql server agent windows service?

550

Explain table valued parameters in sql server? Why tvp used?

562

Mention how deadlock can be resolved?

532

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2476

What is difference between database and server?

498

Explain the different types of constraints in dbms?

493

How to determine the location of the data directory?

504

Explain different types of self contained sub query?

546

Query to retrieve record for a many to many relationship ?

2081

Explain the difference in execution of triggers and stored procedures?

573

For More Un-Answered { Databases } Questions Click Here