Answer / hr@tgksolutions.com

Partitioning divides a large table into smaller, more manageable pieces.
Types of partitioning:
• Range Partitioning – Divides data based on a range of values.
• List Partitioning – Divides data based on a predefined list of values.
• Hash Partitioning – Distributes data based on a hash function.

Explain fully functional dependency?

0 Answers  

---

Is declare cursor executable?

0 Answers  

---

What is bcnf in the dbms?

0 Answers  

---

what are database files, control files and log files. How many of these files should a database have at least? Why?

0 Answers  

---

Explain data independence?

0 Answers  

---

What is foreign key in dbms?

0 Answers  

---

what is the difference between delete and truncate?

4 Answers  

---

How many columns are in a database table?

0 Answers  

---

Does youtube use a database?

0 Answers  

---

When we will denormalize data?

0 Answers  

---

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers  

---

Is it possible to Disable the Parameter form while running the report ?

1 Answers  

---