DB Development Interview Questions
Questions Answers Views Company eMail

In which table collections errors are stored.

2162

I have a few records all are same structures data, I want to store data in multiple targets how

CTR, Infosys, Polaris,

2373

How to read and create .LDC data files which are used by linguatic dictionary.

2283

what is difference between primary key and unique key ?

2 4519

how to find the first two highest salaries in deptno in emp table

2 5018

agregator gives one to many records or many to one record

IBM,

1 3659

fact table and dimension table containg one to many relationship or many to one relastionship

2275

can you give me the syntax of named procedure??

2 4006

A) Which two are benefits of Teradata's support for ANSI Standard SQL? (Choose two.) 1.data is distributed automatically 2.queries get optimized to better plans 3.submit queries from other database systems 4.can interface with BI tools B) Which statement is true when comparing the advantages of third normal form to star schema? 1.Star schema tends to have fewer entities. 2.Star schema requires additional data storage. 3.Third normal form tends to have fewer entities. 4.Third normal form requires additional data storage. C)Which two sets of functions does the Parsing Engine (PE) perform? (Select two.) 1.sorting, formatting, and aggregating of the final answer set 2.flow control of the data to and from the participating tables 3.SQL statement interpretation, syntax validation, and semantic evaluation 4.dispatching the step execution sequence to the AMP via the BYNET D) Which two can be achieved with Teradata Active System Management (TASM)? (Choose two.) 1.disable hardware 2.react to hardware failure 3.influence response times 4.collect metadata E) Which three mechanisms can be used to ensure security within the Teradata Database? (Choose three.) 1.views 2.spool limits 3.roles 4.access rights 5.profiles

6288

explain detail about ftp in datastage?

IBM,

2017

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

IBM,

1 3713

What is the maximum length of an extended property?

745

How can you fix a poorly performing query?

865

What is the physical representation for a many-to-many relationship?

821

What is an application role and explain a scenario when you would use one?

773


Post New DB Development Questions

Un-Answered Questions { DB Development }

explain detail about ftp in datastage?

2017


How to generate OIDS

1906


Explain about the relational database?

824


Explain about xml databases?

835


If a column is an image value type, how you can compare column values? How can you use this column in join clause?

783


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

758


Explain about relational operator join?

808


How would you design a database for an online site, which would average a million hits a day?

790


Why does this query return 0?

802


How is data stored in dbms?

706


What are data modelling techniques?

732


Where is dbms used?

836


What is the database development process?

952


Who are naive users?

784


What is DB Development software?

1816