TRB-CS-VIP ONLINE COACHING CENTER ( TEST-2) *RDBMS Fundamentals*

TRB-CS-VIP ONLINE COACHING CENTER ( TEST-1) *RDBMS Fundamentals*

TRB-CS-VIP ONLINE COACHING CENTER ( TEST-2) *RDBMS Fundamentals*

Quiz

 

1. A Network Schema
   1.   permits many to many relationship
   2.   stores Data in a Relation
   3.   stores Data in a Database
   4.   restricts to one to many relationship
2. The relation “divides” on a set of positive integers is ________.
   1.   Transitive only
   2.   Symmetric only
   3.   Symmetric and transitive
   4.   Anti symmetric and transitive
3. The “PROJECT” operator of a relational algebra creates a new table that has always
   1.   More rows than original table
   2.   Same number of columns as the original table
   3.   Same number of rows as the original table
   4.   More columns than columns in original table
4. Employee (name, sex, salary, deptname) Consider the following SQL query Select deptname from Employee Where sex = ‘M’ group by deptname having avg (salary) > {select avg (salary) from Employee} Output
   1.   Average salary of employee more than average salary of the organization.
   2.   Average salary of male employees in a department is more than average salary of the organization
   3.   Average salary of employee equal to average salary of the organization
   4.   Average salary less than average salary of the organization.
5. For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation
   1.   In 2NF not in 3NF
   2.   In 1NF not in 2NF
   3.   In 1NF
   4.   In 3NF
6. Match : a.Foreign keys i.Domain constraint b.Private key ii.Referential integrity c.Event control action model iii.Encryption d.Data security iv. Trigger
   1.   a b c d iii iv i ii
   2.   a b c d ii i iv iii
   3.   a b c d i ii iii iv
   4.   a b c d iii ii i iv
7. SQL command to delete a column from an existing table:
   1.   Drop table
   2.   Delete table
   3.   Delete column
   4.   Alter table
8. With QBE, inserting records from one or more source tables into a single target table can be achieved by:
   1.   Insert action query
   2.   Make table action query
   3.   Append action query
   4.   Update action query
9. Tuple in relational algebra refers to:
   1.   Column
   2.   Row
   3.   Relation
   4.   Table
10. An attribute or set of attributes within one relation that matches the candidate key of some(possibly the same) relation:
    1.   Primary key
    2.   Super Key
    3.   Foreign key
    4.   Candidate key
11. A subset of data in a data warehouse in the form of summary data, related to a particular department or business function:
    1.   Archive data
    2.   Data Marts
    3.   . Meta Data
    4.   Operational Data Store
12. The normalization of 1NF relations to 2NF involves:
    1.   Removal of transitive dependencies
    2.   Removal of multi-valued dependencies
    3.   Removal of full dependencies
    4.   Removal of partial dependencies
13. Why do we go for Normalization of Data Bases?
    1.   To prevent replication
    2.   To avoid the repetitions
    3.   To prevent fragmentation
    4.   Avoid redundancy
14. If a relation is in BCNF then it is in:
    1.   1 NF
    2.   2 NF
    3.   3 NF
    4.   1 NF and 2 NF
15. A file is:
    1.   volatile
    2.   usually non volatile
    3.   logical storage unit
    4.   an abstract data type
16. What property of the files prevents sharing of files and directories?
    1.   One level structure
    2.   Two level structure
    3.   Length
    4.   Tree structure
17. E-R modeling technique is:
    1.   Top-down method
    2.   Bottom-up method
    3.   Right-left approach
    4.   Tree structure
18. Data items stored as grouped items is:
    1.   Title list
    2.   Strings
    3.   Record
    4.   List
19. Data items are fragmented, replicated and propagated in:
    1.   DML
    2.   DBMS
    3.   RDBMS
    4.   DDBMS
20. If every non-key attribute is functionally dependent on the primary key, then the relation will be in
    1.   1NF
    2.   2NF
    3.   3NF
    4.   4NF
21. Which of the following is record based logical model(s)?
    1.   Relational Model
    2.   Network Model
    3.   Both (a) and (b)
    4.   Entity Relationship Model and Object-oriented model
22. In an E-R diagram ellipses represents
    1.   attributes
    2.   Entity sets
    3.   link in attributes & entity sets
    4.   relationship among entity sets
23. The set of permitted values for each attribute is called its
    1.   group
    2.   domain
    3.   attribute set
    4.   attribute range
24. Relations produced from an E-R model will always be in
    1.   1NF
    2.   2NF
    3.   3NF
    4.   4NF
25. E-R modeling technique is a
    1.   Top-down approach
    2.   Bottom-up approach
    3.   Left-right approach
    4.   none of above