Databases Interview Questions
Questions Answers Views Company eMail

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 8329

what are the advantages of Oracle over other databases..? please give me reply...

2 9738

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 6946

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

L&T,

2 13415

What is the use 'return' keyword in Stored Procedure?

2 10411

hi in which phase of mload can i use .FILLER

IBM,

1 3973

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

IBM,

2411

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 3066

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 5131

what is single byte over head in oracle..?

1863

please explain database architecture..

Infosys,

1 11651

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 15693

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1797

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

Thomson,

5 7395

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

TCS,

10 17584


Un-Answered Questions { Databases }

What is join and how many types of joins?

425


What are the two modes of authentication in sql server?

517


What is difference between drop truncate and delete?

538


what is the difference between inner and outer join? Explain with example. : Sql dba

542


What is the use of microsoft access 2010?

447






What is sql used for?

638


Explain an exception and its types?

603


What are the advantages of views in a database?

642


How does mongodb replication work?

1


What is the default postgres user?

450


What are partitioned views and distributed partitioned views?

599


Which trace flags are enabled in sql server?

520


How do you see the locking status in mongo instances?

5


What is a definer?

464


Where is mongodb located?

1