Important Computer Awareness Quizzes (Topic Wise) for IBPS Exams 2017 Day-2:
Dear Readers, Here we have provided the Important Computer Awareness Quizzes based on particular topic, which will help to understand and prepare in a better way. Candidates those who are preparing for upcoming IBPS Exams 2017 can make use of it. Kindly share this to all your friends and recommend them to follow our site regularly.
1). A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as:
2). Dr.E.F. Codd represented ……. rules that a database must obey if it has to be considered truly relational.
3). In E-R Diagram, weak entity is represented by:
3).
Answer: C
4). Rows of a relation are called ________
5). The number of tuples in a relation is termed as ______
6). In SQL, Which of the following is a Data Manipulation Language (DML) command?
7). The language used in application programs to request data from the DBMS is referred to as the ______
8). In Oracle, who owns the data dictionary?
9). In SQL, which command is used to update existing row in a table?
10). A top to bottom relationship among the items in a database is established by a ______
11). Aggregation is a special form of _______
12). Which command is used to remove a relation from an SQL database?
13). Which of the following is not a type of database?
14). In a relational database, each tuple is divided into fields called_______
15). In …….. database, data is organized in the form of trees with nodes.
15).
Answer: A
1). A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as:
1).
Answer: A
Answer: A
2). Dr.E.F. Codd represented ……. rules that a database must obey if it has to be considered truly relational.
2). Dr E.F.Codd, also known to the world as the ‘Father of Database Management Systems’ had propounded 12 rules which are in-fact 13 in number. The rules are numbered from zero to twelve.
Answer: D
Answer: D
3). In E-R Diagram, weak entity is represented by:
3).
Answer: C
4). Rows of a relation are called ________
4).
Answer: C
Answer: C
5). The number of tuples in a relation is termed as ______
5).
Answer: A
Answer: A
6). In SQL, Which of the following is a Data Manipulation Language (DML) command?
6). Merge, select, update, insert, call, delete are DML commands.
Answer: C
Answer: C
7). The language used in application programs to request data from the DBMS is referred to as the ______
7). DML is a language which is used in application programs to request data from the dbms.
Answer: A
Answer: A
8). In Oracle, who owns the data dictionary?
8). SYS owns oracle dictionary and stored in principle place SYSTEM table place.
Answer: B
Answer: B
9). In SQL, which command is used to update existing row in a table?
9).
Answer: C
Answer: C
10). A top to bottom relationship among the items in a database is established by a ______
10). Hierarchical schema has a tree like structure where parent have multiple child but children should not have multiple parents so in simple way we can say that it follows top-down approach.
Answer: C
Answer: C
11). Aggregation is a special form of _______
11). Association talks about relationship between object in general. Aggregation is a special form of association and composition is also a special form of association.
Answer: B
Answer: B
12). Which command is used to remove a relation from an SQL database?
12).
Answer: C
Answer: C
13). Which of the following is not a type of database?
13). Hierarchical , Relational , Network , and Object oriented are the four types of database.
Answer: D
Answer: D
14). In a relational database, each tuple is divided into fields called_______
14). Tuples divided in to fields is called domains and where are tables in relational dbms is called Relations.
Answer: B
Answer: B
15). In …….. database, data is organized in the form of trees with nodes.
15).
Answer: A
Important Computer Questions Based on DBMS (Set-2)
No comments:
Post a Comment