Quiz
| 1: | Which of the following statements will successfully insert a row into the employee table?
insert into employee values
set employeeID=NULL, name='Laura Thomson',
job='Programmer', departmentID=128;
insert employee values
(NULL, 'Laura Thomson', 'Programmer', 128);
insert into employee values
(NULL, Laura Thomson, Programmer, 128);
insert employee values
(NULL, 'Laura O'Leary', 'Programmer', 128);
| | 2: | The REPLACE statement
is similar to INSERT except that where a key clash occurs, it will replace the old row with the new row is similar to INSERT except that where a key clash occurs, it will keep the old row and discard the new row is similar to UPDATE except that where a key clash occurs, it will replace the old row with the new row is similar to UPDATE except that where a key clash occurs, it will keep the old row and discard the new row
| | 3: | The --i-am-a-dummy startup option for the mysql client
prevents you from inserting any data prevents you from updating data without specifying a key constraint prevents you from deleting data without specifying a key constraint both b) and c)
| | 4: | By default, fields in data files for load data infile are separated by
commas spaces tabs pipes
| | 5: | The optional LOCAL clause in LOAD DATA INFILE
specifies that the client and server are running on the same machine specifies that the data file is on the server specifies that the data file is on the client specifies that the server is running on the local host
|
|
