SQL INTERVIEW QUESTIONS & ANSWERS
Databases
Follow Us
TAGS
| 11. | What is cloning? |
|---|---|
| Cloning is the process of creating an identical copy of the Oracle application system. |
| Posted by Krishnareddy. (Mar 03, 2014) | |
Duplicate copy of the target database. |
|
| Posted by Ibrahim. (Oct 09, 2013) | |
Cloning is the copy of oracle database. |
| 12. | What is the difference between like and between operator? |
|---|---|
| Like operator is used for pattern matching searches. Between operator is used for checking the range of values. |
| Posted by Sibaprasadpatra. (Mar 08, 2014) | |
Like operator is used for finding out the data on a specific condition and between operator is used to find out the data with in a specific range. |
| 13. | What is Log files? |
|---|---|
| Log files are also referred to as the Redo log files or Online log files. These files contain all the changes made to the data over a period of time. There will be at least two redo log files. These files are used to rebuild the database in case of a crash. |
| 14. | What is the difference between database management system and database application? |
|---|---|
| Database Management System is the program that organizes and maintains the information. Database Application is the program that is used to view, retrieve and update information stored in the database. |
| 15. | What is the use of views? |
|---|---|
|