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 5075

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 4527

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

4 8086

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 7733

How to create placeholder columns?

2 26626

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

4 7475

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

1 5890

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

ABC, TCS,

5988

write the Sql query for creating database backup?

TCS,

7 21241

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

iGate, Logica CMG,

1 9458

Un-Answered Questions { Databases }

Explain oracle’s server parameter file.

1043

What is sql and its types?

1265

How do you check data on pgadmin 4?

831

Explain "namespace" in mongodb.

How can we remove orphan records from a table?

1033

What is dbms pdf?

1144

Can another user execute your local temporary stored procedures?

1043

How to shrink a database?

1029

How do I insert an image into mysql workbench?

1020

What are the disadvantages of microsoft access?

971

What is a covering index?

1053

What does it mean to be case sensitive?

1068

What does asynchronous call backs means?

1253

What is difference between equi join and natural join?

1132

What is the difference between having and a where in sql?

1159

For More Un-Answered { Databases } Questions Click Here