IT131-FINALEXAM-1

H Departmental Exam Review Test Submission: Departmental Exam Review Test Submission: Departmental Exam User GERALD RYAN CORVITE MARQUEZ Course DATABASE MANAGEMENT SYSTEM Test Departmental Exam Started 6/29/17 3:05 ...

H Departmental Exam Review Test Submission: Departmental Exam Review Test Submission: Departmental Exam User GERALD RYAN CORVITE MARQUEZ Course DATABASE MANAGEMENT SYSTEM Test Departmental Exam Started 6/29/17 3:05 PM Submitted 6/29/17 3:46 PM Status Completed Attempt Score 67 out of 100 points Time Elapsed 41 minutes out of 2 hours Question 1 The main components of ER diagram are Question 2 Which of the following characteristics is/are true about file system data management? 1.requires extensive programming 2. cannot perform ad hoc queries 3. security features are adequate Question 3 Match The following Question IN mode OUT Mode IN-OUT Mode Question 4 Match the following MAPUA Courses Community 1 out of 1 points 0 out of 1 points 6 out of 6 points 3 out of 5 points GERALD RYAN MARQUEZ7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 2/12 Question optional attribute composite attribute simple attribute multivalued attibute single valued attribute Question 5 This database uses specific department within an organization Question 6 A relation in BCNF is also in 3NF Question 7 A superkey without unnecessary attributes is called Question 8 Create table falls into the category of Question 9 1 out of 1 points 1 out of 1 points 0 out of 1 points 1 out of 1 points 2 out of 2 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 3/12 From the above relations R and S, what could be the values of (R - S) and (S - R) ? Question 10 Entity subtypes inherit properties from entity supertype Question 11 --------------------- relationship exists when the PK of the related entity contains the PK component of the parent entity. Question 12 Match the following Question Question 13 Count function in SQL returns the number of Question 14 The kind of the problem in the relation where deletion of some tuples can lead to loss of some other data not intended to be removed is known as Question 15 Match the following 1 out of 1 points 1 out of 1 points 4 out of 4 points 1 out of 1 points 1 out of 1 points 2 out of 4 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 4/12 Question Disjoint Subtype Overlapping Subtypes Partial completeness Total Completeness Question 16 Constraints are important because they help to ensure data integrity Question 17 Which normal form the above relation satisfies? Question 18 Entities are distinguishable Question 19 Decision makers prefers to have data than information to take right decision Question 20 Database is a collection of Question 21 Components of Information system are 1 out of 1 points 1 out of 1 points 0 out of 1 points 1 out of 1 points 1 out of 1 points 1 out of 1 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 5/12 Question 22 Data model represents Question 23 Data management focuses on Question 24 SQL statements are case sensitive Question 25 Project operator yields Question 26 select operator yields Question 27 Match The Following Question Fires when an even occurs with a particular application Fires whenever a data event or system event occurs on a schema or database execute once for each row in transaction Execute once for each transaction Question 28 Data are 1 out of 1 points 0 out of 1 points 1 out of 1 points 1 out of 1 points 0 out of 1 points 4 out of 4 points 1 out of 1 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 6/12 Question 29 Match the following Question End users' view of data Global view of the data as viewed by entire organization Representation of the database as seen by the DBMS Describing the way to store data on storage devices Question 30 In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left null Question 31 Surrogate key is applied only when the length of the primary key is too big Question 32 Relational model doesn’t encourage ad­hoc queries Question 33 Customer(custid, custname) Order(orderID, custid, date) The relationship between the above two schemes are Question 34 External model are represented by Question 35 1 out of 4 points 1 out of 1 points 0 out of 1 points 0 out of 1 points 0 out of 1 points 1 out of 1 points 1 out of 1 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 7/12 The above relation violates the condition of Question 36 Consider the relation: (student_number, student_last_name, student_phone_number, student_address) The key student_number, student-last_name is Question 37 The above divide operation yields Question 38 Entity super type contains ---------------------------- characteristics Question 39 Referential integrity ensures that 1 out of 1 points 0 out of 1 points 0 out of 1 points 0 out of 1 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 8/12 Question 40 Name the subtype discriminator attribute. Question 41 Match the following Question feasibility study user requirements detailed system specification coding, testing Question 42 Match the following Question 0 out of 1 points 2 out of 4 points 3 out of 5 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=_… 9/12 Question 43 Entity Subtype contains ------------------------- characterisrics Question 44 The attribute B is functionally dependent on attribute A if Question 45 The above diagram shows Question 46 Distinct key word is used to eliminate duplicate rows Question 47 IN operator is used to match a character pattern Question 48 Match the following Question corrective maintenanace 0 out of 1 points 0 out of 1 points 0 out of 1 points 1 out of 1 points 0 out of 1 points 3 out of 3 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=… 10/12 adaptive maintenanace perfective maintenance Question 49 Advantages of DBMS are 1. Data independence 2.Data integrity and security 3.concurrent access 4. efficient data access Question 50 Pilot Number Flight Type 111 Commercial, Military 112 Military 113 Commercial Choose the correct answer from the following choices Question 51 Key role is based on the concept known as determination Question 52 Match the following Question Books – Authors Person – Driving License Customer­ order Students­school Question 53 1 out of 1 points 1 out of 1 points 1 out of 1 points 4 out of 4 points 1 out of 1 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=… 11/12 Basic building blocks of data model are 1. Entities 2. Relationships 3. Attributes 4.Constraints Question 54 Generalization is --------------------------- process Question 55 Function must have at least one return statement Question 56 Anonymous blocks doesn't have any name Question 57 Relationship degree indicates the number of entities or participants associated with a relationship Question 58 Composite keys always have only one attribute Question 59 Which of the following decomposed tables satisfy BCNF properties? 1 out of 1 points 1 out of 1 points 1 out of 1 points 1 out of 1 points 0 out of 1 points 0 out of 1 points7/11/2017 Review Test Submission: Departmental Exam – IT131_AC1_... https://mapua.blackboard.com/webapps/assessment/review/review.jsp?attempt_id=_1867577_1&course_id=_29209_1&content_id=_349744_1&outcome_id=… 12/12 Tuesday, July 11, 2017 8:03:15 PM PHT Question 60 This DBMS function provides rules that indicates which users can access database Question 61 Age column in an employee table can be Question 62 The need of decision maker is information but not data Question 63 People involved in database system environment are Question 64 Course Id Instructor AllotedRoom IT131 XXX MKT 206 IT131 YYY MKT 106 CS133 KKK MKT 206 What is the primary key of the above table? Question 65 Which of the following characteristic of primary key is/are true? a) unique b) intelligent c) no change over time ← OK 0 out of 1 points 0 out of 1 points 2 out of 2 points 1 out of 1 points 0 out of 1 points 0 out of 1 points