NAT I Computer Science With Answers

NAT I Computer Science

Sr. # Questions Answers Choice
1 In 3NF which form of dependency is removed? Functional Non-functional Associative Transitive
2 In first normal form Tables are break down Tables are re-joined Tables are maked None of the above
3 Primary key is used To short the data speedy Searching is speeded up Not allows duplicate entities All of the above
4 How many tables are present in a database? 1 10 100 As required
5 A relational database system is a system in which The user views all the data as being stored in the form of tables The operations are operate on tables only The operations are produced as their output data in form of tables All of the above
6 Object-oriented is a Broad category of relation database model Latest research on the relational database model Principles of the relational database model None of the above
7 The degree of a table is the total number of Tuple Attribute Records Fields
8 An attribute corresponds to a Record Cardinality Row Column
9 A relation corresponds to the concept of a Table Data structure Procedure View
10 Database system can be divided into______broad categories 5 4 7 3
11 In hybrid distribution which kind of fragments are stored at only one site? Critical fragments Non-critical fragments Critical and non-critical fragments Only large fragments
12 In ERD model the relationship between two entities is represented by a Diamond symbol Rectangular box Oval symbol Line
13 Database development process involves mapping of conceptual data model into: Object oriented data model Network data model Implementation model Hierarchical data model
14 An entity related to itself in an ERD model refers to Recursive relationship One-to-many relationship Many-to-many relationship One-to-one relationship
15 Which of the following keys does not hold uniqueness property? Candidate key Foreign key Primary key Secondary key
16 From database data is accessed through Queries Function Reports Information
17 DBMS must be able to accept Data definitions Programs Data records Information
18 Which of the following package is used by the application programmer in order to write a program? Low Level Language High Level Language Machine Language Assembly Language
19 Data exists in a data base in the form of Tables Queries reports Files
20 The output of a query is the form of Table Reports Files Forms
Download This Set

Is this page helpful?