Databases Interview Questions
Questions Answers Views Company eMail

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

Zenith,

1 8297

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

2 9694

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 6921

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

L&T,

2 13382

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

2 10365

hi in which phase of mload can i use .FILLER

IBM,

1 3948

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

IBM,

2394

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

1 3035

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

Apollo,

2 5102

what is single byte over head in oracle..?

1843

please explain database architecture..

Infosys,

1 11615

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

2 15630

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?

1779

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 7344

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 17490


Un-Answered Questions { Databases }

Can you list down the different components of physical and logical database structure?

1


What is self contained scalar sub query?

511


Do you know how to make remote connection in database?

532


what is the difference between functional dependecy and multilevel dependency?

1970


What will you get by the cursor attribute sql%found?

514






How do I shrink an ldf file?

534


What do you understand by intension and extension?

472


What is foreign key and example?

485


can you tell how can you display the maximum salary in sql? : Mysql dba

445


What is an oracle database?

590


What is identity column in sql server?

496


What are the built-in functions used for sending Parameters to forms ?

2821


Is it true, that there is no difference between a rule and a check constraint?

504


how can a session indicate its interest in receiving alerts?

540


What are the three pl sql block types?

544