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 11618

What is cluster table or non_cluster table?

1 4126

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

1789

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 6982

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,

2650

what is s/w lifecycle?

IBM,

5 7079

what is s/w lifecycle?

IBM,

1 4545

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.........

2096

what is difference between paging and fragmentation?

Cognizant, IOS,

1 7678

what is difference between clustering and mirroring?

Religare,

2 12026

difference between generalisation,specialisation and aggregation? with examples.

7381

what are primary key and foreign key ?

Tesco,

4 7429

What are the package used in DBMS ?

2606

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

2157

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????

1920

Post New Database Management Questions

Un-Answered Questions { Database Management }

What is default value database?

996

What is index hunting and how does it help in improving query performance?

1986

What are database modules?

916

How to pump the data from one database to another?

916

List few ways to code transactions in an efficient manner?

915

What are different types of joins in the sql?

994

What do database languages do?

929

Whats is an OLTP Database

1118

What is database host?

922

What is local database?

970

What are the functions of rdbms?

985

What are queries in dbms?

924

What is Data Redundancy and Consistency ?

996

What is the purpose of database management system?

1043

What is the example of rdbms?

917

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