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

Database Management Interview Questions

Questions Answers Views Company eMail

what is the difference between securityand protection in dbms?

2 11635

What is cluster table or non_cluster table?

1 4141

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1796

If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains

Wipro,

2 6990

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

Oracle,

2655

what is s/w lifecycle?

IBM,

5 7100

what is s/w lifecycle?

IBM,

1 4550

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

2102

what is difference between paging and fragmentation?

Cognizant, IOS,

1 7694

what is difference between clustering and mirroring?

Religare,

2 12045

difference between generalisation,specialisation and aggregation? with examples.

7395

what are primary key and foreign key ?

Tesco,

4 7456

What are the package used in DBMS ?

2614

hi, i am new to database cau give me link where can i get about databse..

2166

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1928

Post New Database Management Questions

Un-Answered Questions { Database Management }

What is database partition key?

924

What do you understand by cursor? Mention the different types of cursor?

1056

State three differences between Dbms and Rdbms?

1068

Explain all codd's rules for relational database system?

947

What is a checkpoint and When does it occur in database?

1097

What are the types of database explain each of them briefly?

950

Which two statements are true about a foreign key?

972

What is bcnf?

1025

What are the five steps of data modeling?

985

How do you performance tune a database?

944

How does index hunting help in improving query performance?

941

Explain the terms ‘attribute’ and ‘relations’

1147

Explain some of the uses of openedge architect features useful for a developer?

924

What are the different technologies used to access Database from Visual Basic?

967

When does checkpoint occur in dbms?

1032

For More Un-Answered { Database Management } Questions Click Here