if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?
Why do we need database?
Enlist various transaction phases.
How can I join two tables in database?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What is foreign key in database?
Enlist some commands of dml?
Explain the different types of languages that are available in the dbms?
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?
What is 2nf in dbms?
Can A CONTROL BLOCK can sometimes refer to a Basetable ?
What is the purpose of database?
What is atomicity in dbms?