MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Rdbms
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page