What are the two types of database?

1078

What is data model in database?

947

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

2024

how to generate an auto incremental number in a ssis package?

1071

Give us a non-computer example of preemptive and non-preemptive scheduling?

977

What do you mean by index hunting?

1184

Where is database stored?

917

What are the advantages of database system?

987

What is the difference between delete and truncate command in dbms?

1069

Differentiate table scan from index scan.

1105

How view is related to data independence?

1048

Explain the Logical Schema of Database

1063

Do we consider null values the same as that of blank space or zero?

1027

Describe the purposes and advantages stored procedure?

1095

What is the full meaning of dbms?

1138