11. Data types, default values, check constraints, and NOT NULL constraints are

Question

11. Data types, default values, check constraints, and NOT NULL constraints are examples of which type of integrity? *This question is required.

a. Referential integrity

b. Entity integrity

c. Semantic integrity

d. Data integrity

12. Your Informix instance is currently NOT using encryption. You create the DISK_ENCRYPTION parameter in the $ONCONFIG file with the following value, and then restart your system.

    DISK_ENCRYPTION keystore=myinst_encrypt,cipher=aes192,rollfwd_create_dbs=encrypt

Which of the following statements are TRUE concerning your system at this point? (Choose all that apply) *This question is required.

a. The root dbspace will be encrypted

b. The myinst_encrypt.p12 and myinst_encrypt.sth files will be encrypted

c. The onstat -d command will indicate if a space is encrypted or not

d. The oncheck -pr command will indicate if a space is encrypted or not

e. Any newly created dbspaces will be encrypted by default

13. The following SQL statement is executed.

   SET CONSTRAINTS, INDEXES, TRIGGERS FOR test DISABLED;

What results does it have on the TEST table? (Choose all that apply) *This question is required.

a. All constraints on the table are not checked

b. All triggers on the table are not fired

c. All indexes on the table are not updated

d. All indexes on the table are not used for queries

14. Two indexes have been defined on table tab1. Index idx1 is defined on column c1, and index idx2 is defined on column c2. The following SQL query is executed:

SELECT … FROM tab1 WHERE c1 = 1 AND c2 BETWEEN 20 AND 30;

(where … indicates a valid SELECT list)

Which of the following statements is TRUE concerning the access path for this query? *This question is required.

a. The Optimizer can choose an access path that includes both indexes, idx1 and idx2

b. The Optimizer can only choose to use the index idx1

c. The Optimizer can only choose to use the index idx2

d. The Optimizer can choose to use either index idx1 or index idx2, but not both

Explanation / Answer

11. a. Referential integrity
12.
a. The root dbspace will be encrypted
b. The myinst_encrypt.p12 and myinst_encrypt.sth files will be encrypted
13.
a. All constraints on the table are not checked
b. All triggers on the table are not fired
c. All indexes on the table are not updated
d. All indexes on the table are not used for queries
14.
a. The Optimizer can choose an access path that includes both indexes, idx1 and idx2

Comment for any doubts

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.