1 TCO C When a COMMIT has been issued which of the following

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)

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

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 cha

1 TCO C When a COMMIT has been issued which of the following

Solution

Get Help Now

Submit a Take Down Notice