- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 1 (29.59 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 2 (24.47 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 3 (23.22 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 4 (22.76 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 5 (19.57 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 6 (22.04 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 7 (22.73 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 8 (13.34 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 9 (23.59 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 10 (26.63 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 11 (28.23 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 12 (26.84 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 13 (28.43 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 14 (19.9 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 15 (24.96 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 16 (20.63 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 17 (26.73 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 18 (21.43 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 19 (25.6 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 20 (23.35 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 21 (24.6 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 22 (22.71 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 23 (25.47 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 24 (23.85 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 25 (26.75 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 26 (23.04 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 27 (14.14 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 28 (27.61 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 29 (22.47 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 30 (17.46 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 31 (28.87 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 32 (29.21 KiB) Viewed 24 times
- D Question 1 Which Of The Following Are Advantages Of A Dbms O Data Dependence O Incompatible File Formats O Database C 33 (22.34 KiB) Viewed 24 times
Question 2 A view in the relational database model corresponds to which level of the ANSI-SPARC Architecture? physical conceptual external 1 pts all of the above
D Question 3 Most DBMSS function as part of a(n) O embedded application O linkable library client-server system O none of the above 1 pts
D Question 4 Select the pair that correctly completes the following sentence: A relation schema is a set of i). and ii) pairs. 4 O i) null, ii) relation Oi) attribute, ii) domain name 1 pts Oi) tuple, ii) attribute Oi) primary key, ii) foreign key
ts S tions 55 Question 5 To find the average of a column of a relational database table with the relational algebra, you would use the join operator the union operator the average aggregate function O the project operator 1 pts k
nts ns rations d J Question 6 The insert into query always generates an error if O it attempts to add multiple tuples to a table O it attempts to add null values to column not label NOT NULL O it attempts to add a tuple that incides a foreign key O it attempts to add a tuple identical to an existing table tuple Question 7 1 pts 1 pts
D Question 7 The insert into query can select values through query to add to a table can specify multiple tables to insert value into can only add a single tuple to a table can update individual columns of a table bulu O 1 pts
ents ons D Question 8 The simplest SQL statement consists of only a 1 pts
D Question 9 1 pts True or False: select distinct EID from Employee; will always produce the same set of rows as select EID from Employee; if EID is the primary key of the table Employee. O True O False
D Question 10 True or False: A left outer join of will show tuples from the left table of the join which do not match the join condition. O True O False 1 pts Question 11 1 pts
Question 11 Privileges to other users to a table ca be control by the O grant statement O revoke statement O both 1 and 2 O neither 1 nor 2 i 1 hulu 1 pts
Question 12 A create view statement creates a new table with its on data using the view select query. True O False 1 pts Question 13 1 pts
Question 13 1 pts A foreign key constraint in a create table statement can omit the primary key columns in the refered to table if they have the same names as the foreign key columns. O True O False
Question 14 If an alter statement drops a table column, the DBMS will stop the drop in the table column has data values. O True 1 pts O False
D Question 15 An alter table statement O will delete table values when a column is removed can be used to set a default value allows the creation of a new column in a table O all of these are true 1 pts
D Question 16 A relationship type always involves to entity types. O True False Question 17 G hubu C 1 pts 1 pts
Question 17 A weak entity type O is dependent on a strong entity type O has the least number of attributes O has no relationships with any other entity type O has the least number of relationship types 1 pts
D U Question 18 A relationship type may have attributes of its own. O True O False Question 19 1 pts 1 pts
75 Question 19 A specialization/generalization relationship can be overlapping or disjoint O weak or strong O one or many none of these Question 20 1 pts 1 pts
D Question 20 The data model represented by an ER diagram is subject to O chasm traps O fan traps O neither of these O both of these 4 1 pts 1nts
D Question 21 In Third Normal Form, the only functional dependencies on a table are those that define candidate keys for the table. True O False Quentin 33 hale 1 pts O
D Question 22 If A - B and A-> C are functional dependencies on a table O then so is B - C O then so is C -> B then so is B,C -> A O then so is A-> B.C Question 23 1 pts 1 pts
D Question 23 If a table is in Second Normal Form, it is also in Third Normal Form if each non-primary key attribute is fully dependent on the primary key no non-primary key attribute is transitively dependent on the primary key all functional dependencies define candidate keys all attributes are atomic and there are no duplicate rows Question 24 1 pts 1 pts
ons Five Question 24 1 pts The one advantage of 3NF decompositions over BCNF decompositions is O 3NF decompositions are subject to fewer update anomalies than BCNF decompositions O 3NF decompositions are always dependency preserving, but BCNF decompositions are not O 3NF decompositions are always lossless, but BCNF decompositions are not O none of these 311 P 2/12/20
D Question 25 Boyce-Codd decompositions of a table are always dependency preserving. O True O False 1 pts 1 pts.
False Question 26 Two-phase locking and timestamping produce the same serializable schedules. O True False Question 27 1 pts 1 pts
D Question 27 XML is only used for database applications True False 1 pts
Question 28 An XML file is sensitive to the order of elements but not to the order of attributes. That is, if the order of elements is different in two XML files, they are different; if the order of attributes is different, the files are the same. O True 1 pts False 1 pts
D False Question 29 An object-relational schema can include user defined types references through OIDs to other tables O both of these 4 O neither of these 1 pts
Question 30 A table in an object-relational database cannot have complex valued attributes O True O False 1 pts
5 tions 7 Question 31 Use the database schema for Hotels (primary keys are underlined): Hotel(HotellD, HotelName, HotelCity) with data 100, HotelBoston, Boston 101, HotelManchester, Manchester 102, HotelDenver, Denver Room(HotellD, RoomNO, type, price) HotellD is a foreign key referencing Hotel (HotellD) type can be only the values single, double, suite 100, 1, double, 120 100, 2, single, 80 101, 1, double, 150. 101, 2, double, 160 102, 1, suite, 200 102, 2, single 100 Guest(GuestID, GuestName, Phone) 100, Joe Smith, 555-555-5555 101, Sally Smith, 555-555-5556 102, Sue Jones, 555-555-5637 1 pts Booking(GuestID, Hotell D, RoomNo, startDate, endDate) GuestID is a foreign key referencing Guest(GuestID) HotellD is a foreign key referencing Hotel(HotellD) HotellD, RoomNo is a foreign key referencing Room(HotellD, RoomNo) Which of the tuples below can be added to the Booking table?
llabus Modules ssignments Discussions Quizzes Files Grades People Collaborations Nearpod Office 365 Google Drive Badges 101, 1, double, 150. 101, 2, double, 160 102, 1, suite, 200 102, 2, single 100 Guest(GuestiD, GuestName, Phone) 100, Joe Smith, 555-555-5555 101, Sally Smith, 555-555-5556 102, Sue Jones, 555-555-5557 Booking(GuestID, HotellD, RoomNo, startDate, endDate) GuestID is a foreign key referencing Guest(GuestID) HotellD is a foreign key referencing Hotel(HotellD) HotellD,RoomNo is a foreign key referencing Room(HotellD, RoomNo) Which of the tuples below can be added to the Booking table? O 100, 100, 99, 11/21/2015, 11/24/2015 O 100, 100, 103, 11/21/2015, 11/24/2015 O 100, 100, 1, 11/21/2015, 11/24/2015 O 102, 103, 103, 11/21/2015, 11/24/2015 $13
5 ments ions orations od 365 Question 32 Consider the following schema and functional dependencies: Company(EmpNo, EmpName, EmpPhone, DeptNo, DeptPhone) EmpNo EmpName, EmpPhone, DeptNo DeptNo-> DeptPhone What is the highest normal form that Company is in? O First Normal Form O Second Normal Form O Third Normal Form O Boyce-Codd Normal Form 1 pts 1pts