· 8 years ago · Mar 21, 2018, 05:52 AM
1MORNING AFTER
2
3QUIZ 1
4
5Question 1
6The ERD is used to graphically represent the conceptual schema
7- TRUE
8
9Question 2
10External model are represented by
11- The external views
12
13Question 3
14Match the following:
15End users' view of data
16- The External Model
17Global view of the data as viewed by entire organization
18- Conceptual Model
19Representation of the database as seen by the DBMS
20- The Internal Model
21Describing the way to store data on storage devices
22- Physical Model
23
24Question 4
25Within the file system management, one can raise adÂhoc queries without any difficult
26- FALSE(not sure)
27
28Question 5
29Each file in the system used its own application program to store, retrieve, and modify data.
30- TRUE
31
32Question 6
33DBMS provides data access through
34- a query language
35
36Question 7
37Data model shows
38- abstraction of data(not sure)
39
40Question 8
41Oracle DBMS supports
42-
43
44Question 9
45Constraints are important because they help to ensure data integrity
46- TRUE
47
48Question 10
49Match the following
50Question
51Books – Authors
52Person – Driving License
53Customer order
54StudentsÂschool
55
56Question 11
57People involved in database system environment are
58- systems administrators, database administrators, database designers, systems analysts and programmers, and end users
59
60Question 12
61conceptual model represents
62- a global view of the entire database as viewed by the entire organization
63
64Question 13
65Match the following
66Question
67Data abstraction
68Enforces constraints
69- Data integrity and security
70Protects user from effects of system failure
71- Concurrent access and crash recovery
72Techniques used to improve storage and retrieval of data
73- Efficient data access
74
75Question 14
76The 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
77- DELETION ANOMALY
78
79Question 15
80Data are
81- Raw facts
82
83Question 16
84Entities are distinguishable
85- TRUE
86
87Question 17
88Data model represents
89- data structures and their characteristics, relations, constraints, transformations, and other constructs with the purpose of supporting a specific problem domain
90
91Question 18
92Logical structure of this model is represented by an upsideÂdown tree.
93- TRUE
94
95Question 19
96Match the following
97Question
98Supports data located at single site
99- Centralized Database
100Supports company’s dayÂday functions
101- Operational Database
102Supports specific department
103- Workgroup Database
104Runs on personal computer
105- Desktop Database
106
107Question 20
108Database is a collection of
109- End-user data, metadata
110
111Question 21
112The process of identifying and documenting business rules is essential to database design for several reasons
113- They help standardize the company’s view of data.
114- They can be a communications tool between users and designers.
115- They allow the designer to understand the nature, role, and scope of the data.
116- They allow the designer to understand business processes.
117- They allow the designer to develop appropriate relationship participation rules and constraints and to create an accurate data model.
118-
119Question 22
120Consider a doctor relation with the following attributes: doctor id, doctor_name, qualification, department_id, address, phone_number. Assume that there is a new department called Neurology department is established but no doctors are appointed so far. What anomaly could be emerged?
121- INSERTION ANOMALY
122
123Question 23
124Data management focuses on
125- proper generation, storage, and retrieval of data
126
127Question 24
128ObjectÂoriented data models are typically depicted using
129- Unified Modeling Language (UML) class diagrams
130
131Question 25
132Match the following
133Question
134Even changes in characteristics of data require changes in all the programs that access the file
135None of the previous program will work even if you add a new field to a file
136same data are stored unnecessarily at different places
137different conflicting versions of the same data appear in different places
138
139Question 26
140Relational model doesn’t encourage adÂhoc queries
141- TRUE
142
143Question 27
144Network model allows a record to have more than one parent
145- TRUE
146
147Question 28
148Relational model is free from data and structural independence
149- FALSE
150
151Question 29
152- HIERARCHICAL MODEL
153
154-----------------------------
155-----------------------------
156
157QUIZ 2
158
159Question 1
160Tuple in a table represents the multiple entity occurrence within the entity set
161- FALSE
162
163Question 2
164All values in a column must conform to the same data format
165- FALSE
166
167Question 3
168Which of the following characteristics of a table are true?
169a) each column has a distinct name
170b) each column has a specific range of values
171c) The order of rows and columns are immaterial to the user
172- A and b
173
174Question 4
175Which of the following functional dependencies are true?
176a) salary Â> bonus
177b) bonus Â> salary
178- a
179
180Question 5
181Any attribute that is part of a key is known as a key attribute
182- TRUE
183
184Question 6
185Composite keys always have only one attribute
186- FALSE
187
188Question 7
189What is the primary key of the above table?
190- Title_id
191
192Question 8
193A superkey without unnecessary attributes is called
194- Candidate Key
195
196Question 9
197Consider the relation: (student_number, student_last_name, student_phone_number, student_address) The key student_number, studentÂlast_name is
198- superkey
199
200Question 10
201Match the following
202Primary Key
203- primary key value must be unique
204Super key
205- any key that uniquely identifies each row
206composite key
207- a key may be composed of more than one attribute
208candidate key
209- superkey without unnecessary attributes,
210foreign key
211- attribute whose values match the primary key values in the related table
212
213Question 11
214Secondary key is strictly used for
215- data retrieval purposes
216
217Question 12
218Entity integrity ensures that
219- primary key column has no null entries, and all entries are unique
220
221Question 13
222Referential integrity ensures that
223- the foreign key contains a value
224
225Question 14
226Do the above tables maintain referential integrity?
227- Yes E13
228
229Question 15
230select operator yields
231- values for all rows found in a table that satisfy a given condition
232
233Question 16
234Project operator yields
235- all values for selected attributes
236
237Question 17
238From the above relations R and S, what could be the values of (R Â S) and (S Â R) ?
239R-S
240B 2
241F 4
242E 5
243
244s-r
245e 4
246c 2
247
248Question 19
249 The above divide operation yields
250Loc
2515
252
253Question 20
254Data dictionary and system catalog contain meta data
255- TRUE
256
257Question 21
258In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left null
259- TRUE
260
261Question 22
262ER diagram represents
263- organization’s activities and functions
264
265Question 23
266The main components of ER diagram are
267- entities, attributes, and relationships.
268
269Question 24
270The above notation indicates
271- crow’s foot model
272
273Question 25
274Match the following
275optional attribute
276- an attribute that does not require a value
277composite attribute
278- attribute that can be further subdivided to yield additional attributes
279simple attribute
280- attribute that cannot be subdivided
281multivalued attribute
282- attributes that can have many values
283single valued attribute
284- an attribute that can have only a single value
285
286Question 26
287The dashed line(ÂÂÂÂÂÂ) in the above diagram indicates
288- derived attribute
289
290Question 27
291Another name of unary relationship isÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ relationship
292- recursive relationship
293
294Question 28
295Relationship degree indicates the number of entities or participants associated with a relationship
296- TRUE
297
298Question 29
299Customer(custid, custname) Order(orderID, custid, date) The relationship between the above two schemes are
300- Weak relationship
301
302Question 30
303ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ relationship exists when the PK of the related entity contains the PK component of the parent entity.
304- Weak relationship
305
306Question 31
307Which of the following condition/conditions needs to be satisfied to declare an entity as weak entity?
3081. The entity is existenceÂdependent; that is, it cannot exist without the entity with which it has a relationship.
3092. The entity has a primary key that is partially or totally derived from the parent entity in the relationship.
310- both true
311
312Question 32
313A binary relationship exists
314- when two entities are associated
315
316Question 34
317Data base design must conform to a) design standards b) processing speed c) information requirements Which of the above condition/conditions are true
318
319Question 35
320car_vin and car_color in the above diagram are
321- car_vin is a primary key
322- car color is a multivalued attribute
323
324-----------------------------
325-----------------------------
326
327Procedures doesn't need to return any value TRUE
328
329function doesn't need to return any value FALSE
330
331Variables can be used for ALL
332
333In distributed database design, portion of a database resides in DIFFERENT
334
335the process of selecting the data storage and data access characteristics of the database PHYSICAL
336
337Information are raw facts FALSE
338
339To reference a bind variable, it should be prefixed by ampersand (&) symbol FALSE
340
341IN operator is used to match a character pattern TRUE
342
343Designers gather information from ALL
344
345Components of Information system are PEOPLE HARDWARE DATA
346
347Old and new quantifiers are available only in row triggers TRUE
348
349Function must have at least one return statement TRUE
350
351User defined functions can not be used in, order by or group by classes FALSE
352
353SQL statements are case sensitive FALSE
354
355Anonymous blocks doesn't have any name TRUE
356
357top down design SET DATA
358
359This design first identifies the data items and then groups them together in data sets BOTTOM UP
360
361Distinct key word is used to eliminate duplicate rows TRUE
362
363Data dictionary provides information about ROW
364
365Match The Following
366Question
367Fires when an even occurs with a particular application
368APP TRIGGER, DATABASE ROW STATEMENT
369
370Question
371feasibility study PLANNING
372user requirements ANALYSIS/DATA MODEL
373detailed system - DESIGN
374coding, testing -implementation
375
376This command permanently stores data changes COMMIT
377
378Count function in SQL returns the number of ROW
379
380Reference variable is used to store index address TRUE
381This command permanently stores data changes - COMMIT
382
383
384Count function in SQL returns the number of -- ROW
385
386Reference variable is used to store index address -- TRUE
387
388Create table falls into the category of -- DDL
389
390Like operator is used to match any of a list value -- FALSE
391
392Good naming conventions in ER modeling includes
393(i) use descriptive entity and attribute names wherever possible
394(ii) usage of prefix in attribute helps to identify tables -- ALL
395
396Function is a named PL/SQL block -- TRUE
397
398The need of decision maker is information but not data --
399 TRUE
400
401The language used in application programs to request data from the DBMS is referred to as the -- DML
402
403What the following SQL statement prints? -- 234 or 1234
404
405CASE technology helps to produce better system within a reasonable time and cos -- TRUE
406
407-----------------------------
408-----------------------------
409
410IT131 Database Management System Finals
4111. The main components of ER diagram are
412o Entities
413o Attributes
414o Relationships
415
4162. Which of the following characteristics is/are true about ï¬le system data management?
4171. requires extensive programming
4182. cannot perform ADHOC queries
4193. security features are adequate
420o 1&2
421
4223. Match The following:
423o IN Mode – ENVIRONMENT TO PROCEDURE
424o OUT Mode – PROCEDURE TO ENVIRONMENT
425o IN-OUT Mode – ENVIRONMENT TO PROCEDURE AND PROCEDURE TO ENVIRONMENT
426
4274. Match the following:
428- Optional Attribute – DOES NOT REQUIRE A VALUE
429- Composite Attribute – SUBDIVIDED TO YIELD
430- Simple Attribute – CANNOT BE SUBDIVIDED
431- Multivalued Attribute – MANY VALUES
432- Single Valued Attribute – ONLY A SINGLE VALUE
433
4345. WORKGROUP DATABASE – This database uses speciï¬c department within an organization.
435
4366. A relation in BCNF is also in 3NF – TRUE
437
4387. A superkey without unnecessary attributes is called – CANDIDATE KEY
439
4408. Create table falls into the category of DATA DEFINITION LANGUAGE
441
4429. From the above relations R and S, what could be the values of (R - S) and (S - R) ?
443R S
444A 1 A 1
445B 2 C 2
446D 3 D 3
447F 4 E 4
448E 5
449Answer:
450B 2 C 2
451F 4 E 4
452E 5
453
45410. Entity subtypes inherit properties from entity supertype – TRUE
455
45611. STRONG RELATIONSHIP exists when the PK of the related entity contains the PK component of the parent entity.
457
45812. The main components of ER diagram are
459o Overlapping with TOTAL
460
461o Overlapping with PARTIAL
462
463o Disjoint with TOTAL
464
465o Disjoint with PARTIAL
466
46713. Count function in SQL returns the number of ROWS
468
46914. DELETION ANOMALY – 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
470removed.
471
47215. Match The following:
473o Disjoint Subtype – UNIQUE SUBSET OF THE SUPERTYPE ENTITY
474o Overlapping Subtype – NONUNIQUE SUBSETS OF THE SUPERTYPE ENTITY
475o Partial Completeness – NOT EVERY SUPERTYPE OCCURENCE IS A MEMBER OF A SUBTYPE
476o Total Completeness – EVERY SUPERTYPE OCCURENCE MUST BE A MEMBER OF AT LEAST ONE SUBTYPE
477
47816. Constraints are important because they help to ensure data integrity – TRUE
479
48017. Which normal form the above relation satisï¬es?
481EMPNUM(PRIM KEY) EMPNAME JOBCLASS CHGHOUR | (JOBCLASS->CHGHOUR)
4822NF
483
48418. Entities are distinguishable – FALSE
485
48619. Decision makers prefers to have data than information to take right decision – TRUE
487
48820. Database is a collection of:
4891. END-USER
4902. METADATA
491
49221. Components of Information system are PEOPLE, HARDWARE, SOFTWARE, DATABASE, APPLICATION PROGRAMS, PROCEDURES
493
49422. Data model represents DATA STRUCTURES AND THEIR CHARACTERISTICS
495
49623. Data management focuses on PROPER GENERATION, STORAGE AND RETRIEVAL OF DATA
497
49824. SQL statements are case sensitive FALSE
499
50025. Project operator yields ALL VALUES FOR SELECTED ATTRIBUTES
501
50226. Select operator yields VALUES FOR ALL ROWS FOUND ON A TABLE
503
50427. Match The following:
505o Fires when an even occurs with a particular application – APPLICATION
506o Fires whenever a data event or
507system event occurs on a schema ordatabase – DATABASE
508o Execute once for each row in
509transaction– ROW
510o Execute once for each transaction– STATEMENT
511
51228. Data are RAW FACTS
513
51429. Match The following:
515o End users' view of data – EXTERNAL
516o Global view of the data as viewed by entire organization – CONCEPTUAL
517o Representation of the database as seen by the DBMS – INTERNAL
518o Describing the way to store data on storage devices – PHYSICAL
519
52030. In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left null – TRUE
521
52231. Surrogate key is applied only when the length of the primary key is too big – FALSE
523
52432. Relational model doesn’t encourage adÂhoc queries – TRUE
525
52633. The relationship between the below two schemes are: STRONG
527Customer(custid, custname) Order(orderID, custid, date)
528
52934. External model are represented by ER DIAGRAM
530
53135. The below relation violates the condition of 4NF
532
53336. Consider the relation: (student_number, student_last_name, student_phone_number, student_address)
534
535The key student_number, student-last_name is SUPERKEY
536
53737. The below divide operation yields 5
538
53938. Entity super type contains __ characteristics
540
54139. Referential integrity ensures that IF THE FOREIGN KEY CONTAINS A VALUE, THAT VALUE REFERS TO AN EXISTING VALID TUPLE
542
54340. Name the subtype discriminator attribute. EMP_TYPE
544
54541. Match The following:
546o Feasibility Study – PLANNING
547o User Requirements – ANALYSIS
548o Detailed System Specification – SYSTEM DESIGN
549o Coding, Testing – IMPLEMENTAION
550
55142. Match the following:
552-|| ONE TO ONE
553-O| ZERO TO ONE
554-|< ONE TO MANY
555-O< ZERO TO MANY
556--< MANY TO MANY
557
55843. Entity subtype contains UNIQUE characteristics.
559
56044. The attribute B is functionally dependent on attribute A if. A DETERMINES B
561
56245. The above diagram shows OBJECT ORIENTED MODEL
563
56446. Distinct key word is used to eliminate duplicate rows – TRUE
565
56647. IN operator is used to match a character pattern – TRUE
567
56848. Match The following:
569o Corrective Maintenance – SYSTEM ERRORS
570o Adaptive Maintenance – BUSINESS ENVIRONMENT
571o Perfective Maintenance – ENHANCE THE SYSTEM
572
57349. Advantages of DBMS are
574a. Data independence
575b. Data integrity and security
576c. concurrent access
577d. efficient data access
578- a, b, c, d, ARE TRUE
579
58050. Choose the correct answer from the following choices:
581111 COMMERCIAL
582111 MILITARY
583112 MILITARY
584113 COMMERCIAL
585
58651. Key role is based on the concept known as determination – TRUE
587
58852. Match The following:
589o Books – Authors – M-M
590o Person – Driving License – O-O
591o Customer  order – O-M
592o Students  school – M-O
593
59453. Advantages of DBMS are
5951. Entities
5962. Relationships
5973. Attributes
5984. Constraints
599- 1,2,3,4 ARE TRUE
600
60154. Generalization is BOTTOM-UP process
602
60355. Function must have at least one return statement – TRUE
604
60556. Anonymous blocks doesn't have any name TRUE
606
60757. Relationship degree indicates the number of entities or participants associated with a relationship – TRUE
608
60958. Composite keys always have only one attribute – FALSE
610
61159. Which of the following decomposed tables satisfy BCNF properties?
612A C D and C B
613
61460. This DBMS function provides rules that indicates which users can access database SECURITY MANAGEMENT
615
61661. Age column in an employee table can be INT
617
61862. The need of decision maker is information but not data – TRUE
619
62063. People involved in database system
621environment are – ALL OF THE ABOVE
622
62364. What is the primary key of the below table? COURSE ID AND INSTRUCTOR
624
62565. Which of the following characteristic of primary key is/are true?
626a. Unique
627b. Intelligent
628c. No change over time
629- A AND C ARE TRUE