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.
Answer:
Option A is the correct answer choice for the above question.
Explanation:
The computer system needs intercommunication which is done inside the processor to process the task given by the user. There are two types of model is used for intercommunication--
- Message passing and
- Shared memory
The difference between two is that message passing passes the message on two points at a single unit of time whereas shared memory simultaneous shares the multiple messages. That's why shared memory is faster than message passing.
- Hence option A is the correct choice because it also refers to the above concept. While the other is not correct because--
- Option B states that message passing is faster than shared memory which is wrong.
- Option C states that message passing is used for large data but shared memory is used for large data.
- Option D states that shared memory is unavailable in some processor which is wrong.
Answer:
Networks prevent unauthorized access to data and protect equipment. Networked computers are less likely than single computers to suffer equipment failure. Networks allow computers to connect quickly and to share data or equipment.
Explanation:
Answer:
Required memory size is 16k x 8
16k = 24 x 210 = 214
Hence, No. of address lines = 14
No. of data lines = 8
a) Size of IC 1024 x 1
Total number of ICs required = 16k x 8 / 1024 x 1 = 16 x 8 = 128
b) Size of IC 2k x 4
Total number of ICs required = 16k x 8 / 2k x 4 = 8 x 2 = 16
c) Size of IC 1k x 8
Total number of ICs required = 16k x 8 / 1k x 8 = 16 x 1 = 16
Explanation:
For a, 10 address lines from A0 to A9 are used to select any one of the memory location out of 1024 memory locations present in a IC.
For b, 11 address lines from A0 to A10 are used to select any one of the memory location out of 2k=2048 memory locations present in a IC.
For c, 10 address lines from A0 to A9 are used to select any one of the memory location out of 1k=1024 memory locations present in a IC.