Database Interview Questions and Answers
Ques:- What does currency type mean in database?
Ques:- What are the concurrency problems a database faces?
Ques:- How heap is implemented in database?
Ques:- What are different types of joins used in?
Ques:- What does new grouping sets enables you to do?
Ques:- What is the advantage of varchar2 over char?
Ques:- Why merge statement is used inside the database?
Ques:- How many types of normalization? What is the use of it?
Ques:- What are different types of data models available? Explain with example?
Ques:- What is difference between clustered, non-clustered and unique index?
Ques:- What is the use of default key?
Ques:- What will happen non-clustered index will be created on clustered index?
Ques:- What are the types of indexes that are present inside a database?
Ques:- Under which circumstance should you create an index on a table?
Ques:- What is a super key?
Ques:- How many indexes can be created on a table?
Ques:- How many types of locks are present in a database?
Ques:- During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Ques:- Clipper / DBF error
Ques:- how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Ques:- what are different types of datasets? what are different characteristics or properties of those datasets? what are the advantages and disadvantages of each dataset on each other?
Recent Answer : :
unfortunately, I am a beginner. I have just started learning about datasets. please give me the reply as soon as possible. It will useful for my academics. Thank you in advance. Hope I will get the best reply.
Ques:- Explain about ur projets on teradata???
Ques:- First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
Ques:- .dbf file corrupted Dear Friends, I am using DBF file in Foxpro. DBF file corrupt and show message “Not a database file” Waiting for your reply. With regards!
Ques:- Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
Ques:- query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Ques:- I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
Ques:- give a simple example of physical and logical data independence
Ques:- Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you’d like to do a diagram that will be great.please answer it
Ques:- Data structure used to implements a menu:
I’m not able to open Clipper application (app is 15 years old) because i’m getting :
error dbfntx/1012 corruption detected
Anyway to fix corrupted dbf besides restore from last backup?
Please advise.