Assume you have an SQL Action query that looks like this: INSERT into CourseTabl

Question

Assume you have an SQL Action query that looks like this:
INSERT into CourseTable (CourseCode, CourseDescription, CourseCreditHours, DateStarted, Elective) VALUES('BIS245', 'Database Concepts', 4, #2/1/2008#, Yes). Which of the following statements is true about this statement?

      a) The statement should start with UPDATE, not INSERT.
       b) The statement will run without errors.
       c) The date 2/1/2008 should be enclosed in double quotes, not pound signs.
       d) The Yes value should be enclosed with percent signs.

Explanation / Answer

b)the statement will run without errors as everything is fine. since all other options are wrong. moreover we can still make it better for similification:

another better way for simplication can be

INSERT into CourseTable (CourseCode, CourseDescription, CourseCreditHours, DateStarted, Elective) VALUES('BIS245', 'Database Concepts', 4, '2008-01-02', 'Yes').

When supplying the data values to be inserted into the new table, the following should be considered while dealing with different data types.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.