DBMS IBPS SO IT MCQ QUESTIONS
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.
DBMS IBPS SO IT MCQ QUESTIONS 1
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.
Ans: B Cartesian product in relational algebra is a binary operator.
(It requires two operands. e.g., P X Q)
Q.5 DML is provided for
(A) Description of logical structure of database.
(B) Addition of latest structures within the info system.
(C) Manipulation & processing of database.
(D) Definition of physical structure of database system
language commands as its name)
DBMS IBPS SO IT MCQ QUESTIONS 2
Q.6 ‘AS’ clause is used in SQL for
(A) Selection operation. (B) Rename operation.
(C) Join operation. (D) Projection operation.
Ans: B ‘AS’ clause is used in SQL for rename operation.
(e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)
Q.7 ODBC stands for
(A) Object Database Connectivity.
(B) Oral Database Connectivity.
(C) Oracle Database Connectivity.
(D) Open Database Connectivity.
(A) two levels. (B) four levels.
(C) three levels. (D) one level.
(A) Tuples. (B) Attributes
(C) Tables. (D) Rows.
DBMS IBPS SO IT MCQ QUESTIONS 3
Q.10 The database schema is written in
(A) HLL (B) DML
(C) DDL (D) DCL
(A) physical level. (B) logical level.
(C) conceptual level (D) view level.
(A) strong entity set. (B) weak entity set.
(C) simple entity set. (D) primary entity set.
DBMS IBPS SO IT MCQ QUESTIONS 4
(A) Graph. (B) List.
(C) Links. (D) Tree.
(A) rectangle. (B) square.
(C) ellipse. (D) triangle.
DBMS IBPS SO IT MCQ QUESTIONS 5
Q.15 just in case of entity integrity, the first key could also be
(A) not Null (B) Null
(C) both Null & not Null. (D) any value.
(A) ¬P1 Ú P2 (B) P1 Ú P2
(C) P1 Ù P2 (D) P1 Ù¬P2
to as the
(A) DML (B) DDL
(C) VDL (D) SDL
Q.18 A logical schema
(A) is the entire database.
(B) may be a commonplace approach of organizing info into accessible elements.
(C) describes however information is really hold on on disk.
(D) both (A) and (C)
(A) data file. (B) data record.
(C) menu. (D) bank.
(A record is a collection of related fields)
(A) users. (B) separate files.
(C) database. (D) database administrator.