Which of the following is an incorrect statement?Question 7Select one:a.Host variables are programming language variables that should only be used for static SQL processing.b.The SQLCODE is one such variable in the data structure which is set to 0 (zero) after every successful SQL execution.c.SQLSTATE provides a more specific message that is standardized across different database vendor products.d.Dynamic SQL statements include parameters whose values are not known until runtime when they are supplied as input to the application.

Which of the following is an incorrect statement?Question 5Select one:a.Embedded SQL has the capability of executing SQL statements dynamically.b.Database APIs are totally dynamic.c.Database API is used to develop applications independently of target databases.d.The intermediate layer between the application and programming language is the database connectivity driver.

Which of the following is an incorrect statement?Question 33Select one:a.Access plans for dynamic SQL statements are generated only at runtime.b.Dynamic SQL applications are slower than static SQL applications.c.The access plan generated for a static SQL statement is stored in advance.d.If the static SQL part of the application is modified, then the regeneration of access plans is not needed.

Variables are classified according to their: A) Data type B) Value C) Location in the program D) Names

Which of the following is not true about SQL statements?1.0 MarksSQL statements are not case sensitive.SQL statements can be written on one or more lines.Keywords cannot be split across lines.Clauses must be written on separate lines.

Among the given statements about database management applications, which is NOT TRUE?Select one:a.The SQL (Structured Querying Language) programming language is a popular language used for database programming.b.Database management applications offer security by restricting access to data based upon user names and passwords.c.In a database, several people can access the same data at the same time.d.None of these