Multiple Choice Questions - SQL Insert, Update & Delete
1)
An SQL INSERT statement adds ............... records to any single table in a relational database.
A) One
B) One or More
C) only two
D) None of Above
2)
An INSERT statement can also be used to retrieve data from other, modify it if necessary and insert it directly into the table.
A) True
B) False
3)
With SQL Insert, It is not possible to add data in specific columns.
A) True
B) False
4)
You may omit columns from an INSERT operation if the table definition so allows.
A) True
B) False
5)
The SELECT statement used in an INSERT SELECT can include a ........... clause to filter the data to be inserted.
A) Where
B) From
C) Into
D) Both A & C
6)
SELECT INTO copies data into a ..... table
A) Old
B) New
C) only System table
D) Both A & B
7)
The SQL........ statement can be used to create backup copies of tables.
A) SELECT IN
B) SELECT TO
C) SELECT IO
D) SELECT INTO
8)
The SELECT...INTO statement doesn't define a primary key for the new table, so you may want to do that manually.
A) True
B) False
9)
By default, a SELECT INTO statement must return only one row.
A) True
B) False
10)
What is this below query doing:
select distinct e1."FirstName"
into NewTable
from "employee" e1
A) The query returns all names from the field "FirstName" including duplicates and places it inside a new table giving it name "NewTable".
B) The query returns all names from the field "FirstName" excluding duplicates and places it inside a new table giving it name "NewTable".
C) The query returns all names from the field "FirstName" excluding duplicates and places it inside a new table giving it name "mynewtable"
D) Both A & B
Answers