Difference between revisions of "Insert Queries"

From TRCCompSci - AQA Computer Science
Jump to: navigation, search
(→‎Basic Quiz)
 
(6 intermediate revisions by the same user not shown)
Line 26: Line 26:
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
−
| Joe || Bloggs || 1 Some Street || Example || 35
+
| Joe || Bloggs || 1 Some Street || Sheffield || 35
 
|}
 
|}
−
?
+
 
 
|type="()"}
 
|type="()"}
−
+ Select 'First Name', 'Last Name' from Employees
+
+ Insert Into Employees ('First Name', 'Last Name', 'Address', 'City', 'Age') Values ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
 
||Correct
 
||Correct
−
- Select * from Employees
+
- Insert Into Employees ('First Name', 'Last Name', 'Address', 'City', 'Age') Data ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
 
||Incorrect
 
||Incorrect
−
- Select All from Employees
+
- Insert Into Employees ('First Name', 'Last Name', 'Address', 'Age', 'City') Data ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
 
||Incorrect
 
||Incorrect
−
- Select 'First Name' from Employees
+
- Insert Into Employees ('First Name', 'Last Name', 'Address', 'Age', 'City') Values ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
 
||Incorrect
 
||Incorrect
  
−
{which of the following Select queries will select the 'First Name' and 'Last Name' of every employee with the 'Last Name' of 'woman'?
+
{which of the following statements will Insert the following record:
−
|type="()"}
+
{| class="wikitable"
−
- Select 'First Name', 'Last Name' from Employees where Employee 'Last Name' = 'woman'
+
|-
−
||Incorrect
+
| Fred || Danson || 12 East Road || Leeds || 60
−
+ Select 'First Name', 'Last Name' from Employees where 'Last Name' = 'woman'
+
|}
−
||Correct
+
 
−
- Select * from Employees where 'Last Name' = 'woman'
+
1) Insert Into Employees ('First Name', 'Last Name', 'Address', 'City', 'Age') Values ('Fred', 'Danson', '12 East Road', 'Leeds', 60)
−
||Incorrect
+
 
−
- Select * from Employees where Employee 'Last Name' = 'woman'
+
2) Insert Into Employees  Values ('Fred', 'Danson', '12 East Road', 'Leeds', 60)
−
||Incorrect
+
 
 +
3) Insert Into Employees Values ('Fred', 'Danson', '12 East Road',  60, 'Leeds')
 +
 
  
−
{which of the following Select queries will select the 'First Name' and 'Last Name' of every employee over the age of 50?
 
 
|type="()"}
 
|type="()"}
−
- Select 'First Name', 'Last Name' from Employees where Employee 'Age' < 50
+
- 1 & 2 & 3
−
||Incorrect
 
−
- Select 'First Name', 'Last Name' from Employees where 'Age' < 50
 
 
||Incorrect
 
||Incorrect
−
- Select 'First Name', 'Last Name' from Employees where Employee 'Age' > 50
+
+ 1 & 2
−
||Incorrect
 
−
+ Select 'First Name', 'Last Name' from Employees where 'Age' > 50
 
 
||Correct
 
||Correct
−
 
+
- 1 Only
−
{which of the following Select queries will select the 'First Name' and 'Last Name' of every employee over the age of 50 but under the age of 75?
 
−
|type="()"}
 
−
- Select 'First Name', 'Last Name' from Employees where Employee 'Age' < 50 And 'Age' > 75
 
 
||Incorrect
 
||Incorrect
−
- Select 'First Name', 'Last Name' from Employees where 'Age' < 50 And < 75
+
- 2 Only
 
||Incorrect
 
||Incorrect
−
- Select 'First Name', 'Last Name' from Employees where 'Age' > 50 And <75
 
−
||Incorrect
 
−
+ Select 'First Name', 'Last Name' from Employees where 'Age' > 50 And Age <75
 
−
||Correct
 
  
−
{which of the following Select queries will select the 'First Name' and 'Last Name' of every record in alphabetical order by 'Last Name'?
 
−
|type="()"}
 
−
+ Select 'First Name', 'Last Name' from Employees Order By 'Last Name'
 
−
||Correct
 
−
- Select 'First Name', 'Last Name' from Employees Order By 'Last Name' Desc
 
−
||Incorrect
 
−
- Select 'First Name', 'Last Name' from Employees OrderBy 'Last Name'
 
−
||Incorrect
 
−
- Select 'First Name', 'Last Name' from Employees OrderBy 'Last Name' Desc
 
−
||Incorrect
 
 
</quiz>
 
</quiz>

Latest revision as of 10:13, 28 September 2020

INSERT adds rows to an existing table, there can be different syntax depending on specific version of SQL etc. For exam questions use one of the methods below. Also remember the values inserted should match the data types of the table fields.

Best Method

 INSERT INTO table_name
 (field1, field2, field3)
 VALUES
 (value1, value2, value3);

Alternative Method

 INSERT INTO table_name
 VALUES
 (value1, value2, value3);

Basic Quiz

All these questions will use this table called Employees:

Capture.png

1. which of the following Insert the following record:

Joe Bloggs 1 Some Street Sheffield 35
Insert Into Employees ('First Name', 'Last Name', 'Address', 'City', 'Age') Values ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
→Correct
Insert Into Employees ('First Name', 'Last Name', 'Address', 'City', 'Age') Data ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
→Incorrect
Insert Into Employees ('First Name', 'Last Name', 'Address', 'Age', 'City') Data ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
→Incorrect
Insert Into Employees ('First Name', 'Last Name', 'Address', 'Age', 'City') Values ('Joe', 'Bloggs', '1 Some Street', 'Sheffield', 35)
→Incorrect

2. which of the following statements will Insert the following record:

Fred Danson 12 East Road Leeds 60

1) Insert Into Employees ('First Name', 'Last Name', 'Address', 'City', 'Age') Values ('Fred', 'Danson', '12 East Road', 'Leeds', 60)

2) Insert Into Employees Values ('Fred', 'Danson', '12 East Road', 'Leeds', 60)

3) Insert Into Employees Values ('Fred', 'Danson', '12 East Road', 60, 'Leeds')

1 & 2 & 3
→Incorrect
1 & 2
→Correct
1 Only
→Incorrect
2 Only
→Incorrect

Your score is 0 / 0
Retrieved from ‘http://www.trccompsci.online/mediawiki/index.php?title=Insert_Queries&oldid=8150’