Question

Telu 31 Using SQL, how can you insert the new record "Tom Lopez in a) INSERT INTO Members VALUES ('Tom', 'Lopez') b) INSERT VALUES ('Tom', 'Lopez') INTO Members c) INSERT ('Tom', 'Lopez') INTO Members d) INSERT VALUES INTO Members ('Tom', 'Lopez') 32 Using SQL, how can you insert "Flanders" as a "LastName" in the "Members" table? a) INSERT VALUE ('Flanders') INTO Members (LastName) b) INSERT NEW VALUE Members ('Flanders') INTO LastName c) INSERT ('Flanders') INTO Members (LastName) d) INSERT INTO Members (LastName) VALUES ('Flanders') Prior to making a file maintenance run on a computer, it is customary to sort the items on the mast and transaction files in the same order and on the same key. The principal reason for this is to a) simplify the program logic b) minimize the length of both files c) minimize the number of times the transaction file must be read d) avoid having deletions from the master file treated as errors 34 A random file update job that consistently exceeds the expected processing time would usually ind a) excessive errors by the operator b) a gradual change in program emphasis c) a decrease in the number of tape errors d) that the number of transactions being processed exceeds the average 35 Which one of the following UNC paths do you use to connect to the LASERJ printer on the STUDE server? a) STUDILASERJ b) S=STUD6\PLASERJ c) WLASERJ STUD d) IISTUD LASERJ 36 A secret way into a system that circumvents security checks and safeguards on a network is calle a firewall b) gateway c) backdoor d) network gate

Answer 1

Answer 31
***********
a) INSERT INTO Members VALUES('Tom','Lopez')

Syntax
******
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Answer 32
***********
d) INSERT INTO Members(LastName) VALUES('Flanders')

Answer 33
**********
d) avoid having deletions from the master file treated as errors

Answer 34
**********
d) \\STUD6\LASERJ

Answer 35
**********
c) backdoor

if you have any doubt then please ask me without any hesitation in the comment section below , if you like my answer then please thumbs up for the answer , before giving thumbs down please discuss the question it may possible that we may understand the question different way and we can edit and change the answers if you argue, thanks :)