SQL INTERVIEW QUESTIONS & ANSWERS
Databases
Follow Us
TAGS
| 21. | What is merge statement? |
|---|---|
| The Merge statement is used to update a record in the table by using a new record based on a condition. |
| Posted by Sibaprasadpatra. (Mar 08, 2014) | |
Merge statement is used for mixing up two data or table based on a condition. |
| 22. | How to merge rows into a table? |
|---|---|
| The Merge statement is used to both update and insert rows in a table. The Merge statement has a join specification that describes how to determine if an update or insert should be executed. |
| 23. | What is synonym? |
|---|---|
A synonym is a database object, which is used as an alias (alternative names) for a table, view or sequence.
|
| Posted by Ibrahim. (Oct 09, 2013) | |
Synonyms is a alias for database. |
| 24. | What is Data files? |
|---|---|
| Data files contains all the User's data and Oracle’s data dictionary. A data file can be associated with only one database. Database files can have certain characteristics set to allow them to automatically extend when the database runs out of space. |
| Posted by Sandeep. (Nov 05, 2013) | |
Data files which contains the actual information of the database. database can have one or more datafile and datafile should be only one database. |
|
| Posted by Ibrahim. (Oct 09, 2013) | |
Oracle database has one or more datafiles. It can access only one database. Once you create the database we cannot change the size of datafiles. |
| 25. | What are the tools for oracle? |
|---|---|
|
| Posted by Hatem. (Oct 29, 2013 ) | |
Enterprise Manager. |