Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 4925

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 4454

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

4 7931

How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?

Digital Group,

3 7621

How to create placeholder columns?

2 26499

how to find out the repeated value from table using groupby function?

4 7342

can any one help me with import/export options in oracle............

1 5793

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

ABC, TCS,

5932

write the Sql query for creating database backup?

TCS,

7 21031

What is mean by "fill factor" ? and what is mean by "Index "in sql?

iGate, Logica CMG,

1 9378

Un-Answered Questions { Databases }

What is difference between db2 and sql?

1009

What is the use of set nocount on/off statement?

1101

What is entity data services?

1076

Does group by or order by come first?

965

What is relational database in mysql?

926

What is the sql case statement?

1015

Can you explain fourth normal form and fifth normal form ?

839

Which programming language is used to write mongodb queries?

What is the quickest way to export a table to a flat file?

971

Explain about various levels of constraint.

953

How to use column default values in insert statements in ms sql server?

1046

Can we use threading in pl/sql?

1044

How do I start sql server 2017?

948

Can we insert data into view?

910

What is difference between oracle sql and mysql?

1025

For More Un-Answered { Databases } Questions Click Here