ột COMMIT trong Oracle: a. Kết thúc một giao dịch b. Bắt đầu một c. giao dịch mới Là tự động ngay trước khi bất kỳ tuyên bố DDL là chạy d. Là tự động ngay trước khi bất kỳ tuyên bố DML là chạy e. Loại bỏ bất kỳ ổ khóa được tổ chức bởi các giao dịch hiện tại 33. Trong giai đoạn thiết kế khái niệm của vòng đời cơ sở dữ liệu: a. Bình thường hóa diễn ra. b. | Final Exam 32. A COMMIT in Oracle a. Ends a transaction b. Begins a new transaction c. Is automatic just before any DDL statement is run d. Is automatic just before any DML statement is run e. Removes any locks held by the current transaction 33. During the conceptual design phase of the database life cycle a. Normalization takes place. b. The conceptual data model is updated. c. Reports are designed. d. The development database is created. e. New entities may be discovered. 34. During the logical design phase of the database life cycle a. Normalization takes place. b. The development database is created. c. Database queries are written. d. Program specifications are written. e. Database performance tuning takes place. 35. During the physical design phase of the database life cycle a. Normalization takes place. b. The logical data model is converted to one or more physical models. c. DDL is written to define database objects. d. Application programs are written. e. Database indexes may be added. 36. During the construction phase of the database life cycle a. Normalization takes place. b. Any required data conversion is tested. c. New entities are discovered. d. Application programs are written. e. Development and test databases are created. 37. During the implementation and rollout phase of the database life cycle a. User training takes place. b. Users are placed on the live system. c. Quality assurance testing takes place. d. The old and new applications may be run in parallel. e. Enhancements are designed. Databases Demystified 38. During the ongoing support phase of the database life cycle a. Enhancements are designed and implemented. b. Bug fixes take place. c. Patches may be applied if needed. d. The staging environment is no longer needed. e. Schema changes are never required. 39. Dr. . Codd invented a. The star schema b. Normalization c. The ERD d. The relational database e. Data warehousing 40. The purpose of normalization is to a. Optimize .
