Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

SER322 Final 2025. Questions & Correct Verified Answers. Graded A, Exams of Sales Management

SER322 Final 2025. Questions & Correct Verified Answers. Graded A

Typology: Exams

2024/2025

Available from 07/05/2025

zaza-maica
zaza-maica 🇬🇧

2.2

(5)

3.3K documents

1 / 9

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1
SER322 Final 2025. Questions & Correct
Verified Answers. Graded A
_____ constraint dictates that the foreign key must contain values that
match the primary key in the related table, or must contain null. – ANS
Referential Integrity
_____ is a attribute (or a set of attributes) in a database relation that has a
unique value. – ANS Super Key
__________ states that only valid data will be written to the database. –
ANS Consistency
A transaction is delimited by statements (or function calls) of the form
__________. – ANS Begin transaction and End transaction
All functional dependencies must _________. – ANS have attributes of the
same table
Assume that a relation R has the following properties. What is the normal
form of R?
Has no multi-valued attributes
Has no partial key dependencies
Has attributes with atomic domains
Has transitive dependencies - ANS1NF & 2NF
pf3
pf4
pf5
pf8
pf9

Partial preview of the text

Download SER322 Final 2025. Questions & Correct Verified Answers. Graded A and more Exams Sales Management in PDF only on Docsity!

SER322 Final 2025. Questions & Correct

Verified Answers. Graded A

_____ constraint dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. – ANS Referential Integrity _____ is a attribute (or a set of attributes) in a database relation that has a unique value. – ANS Super Key __________ states that only valid data will be written to the database. – ANS Consistency A transaction is delimited by statements (or function calls) of the form __________. – ANS Begin transaction and End transaction All functional dependencies must _________. – ANS have attributes of the same table Assume that a relation R has the following properties. What is the normal form of R? Has no multi-valued attributes Has no partial key dependencies Has attributes with atomic domains Has transitive dependencies - ANS1NF & 2NF

Assume that a relation R has the following properties. What is the normal form of R? No multi-valued attributes No partial key dependencies - ANSSecond Normal Form Composite attribute in ER model is represented in relational model as ________________. - ANSOne column for each component attribute and NO column for the composite attribute Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (TripID, SSN, From_City, To_City, Departure_Date, Return_Date) EXPENSE (TripID, Account#, Amount) Identify the foreign keys for this schema. - ANSTripID in EXPENSE relation references TRIP relation; SSN in TRIP relation references SALESPERSON relation Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, Start_Year, Dept_No) TRIP (TripID, SSN, From_City, To_City, Departure_Date, Return_Date) EXPENSE (TripID, Account#, Amount) Which one of the following is a valid super key for TRIP relation? - ANSTripID, SSN, Return_Date

primary key of the superclass table is used as the primary key of the new table. -a table is created for each subclass entity set with a -column for each of the attributes of that entity set plus one for each attribute of the primary key of the superclass entity set -a table is created for each superclass entity set according to the normal entity set translation method. How do you change the marks of all students in Students table with marks 65 to 70 with SQL. - ANSUPDATE Students SET Marks=70 WHERE Marks = 65; In JDBC, it is a good practice to use standard SQL statement and avoid using db specific query until necessary. - ANStrue In relational model terminology, table is considered as - ANSrelation In the __________ normal form, a composite attribute is converted to individual attributes. - ANSFirst Match the resource type with the best description - ANSRepresents the socket between client and server Connection Represents a query to the database Statement Corresponds to a cursor in the database server ResultSet

Represents a pre-compiled and/or parameterized query Prepared Statement On the XML below, which XPath expression will return all of the values of title attributes? <slideshowtitle="Sample Slide Show"date="Date of publication"author="Yours Truly">Wake up to WonderWidgets!OverviewWhy WonderWidgets are greatWho buys WonderWidgets - ANS//@title Query Processing involves which of the following steps: - ANSScanning query tokens Parsing to check query syntax Validation check of all attribute and relation names Creation of a query graph Devise a Query execution strategy Suppose R(A, B) has the following tuples: A B 3 3 6 5 2 3 and relation S(B, C) has the following tuples: B C 1 6

The following keyword selects records that have matching values in both tables. - ANSINNER JOIN The goals for mapping a (E)ER model to Relational model are: - ANSPreserve all information Minimize null values Maintain constraints to extent possible The type of XML Parsing that is parses an XML document based on expression and is used extensively in conjunction with XSLT. - ANSXPath Parsing Well formed XML document means - ANSmust contain one or more elements and root element must contain all other elements What is the purpose of select operation in Relational Algebra? - ANSSelects all tuples that satisfy the selection condition from a relation R. When XML is used as a DDL, we want to ensure the XML conforms to this so structural constraints may be specified: - ANSDTD or XML Schema Which is a bottom-up approach to database design that decomposes unsatisfactory relations by breaking up their attributes into smaller relations? - ANSNormalization Which of the following are not benefits of XML over traditional relational data modelling? - ANSSupport for Large Objects (LOBs)

Which of the following has "all-or-none" property in Transaction processing? - ANSAtomicity Which of the following operation(s) require that relations on which they are applied be union-compatible? - ANSUNION INTERSECTION DIFFERENCE Which of the following provides the application-to-JDBC Manager connection. - ANSJDBC API Which one of the following is always a single-valued attribute? - ANSa person's age Which SQL keyword is used to group rows with same values. - ANSGROUP BY Which SQL keyword is used to sort the result-set in descending order using the NAME column? - ANSORDER BY NAME DESC Which statement about JDBC is true? - ANSJDBC stands for Java Database Connectivity Which type of driver provides JDBC access via one or more ODBC drivers?

  • ANSType 1 driver