1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

The select into statement is most often used to create backup copies of tables or for archiving records?

Question Posted / amrat singh


The select into statement is most often used to create backup copies of tables or for archiving reco..

Answer / Mohnish Dixit

This statement can be used to save the result of a SQL query directly into a new table, which makes it useful for creating backups or archives of data. However, it's important to note that this is not its only use as it can also be used in various other data manipulation scenarios.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is a Mapplet?

1 Answers   Informatica,

discuss about myisam index statistics collection. : Sql dba

1 Answers  

What is sp_helptext?

1 Answers  

What is dml and ddl?

1 Answers  

What is full form of rtm?

1 Answers  

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

What is a field in a database?

1 Answers  

Can we perform dml on view?

1 Answers  

What are the different schemas objects that can be created using pl/sql?

1 Answers  

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

3 Answers  

Why use subqueries instead of joins?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories