CS403 S4 Fall 2010 solved by me please check
R@ïñßøwßrïgh±
CS403 MID FALL 2010
Q1- Which of the following constraints enforces entity integrity?
► Primary Key
► Foreign Key
► Check
► Not Null
Q2- Which of the following statements is correct?
►PK can have NULL
►PK in a relation is a key in some other relation
►PK can be composite
►PK must be selected from the list of secondary keys
Q3- Which one of the following E-R diagrams most correctly represents the relationship between Student and Grade entities?
►
►
►
►
Answer is first one
Q4- Which of the following most certainly implies the need for an entire table to implement?
►A binary relationship
►A ternary relationship
►A recursive relationship
►An identifying relationship
Q5- A database system allows the following EXCEPT
►management and control of data towards an efficient working of an organisation.
►more critical functions in organisations to be computerised and the need to keep a large volume of data available in an up to the minute current state increased.
►any user to access all its data.
►integration of data across multiple applications into a single application.
Q6- Which of the following enforces a relation into 1st normal form?
► The domain of attribute must include only atomic values.
► Every non-key attribute is fully functionally dependent on primary key
► non-key attribute is non-transitively dependent on primary key.
► Every non-key attribute is partially dependent on super key
Q7- Consider the following set of functional dependencies (FDs) on the following relational schema.
Emp_No -> {Ename, Bdate, Address, Dept_No}
Dept_No -> {Dname, Mgr_No}
The additional FD which can be inferred from the above set of FDs is
►Emp_No -> {Dname, Mgr_No}
►Emp_Name -> Dept_No .
►Emp_Name -> Dept_Name .
►Emp_Name, Dept_No -> Mgr_No .
Q8- 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.
Q9- 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.
Q10- 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.
Q11- 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.
Q12- A ____ relationship exists when an association is maintained within a single entity.
►unary
►ternary
►binary
►weak
Q13- 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.
Q14- Identify the correct statement.
► Entity integrity constraints specify that primary key values can be composite.
► Entity integrity constraints are specified on individual relations.
► Entity integrity constraints are specified between weak entities.
► When entity integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.
Q15- A software package designed to store and manage databases
Database
DBMS
Data model
Data
Q16- Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option:
►Database Designer
►Database Administrator
►End User
►Application Programmer
Q17- Consider the following relation R and its sample data. (Consider that these are the only tuples for the given relation)
Which of the following statements is NOT correct?
► The functional dependency (EmpNo, DeptNo) -> ProjNo holds over R.@@@
► The functional dependency EmpNo -> DeptNo holds over R.
► The functional dependency ProjNo -> DeptNo holds over R.
► The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
Q18- Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
Select correct option:
►User accessible catalog
►Data processing
►Recovery service
►Authorization service
Q19- 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 set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.
►To find out those students who work as instructors, it is necessary to perform the operation Student ∩ Instructor.
►To find out the students who are not instructors, it is necessary to perform the operation Student ÷ Instructor.
Q20-
A
candidate key that does not have a null value and is selected to uniquely
identify all other attribute values in any given row is called a __.
Select
correct option:
►superkey
►candidate key
►primary key
►secondary
key
Q21- What is the significance of normalization?
Make the database maintenance easy
Remove redundancies
Remove anomalies
Save storage space
Ensure consistency
More informative to users
Q22- Define Relationship.
Any association, linkage or connection between entities of interest to the business.
Q23- What is the basic function of a DML Compiler?
Answer
DML Compiler translates DML statements in a query language or we say into low-level instruction. That instruction is understandable by Query evaluation engine
Q24- Define primary key and give one example.
Q25- What do you know about Insertion anomaly?
Q26- Define the first normal form.
Banjara
Q1- Which of the following constraints enforces entity integrity?
► Primary Key
► Foreign Key
► Check
► Not Null
--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vu...@googlegroups.com
--
Message Posting Rules: http://groups.google.com/group/vuZs/web/vuzs-basic-rules-for-posting-messages
--
To unsubscribe from this group, send email to vuZs+uns...@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+su...@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at in...@vuzs.net
--
