What type of database procedures can be called in a SQLScript procedure defined with READS SQL DATA?

Prepare for the HANA Certificated Development Test. Master key concepts with flashcards and multiple choice questions, each enhanced with hints and explanations. Gear up for your certification exam!

In the context of SQLScript procedures within a HANA database, a procedure defined with the attribute "READS SQL DATA" indicates that the procedure is allowed to read data but is not permitted to modify any data in the database.

This means it can execute SELECT statements to retrieve data but cannot perform any operations that would change the state of the data, such as INSERT, UPDATE, or DELETE statements. Therefore, when a procedure is defined with "READS SQL DATA," it is specifically designed for read-only operations.

Procedures that are capable of writing or updating data would typically be marked as "MODIFIES SQL DATA," which allows for write operations across the database. However, such capabilities are not included under a procedure categorized with "READS SQL DATA." This limitation ensures that the integrity of the data is maintained when executing procedures that are solely intended for data retrieval.

Thus, the correct choice is that the SQLScript procedure can only call read-only database procedures.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy