An administrator is writing into a database and received an error detailed in the exhibit. The two steps to be taken to resolve this are :
Move the Execute SQL statement to be between Connect and Disconnect. Move the Prompt Message to be before the Disconnect statements.
Explanation:
- Dynamic SQL refers to SQL statements that are generated at run-time.
- To disconnect from a database, in the Database Navigator or Projects view, click the connection and then click the Disconnect button in the toolbar or click Database -> Disconnect on the main menu
- You can also right-click the connection and click Disconnect on the context menu
- The PROMPT command may be used to display messages to the user, perhaps supplying a short summary of what your script is going to accomplish.
- The SQL EXECUTE command executes an SQL command and binds the result to 4D objects (arrays, variables or fields).
- A valid connection must be specified in the current process in order to execute this command. The sqlStatement parameter contains the SQL command to execute.
<u>Answer:</u>
<em>Black and white</em>:
It has only two values namely black or white. The white colour in the image will be represented as “white” and other colour part will be displayed as black.
<em>Grey-scale: </em>
Again the white part does not have a change, the black and other coloured items will be displayed in grey.
<em>Coloured image: </em>
It would display the actual colour of the image. The number of colours and shades depends on the original image from where actually it has been shooted and it also depends on the quality of the camera.
