1. (TCO C) When a COMMIT has been issued, which of the following have been relea
ID: 3938748 • Letter: 1
Question
1. (TCO C) When a COMMIT has been issued, which of the following have been released? (Points : 2) All memory holds on the data have been released.All data changes since the previous commit are saved and available to other users.
All changes are discarded.
All changes to the last savepoint are available to other users. Question 2.2. (TCO C) What statement will allow a partial rollback of certain DML statements within a transaction? (Points : 2) The ROLLBACK TO SAVEPOINT <savepoint>
COMMIT
ROLLBACK
ROLLFORWARD Question 3.3. (TCO D) Examine the table instance chart for the MANUFACTURER table. Which command would you use to create an index for the manufacturer_name column?(Points : 2) CREATE INDEX manufacturer(manufacturer_name);
CREATE INDEX manufacturer_manufacturer_name_idx ON Manufacturer;
CREATE INDEX manufacturer(manufacturer_name) manufacturer_manufacturer_name_idx;
CREATE INDEX manufacturer_manufacturer_name_idx ON manufacturer(manufacturer_name); Question 4.4. (TCO D) Which statement would you use to remove the EMPLOYEE_ID_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?(Points : 2) ALTER TABLE employee
DROP PRIMARY KEY;
ALTER TABLE employee
DELETE PRIMARY KEY CASCADE;
MODIFY TABLE employee
DROP CONSTRAINT employee_id_pk CASCADE;
ALTER TABLE employee
DROP PRIMARY KEY employee_id_pk CASCADE;
MODIFY TABLE employee
DELETE PRIMARY KEY employee_id_pk CASCADE; Question 5.5. (TCO D) Which type of constraint can only be defined at the column level? (Points : 2) CHECK
UNIQUE
NOT NULL
PRIMARY KEY
FOREIGN KEY Question 6.6. (TCO D) Which command would you use to remove the MAN_CON_NAME_IDX index? (Points : 2) DROP man_con_name_idx;
DELETE man_con_name_idx;
DROP INDEX man_con_name_idx;
DELETE INDEX man_con_name_idx; Question 7.7. (TCO D) Which data type is used for representing a variable-length nonbinary string? (Points : 2) STRING.
VARCHAR
CHAR
TEXT. 1. (TCO C) When a COMMIT has been issued, which of the following have been released? (Points : 2) All memory holds on the data have been released.
All data changes since the previous commit are saved and available to other users.
All changes are discarded.
All changes to the last savepoint are available to other users.
Explanation / Answer
1> All data changes since the previous commit are saved and available to other users.
Because Commit is the process of saving the data processed by the transaction.
2> The ROLLBACK TO SAVEPOINT <savepoint>
This statment will allow partial rollback of certain DML statements in a transaction.
3> CREATE INDEX manufacturer_manufacturer_name_idx ON manufacturer(manufacturer_name);
Because the general syntax for create index are :
4> ALTER TABLE employee
DROP PRIMARY KEY employee_id_pk CASCADE;
5> NOT NULL
because NOT NULL constrain always be defined at the column level.
6> DROP INDEX man_con_name_idx;
because syntax is DROP INDEX index_name
7> VARCHAR
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.