PrepAway - Latest Free Exam Questions & Answers

Category: 1D0-430

Exam 1D0-430: CIW Application Developer

How should Mario rewrite the first line to correct the errors?

Mario is debugging his colleagues SQL statement and ASP code. He finds at least four errors in
the following section of code:
<%
SQL1 = UPDATE mytableSET LocID=0007,Material=13 1/4 Description=T-shirts ListPrice=35

WHERE
CusID=97
SQL2 = INSERT INTO authors (AU_ID, author, year_born) VALUES (7000, Joe Smith,1950)
SQL3 = SELECT * from atable where state = MD and year born<1955
key=request.querystring(“id”)
au=request.querystring(“author”)
birthyear=request.querystring(“year”)
SQLstmt=”INSERT INTO authors (AU_ID, author, year_born) VALUES (” SQLstmt= SQLstmt &
key
& “,”
SQLstmt= SQLstmt & author & “,”
SQLstmt= SQLstmt & birthyear & “)” %>
How should Mario rewrite the first line to correct the errors?


Page 14 of 14« First...1011121314