Sample test

docx

School

Swinburne University of Technology *

*We aren’t endorsed by this school

Course

10001

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by MinisterOkapiPerson1098

Sample test Question 1 1 pts The primary key must be Group of answer choices Both Unique and Not null Unique Not null Either Unique or Not null Question 2 1 pts A foreign key is Group of answer choices A column or several columns containing the primary key of another table Used to define data types Used to define null status All of the above are correct Question 3 1 pts To include the attributes whose value always have some value in a table, which of the following constraint must be used? Group of answer choices Not null Null Unique Distinct Question 4 1 pts Which of the following is NOT a basic element of the E-R model? Group of answer choices Primary keys Entities Attributes Relationships Question 5 1 pts For a weak entity set to be meaningful, it must be associated with another entity set, called the Group of answer choices Owner entity set Identifying relationship set Neighbour entity set Normal entity set PreviousNext Question 6 1 pts

For some relations with redundancy, changing the data can have undesirable consequences called Group of answer choices Update anomalies Referential integrity constraints Normal forms Transitive dependencies Question 7 1 pts Which of the following is not true for XML? Group of answer choices The semantics of XML tags are pre-defined by system. XML allows you to define your own tags. XML is a meta-language for describing markup language. XML is designed to describe semi-structured data exchanged on the internet. Question 8 1 pts _______ is not a well-formed element? Group of answer choices <formula>a+b<c</formula> <foo /> <foo bar='root'/> <system_user first_name="John" last_name="Smith" /> Question 9 1 pts Which of the following is NOT a pure NoSQL database system? Group of answer choices SQL Server MongoDB BigTable Neo4J Question 10 1 pts Which of the following strings match /^[A-Z][a-z]*[\?!]+$/ ? Group of answer choices Mmmmm!!!! Hello hello! ASCII?! Question 11 2 pts For the following schedules which involve three transactions (where ri(x) means that transaction i reads item x, wi(x) means that transaction i writes item x, and ci means that transaction i commits), which of the schedule is NOT serializable? Group of answer choices

r1(x), r2(y), r3(x), w1(x), w2(y), r2(y), r1(z), w1(z), r3(z), c2, c3, c1 r1(x), r2(y), w1(x), w2(y), r2(y), r1(z), w1(z), r3(z), r3(x), c2, c1, c3 r1(x), w1(x), r1(z), w1(z), r2(x), w2(y), r2(y), r3(z), r3(x), c2, c1, c3 r1(x), r2(y), w1(x), r1(z), w1(z), r3(z), r3(x), w2(y), r2(y), c1, c3, c2 Question 12 2 pts Consider the universal relation R = {A, B, C, D, E, G, H} and the set of functional dependencies F = {{A, B}→{C}, {A}→{D}, {B}→{E}, {E}→{G, H}}. Which of the following normal form holds for the relation R? Group of answer choices 1NF 2NF 3NF BCNF Question 13 2 pts Consider the universal relation R = {A, B, C, D, E, G, H} and the set of functional dependencies F = {{A, B}→{C}, {A}→{D}, {B}→{E}, {E}→{G, H}}. If R is not in 3NF or BCNF, decompose it so that the decomposed relations satisfy 3NF. Which of the following is the result after decomposition? Group of answer choices R1(A, B, C), R2(A, D), R3(B, E), R4(E, G, H) R1(A, B, C), R2(A, D), R3(B, E, G, H) R1(A, B, C), R2(D, E, G, H) R(A, B, C, D, E, G, H) Question 14 2 pts A collection named inventory is populated with the following documents. db.inventory.insertMany( [ { item: "journal", status: "C", size: { h: 14, w: 21, uom: "cm" }, tags: [ "black", "red" ], instock: [ { warehouse: "A", qty: 5 } ] }, { item: "notebook", status: "A", size: { h: 8.5, w: 11, uom: "in" }, tags: [ "red", "black" ], instock: [ { warehouse: "C", qty: 5 } ] }, { item: "paper", status: "D", size: { h: 8.5, w: 11, uom: "in" }, tags: [ "red", "black", "plain" ], instock: [ { warehouse: "D", qty: 60 } ] }, { item: "planner", status: "D", size: { h: 22.85, w: 30, uom: "cm" }, tags: [ "black", "red" ], instock: [ { warehouse: "C", qty: 40 } ] },

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

{ item: "postcard", status: "A", size: { h: 10, w: 15.25, uom: "cm" }, tags: [ "blue" ], instock: [ { warehouse: "B", qty: 15 }, { warehouse: "C", qty: 35 } ] } ]); Which of the following CRUD operation finds all items from the inventory collection where both the status and warehouse equal "D". Group of answer choices db.inventory. find ({ status : "D", "instock.warehouse": "D" }) db.inventory.find( { status: "D"} ) db.inventory. find ({ status : "D", "warehouse": "D" }) db.inventory. find ({ $or: [{ status : "D"}, {"instock.warehouse": "D" }]})

Related Documents

IDS-2023-A3-Final Project.pdf

INFO1435-Test1-pahu9218.docx

INFO1435 Packet Filtering Configuration.docx

kulvir CDEV1830 Career Success_My Mock Interview (1) (002) (1).docx

CS116 Lab 3.docx

Introduction to Systems Thinking.docx

Burnett_Cultural Competence Reflection Assignment.docx

hw12f22-v2.pdf

NP_EX365_2021_EOM1-1_MaiTran_2x.xlsx

M4A3.docx

lab01.py

hw4f22-v2.pdf

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:9780134444321

Author:Tony Gaddis

Publisher:PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:9780132737968

Author:Thomas L. Floyd

Publisher:PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:9780133976892

Author:Paul J. Deitel, Harvey Deitel

Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781337627900

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:9780073373843

Author:Frank D. Petruzella

Publisher:McGraw-Hill Education

SEE MORE TEXTBOOKS

Recommended textbooks for you

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education