DB Administration interview questions – page 9

What is DML (Data Manipulation Language)?

What is the difference between view filter and report filter?

Do you need a commit after DDL statements?

Explain about OpenEdge Workgroup RDBMS?

What is a database instance and Explain

What is job control?how can it used explain with steps?

Give the benefits of Data integration suite?

How can you find all the tables created by an user?

What is an optimization and performance tuning and how does it really work in practical projects?

What is a public synonym

Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?

Do a view contain data

What is the datatype of the surrogate key?

What does separation option in static hash-file mean?

How is locking implemented?

What is surrogate key ? where we use it explain with example.

Why fact table is in normal form?

Explain about ETL data integration software?

Why do we need immutable objects?

What is basic teradata query language?

Explain about Power Designer Data modeling software?

What is optimization and performance tuning and How does it work in practical projects. Explain with an example.

Why do you use SQL LOADER or OCI STAGE?

What are the different types of lookups in datastage?

What is prompt?types of prompts?use of prompts?syntax of prompt?

How can I specify a filter command for processing data while defining sequential file output data?

How to handle the rejected rows in datastage?

What are the different types of lookups available in DataStage?

What is the difference between DW and BI?

What does a Config File in parallel extender consist of?