The SQL SELECT INTO statement can be used to create backup copies of tables.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- 'Select Into'Statement retrieves rows and columns from one source table to a target table.
- Which command is used to make back up copies of database tables?
- Which of the following statements creates a copy of the table named source with the name target?
- Select can be used in FROM clause of SQL select.
- How many rows can be retrieved using a SELECT INTO statement in an application?
- The INTO clause is mandatory for SELECT statements within PL/SQL blocks.
- The result of a SELECT statement can contain duplicate rows.
- Is the following SQL statement True or False? CREATE TABLE dept_new7(a,b,c) AS (SELECT department_number , ...