DBMS Interview Questions and Answers
Question: Can you explain the SELECT INTO Statement?Answer:SELECT INTO statement is used mostly to create backups. The below SQL backsup the Employee table in to the EmployeeBackUp table. One point to be noted is that the structure of wbEmployeeBackup and wbEmployee table should be same. SELECT * INTO wbEmployeeBackup FROM wbEmployee |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is database or database management systems (DBMS)?
- What is SQL?
- What's the difference between file and database? Can files qualify as a database?
- What’s difference between DBMS and RDBMS?
- How many types of relationship exist in database designing?