Match each definition with its related term: The changes made by transactions that have committed their modifications become permanent. The effect of a transaction is not visible to other transactions until it finishes. The transaction is started from a consistent state of the data and ends leaving it also with consistent data. All tasks of a transaction are performed correctly, or none of them are performed.
Data insertion in Oracle's Application Express graphical tool is performed, once the table has been selected, from: Data Tab > Edit Button > Insert Row. Table Tab > Insert Row. Table Tab > Add Column. Data Tab > Insert Row.
Is it possible to partially undo changes made by a transaction? Yes, by executing the undo command for all changes in the transaction. Yes, by setting a restore point and executing the undo command for changes up to that point. No, only all operations contained in the transaction can be undone. No, it is impossible to undo any type of change ordered in a transaction.
Data editing in Oracle's Application Express graphical tool is performed, once the table has been selected, from: Data Tab > Edit Icon. Data Tab > Delete Button > Insert Row. Table Tab > Modify Column. Edit Tab > Modify Row.
To insert, modify or delete data from a table using Oracle's Application Express graphical tool, you must start from the button: Administration. Utilities. Object Browser. SQL.
If a letter is attempted to be written in a numeric field when inserting a new record or editing the data of an existing one, what happens when trying to save the data? An error is obtained but the other correct data changes are saved. There is no warning. The user must check it. That value is saved as null. An error is obtained and no changes are made.
What is the name of the property in which foreign key values in a table always have correspondence with a primary key value in another table? Shared locking. Referential integrity. Data consistency. Data concurrency.
What character should be used in the INSERT statement in SQL to separate the values in the value list? Comma. Period. Space. Semicolon.
In pessimistic locking, it is performed immediately when the lock is requested. True or false? True False.
In the INSERT statement of SQL, is it mandatory to indicate all the fields of the table? True or false? True False.
|
