Q.1
In an ER diagram, Entity types are represented by
  • rectangle
  • ellipse
  • diamond box
  • circle
Q.2
In an ER diagram, attributes are represented by?
  • Rectangle
  • Square
  • Ellipse
  • Triangle
Q.3
In Hierarchical Model records are organized as
  • Graph
  • List
  • Links
  • Tree
Q.4
............ are the properties of entities.
  • Domain
  • Attributes
  • Relations
  • Field
Q.5
Which of the following is not a valid operator for the WHERE Clause
  • IN BETWEEN
  • <>
  • >=
Q.6
Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
  • DML(Data Manipulation Language)
  • Query
  • Relational Schema
  • DDL(Data Definition Language)
Q.7
A table is a collection of relationships, there is a close correspondence between concept of
  • Tables and instances
  • Table and variables
  • Tables and relations
  • Tables and Entries
Q.8
The union of primary keys of the related entity sets becomes a -------------------------- of the relation ?
  • Super Key
  • Candidate key
  • Foreign key
  • Primary key
Q.9
Address field of a person should not be part of primary key, since it is likely to ?
  • Dependent
  • Too long
  • Changed
  • Not changed
Q.10
Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
  • a. DML(Data Manipulation Language)
  • b. DDL(Data Definition Language)
  • c. Query
  • d. Relational Schema
Q.11
A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
  • a) Referential
  • b) Referencing
  • c) Specific
  • d) Primary
Q.12
In Hierarchical model records are organised as
  • Graph
  • Stack
  • Queue
  • Tree
Q.13
.......... is an attribute or collection of attributes that uniquely identifies an entity among entity set.
  • Weak entity
  • Key
  • Relations
  • Attribute
Q.14
Which statement is used to extract data from a database?
  • Extract
  • Get
  • Open
  • Select
Q.15
In a relational Database a referential integrity constraint cab be specified with the help of
  • Primary Key
  • Secondary key
  • Foreign key
  • None of these
Q.16
In the relational model, cardinality is termed as
  • A number of tuples.
  • A number of attributes.
  • A number of tables.
  • number of constraints.
Q.17
In relational model, the row of table is known to be ?
  • Relation
  • Entity field
  • Tuple
  • Attribute
Q.18
The level of data abstraction which describes how the data is actually stored is
  • Conceptual level
  • Physical level
  • File level
  • None of these
Q.19
What will be the degree and cardinality of the cartesian product of two tables if the degree of first table is 3 and second table isThe cardinality of first table isand cardinality of second table is 6.
  • Degree 15, Cardinality 16
  • Degree 8 Cardinality 16
  • Degree 8 Cardinality 60
  • Degree 15 cardinality 60
Q.20
In the architecture of the Database System, external level is the
  • Physical level
  • Logical level
  • Conceptual level
  • View level
0 h : 0 m : 1 s