1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

Parexel,

1 6395

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

HCL, LN,

5 17415

give a simple example of physical and logical data independence

 2103

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

MTS,

7 8639

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

 1911

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

Cap Gemini, MTS,

4 10637

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 7238

How to find only %th Highest Sal

Infogain, Symphony,

6 10073

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 5117

How will you make performance better for application including front end and back

Metric Stream,

2 8848

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

CTS,

2 9633

What are the Diff B/W Cursor and REF Cursor

CTS,

3 11761

difference between table level constraint and column level and advantages of table level constraint

Doyensys,

4 13640

Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 5128

What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

Sutherland,

1 8037

Un-Answered Questions { Databases }

Have you created fact table and dimension tables?

341

How can you import tables from a sql file into a database by using the mysql client?

548

List various types of log-based recovery in DBMS.

576

How do I create an access database from multiple excel files?

376

How do I start mysql in linux?

482




What are the different types of modules in oracle forms?

564

what is sql? : Sql dba

559

Can you achieve primary key - foreign key relationships in mongodb?

1

what are tables and fields? : Sql dba

584

What is 'mysqlshow'?

638

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

286

What are the authentication modes in sql server? How can it be changed?

607

Does my odi infrastructure require an oracle database?

324

Mention what is cluster?

1

How would you configure burn factor in sybase?

487

For More Un-Answered { Databases } Questions Click Here