Number 2
1. Which of the following statements about procedures are true:
Can contain OUT parameters
Can't contain COMMIT or ROLLBACK
Are always part of a package
Can be executed using CALL
Can't be executed using EXEC
2. Which of the following statements about index-by tables are true:
Are unbounded
Can be sparse
Can be created at schema level
The subscript type can be a string
Can be processed outside PL/SQL blocks
3. Data security can be assured using:
Backup/recovery
Semantic Constraints
Encryption
Views
Concurrent access
4. Which of the following statements are true according to Codd’s rules?
Some information in the database should not be represented as relational tables
The system must support at least one non-relational language
The system should isolate all application programs (and end user accesses) from the logical structure of the database.
Low-level (record-at-a-time) interfaces can bypass relational security or integrity constraints of the system.
All data stored in the database must be logically addressable by specifying the relation, the related attribute(s), and the primary key-value
{"name":"Number 2", "url":"https://www.quiz-maker.com/Q359FOG","txt":"1. Which of the following statements about procedures are true:, 2. Which of the following statements about index-by tables are true:, 3. Data security can be assured using:","img":"https://cdn.poll-maker.com/19-756128/pll.png?sz=1200"}