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 11751

What is cluster table or non_cluster table?

1 4233

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

1846

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 7097

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,

2708

what is s/w lifecycle?

IBM,

5 7320

what is s/w lifecycle?

IBM,

1 4634

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

2161

what is difference between paging and fragmentation?

Cognizant, IOS,

1 7792

what is difference between clustering and mirroring?

Religare,

2 12159

difference between generalisation,specialisation and aggregation? with examples.

7469

what are primary key and foreign key ?

Tesco,

4 7638

What are the package used in DBMS ?

2679

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

2222

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

1982

Post New Database Management Questions

Un-Answered Questions { Database Management }

Define a relation schema and a relation.

1165

How many database systems are there?

1004

How do you create a simple database?

1036

what are the different integrity rules present in the dbms?

1054

how to restore particular schema from rman full backup?

1812

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

2142

What do you understand by data redundancy?

981

What do you understand by query optimization?

1094

what is storage manager?

984

What is the first step in creating a database?

935

What is ddl in dbms?

1034

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1887

Why do we need database?

958

What do you mean by cardinality and its types?

988

Explain what is meant by asymmetrical protocols?

1180

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