Google+ COMPUTER TRICKS, TWEAKS AND TUTORIALS: CS403 – MF-2010

CS403 – MF-2010


CS403 – MF-2010

Consider the following statements.
A. Conceptual schema which is the result of conceptual design is a logical description of all data elements and their relationships.
B. Internal level of the database architecture consists of the physical view of the database.
C. External level of the database architecture provides the user view of the database.
With respect to the ANSI/SPARC three level database architecture, which of the above is/are
correct?
  • Only A.
  • Only C.
  • Only A and B.
  • Only B and C.

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
  • User accessible catalog
  • Data processing
  • Authorization service
  • Recovery service

Which of the following is true regarding relations?
·         Every attribute value is non-atomic.
·         Attributes in tables may not have unique names
·         The order of the columns is relevant.
·         The order of the rows is irrelevant.

Which one of the following E-R diagrams most correctly represents the relationship between Student and Grade entities?
Which of the following operation is NOT one of the parts of the five basic set operations in relational algebra?
  • Union
  • Division
  • Cartesian Product
  • Set Difference

Which of the following constraints enforces referential integrity?
  • FOREIGN KEY
  • CHECK
  • PRIMARY KEY
  • UNIQUE

In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
  • 1:1
  • 1:M
  • M:M
  • Ternary

Which levels are mostly used for Detailed DFD?
  • Level-0, Level-1
  • Level-1, Level-2
  • Level-2, Level-3
  • Level-3, Level-4

Select the correct statement about the ANSI/SPARC architecture.
  • The conceptual level is a level of indication between the internal level and the external level.
  • The internal level in a database system will definitely be relational.
  • Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.
  • The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.

Which of the following is a feature of PRIMARY KEY constraint?
  • unique identifier for a row within a database table.
  • allow any actions that would destroy links between tables
  • limit the values that can be placed in a column.
  • enforces that the column will only accept null values.

Structural constraints of a relationship type refer to
  • identifying the owner entity type relevant to a given entity type
  • whether the existence of an entity depends on it being related to another entity via the relationship type.
  • the role that a participating entity from the entity type plays in each relationship instance.
  • the constraints applicable in granting access to tables, columns and views in a database schema.

Which of the following is true about relational schema?
  • The sequence of columns is significant
  • The sequence of rows is significant.
  • Contains only derived attributes.
  • Values are atomic.

Which of the following is a correct way to implement many-to-many relationship while designing tables?
  • using a junction table with the keys from both the tables
  • forming the composite primary key of the junction table.
  • by splitting the data into two tables with primary key and foreign key relationships as a single table and rarely as two tables with primary and foreign key relationships.
  • by creating three tables and linking them through PK and FK.

Which of the following is a correct way to implement one-to-many relationship while designing tables?
  • by splitting the data into two tables with primary key and
  • foreign key relationships.
  • using a junction table with the keys from both the tables forming the composite primary key of the junction table.
  • by splitting each table into three as a single table and rarely as two tables with primary and foreign key relationships.

Identify the factor which enforces a relation in 3NF?
  • Every non-key attribute is fully functionally dependent on primary key
  • Every non-key attribute is partially dependent on super key
  • The domain of attribute must include only atomic values.
  • Every non-key attribute is non-transitively dependent on primary key.
Consider the given relations Student and Instructor as given below. Please note that
Fname and Lname also denote the First Name and Last Name respectively.


Which of the following statements is correct with respect to the two relations given above?
  • The two relations are not union-compatible since their attribute names differ.
  • The two relations are union-compatible since they have the same type of tuples.
  • The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.

  • To find out the students who are not instructors, it is necessary to perform the operation Student ÷ Instructor.
A collection of concepts that can be used to describe the structure of a database
  • Database
  • DBMS
  • Data model
  • Data

An entity type is
  • defined when the database is actually constructed
  • a specific type such as an integer, text, date, logical etc
  • a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
  • defined by the database designer

Database management systems, operating systems, applications and utilities are all examples of ____.
  • hardware      
  • software
  • computer infrastructure
  • input and output

Consider the following statements.
A. An entity integrity constraint states that no primary key value can be null.
B. A referential integrity constraint is specified between two relations.
C. A foreign key cannot be used to refer to its own relation.
Identify which of the above statements is/are correct.
  • Only A
  • Only B
  • B and C
  • A and B

What is the importance of determining minimum cardinality in a relationship while designing database?2
Name the two types of unary operations on relational algebra.          2
Name the three kinds of anomalies which may exist in a relation which is not in 2nd normal form.       3
How to implement one-to-one relationship while designing tables?                                                         3
What are the benefits of associating default values to the specific attributes?                                                          5
Differentiate Total and Partial Completeness Constraints.                                                                              5
at