Databases Interview Questions
Questions Answers Views Company eMail

What are the options available to refresh snapshots ?

2 5192

what is snapshot log ?

2 6707

When will the data in the snapshot log be used ?

2 4557

What are the benefits of distributed options in databases ?

1 3837

what is inline view?

15 37874

what is the difference between implicit conversions and explicit conversions?

2 8193

what is primary key,unique key, foreign key? can u teach me in simple language?

Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

44 174530

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

Crown Solutions,

1573

What are the type of Indexes? which one is best, why?

6 7943

How to work on DTS?what is the main requirement?

Getit, ivan,

1 4566

Whatz the main diff between Subquery and a Join

Oracle, Zeta Interactive,

14 29146

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

eBay,

3 8671

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

eBay, Google,

1 7260

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

eBay,

2056

What is cursor and where do you use them?

eBay,

2 7188


Un-Answered Questions { Databases }

What ascii 31?

520


Explain sql delete command?

608


What is similarity and difference between truncate and delete in sql?

586


What are local and global variables and their differences?

587


How many scalar data types are supported in pl/sql?

521






hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1756


Explain the use of tables option in exp command.

591


What are data resources?

502


Is sybase relational database?

481


What is left join in postgresql?

540


What is difference between statement and preparedstatement?

477


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

458


Is mysql an oracle product?

480


Why use “pivot” in sql server?

624


What is the rdbms concept in sql?

466