Select a suitable language that allows users to specify the data types and structures and constraints on the data to be stored in database. O A. Data definition language O B. Structured query language O C. Data manipulation language O D. Data control language What is the result of executing the following statement? SELECT EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID AS 'DEPTID FROM EMPLOYEES WHERE DEPARTMENT_ID = 90; O A. Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPTID from the EMPLOYEES table where the department id is 90. B. Prompts the user for additional information O C. Throws an error O D. Displays the EMPLOYEE_ID, LAST_NAME, JOB_ID, DEPARTMENT_ID from the EMPLOYEES table where the department id is 90. The system's performance is low in terms of failing to respond quickly enough to meet the stated user requirement of interactive, screen-based use that has been identified as a problem during the testing process in the development of a new system. Which of the following is NOT identified the problem from that stage in the life cycle of database system development? O A. design stage - attempts at performance prediction O B. requirements collection and analysis stage - identify the user requirements O C. implementation stage - identify actual performance OD. testing stage - validate database development and design predictions What is the CORRECT possible specialization constraint? O A. Overlapping and partial O B. Disjoint and total OC. Overlapping and total O D. All of answers The figure shows a relationship between a CLIENT and their REQUIREMENT on a certain task. REQUIREMENT CLIENT Has 1. 1..1 reqtNo {PK) startDate startTime duration comments clientNo (PK) name address telno faxNo Which statement for the figure is TRUE? O A. clientNo from CLIENT is copied to REQUIREMENT entity as a foreign key. O B. Both entities are identified as weak entity. O C. REQUIREMENT is designated as parent entity and CUENT is the child entity O D. reqNo from REQUIREMENT is copied to CLIENT entity as a foreign key