





Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
SER322 Final 2025. Questions & Correct Verified Answers. Graded A
Typology: Exams
1 / 9
This page cannot be seen from the preview
Don't miss anything!
_____ 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">
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?