Saturday, 12 December 2015

IBPS IT Officer Exam : Data Base Management System Concepts important expected MCQs Quiz 80

The IBPS Specialist Officer (SO) Exam 2016 for recruitment of specialist officer vacancies in public sector banks has been announced. So we are continue providing you a most important Questions and answers for this exam. Team is here with IBPS SO Material Data Base Management System Concepts important expected MCQs Quiz.

Q.1 In the relational modes, cardinality is termed as:
(A) Number of tuples.
(B) Number of attributes.
(C) Number of tables.
(D) Number of constraints.


Q.2 Relational calculus is a
(A) Procedural language.
(B) Non- Procedural language.
(C) Data definition language.
(D) High level language.

Q.3 The view of total database content is
(A) Conceptual view.
(B) Internal view.
(C) External view.
(D) Physical View.

Q.4 Cartesian product in relational algebra is
(A) A Unary operator.
(B) A Binary operator.
(C) A Ternary operator.
(D) Not defined.

Q.5 DML is provided for
(A) Description of logical structure of database.
(B) Addition of new structures in the database system.
(C) Manipulation & processing of database.
(D) Definition of physical structure of database system.

Q.6 ‘AS’ clause is used in SQL for
(A) Selection operation.
(B) Rename operation.
(C) Join operation.
(D) Projection operation.

Q.7 ODBC stands for
(A) Object Database Connectivity.
(B) Oral Database Connectivity.
(C) Oracle Database Connectivity.
(D) Open Database Connectivity.

Q.8 Architecture of the database can be viewed as
(A) Two levels.
(B) Four levels.
(C) Three levels.
(D) One level.

Q.9 In a relational model, relations are termed as
(A) Tuples.
(B) Attributes
(C) Tables.
(D) Rows.

Q.10 The database schema is written in
(A) HLL
(B) DML
(C) DDL
(D) DCL

Read more Computer Awareness and Knowledge Questions and Answers for IBPS Bank PO/SO clerk as well as SBI PO/Clerk, SSC Exam and All RBI Grade 'B' and Office Assistant Exam. These MCQs are very important for Informatics Assistant Recruitment - 2016 Exam.

No comments:

Post a Comment

Advertisement