DBMS
STET/BPSC-4.0/10+2 Computer Teacher
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
32
01
DBMS/RDBMS
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
DBMS
❑ Data Base Architecture
❑ MCQ’s
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
Data Base Architecture
1) Single Tier Architecture
2) Two Tier Architecture
3) Three Tier Architecture
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
1) Single tier Architecture (Local DB System)
Data Base Directly available to the user
Programmers directly communicate with database
1-Tire architecture is used for development local system
Client doesn’t require a network connection to perform action on DB
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
1) Single tier Architecture (Local DB System)
✓ यज़
ू र + एप्लिकेशन + डेटाबेस = सब एक ही कंलयट
ू र/ससस्टम पर होते हैं।
✓ यज़
ू र सीधे डेटाबेस से इंटरै क्ट करता है ।
✓ इसका उपयोग छोटे िेवि पर या सीखने और टे स्ट करने के सिए ककया
जाता है ।
Ex:-
Microsoft Access का उपयोग िोकि कंलयूटर पर करना।
जब आप अपने िैपटॉप पर MySQL/Oracle इंस्टॉि करके
SQL क्वेरी चिाते हैं।
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
2)Two tier Architecture
Data Base system is present at the server machine
Client machine makes a request to access the DB using query language like SQL
The application connection interface such as JDBC,ODBC are used for the
interaction between server and client
ODBC:- Open Database Connectivity is an SQL based API(Application
Programming Interface) developed by Microsoft for windows OS to access
database via SQL
JBDC:- Java Database Connectivity ,it is an SQL based API crated by Sun
Microsystem to enable java application to use SQL for DB access
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
2)Two tier Architecture
✓ Client (Application) और Database Server के बीच सीधा कनेक्शन होता है ।
✓ Client Side (Front-end): जहााँ यज़
ू र काम करता है (जैसे Desktop Application,
SQL Tool)।
✓ Database Server (Back-end): जहााँ DBMS और डेटा स्टोर होता है ।
उदाहरण:
जब आप अपने िैपटॉप से सीधे Oracle/MySQL Server से जड़ ु कर SQL क्वेरी चिाते हैं।
College Library Software जहााँ छात्र का सॉफ्टवेयर सीधे Database Server से जड़
ु ा होता है ।
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
2)Two tier Architecture
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
3)Three tier Architecture
1) External Level (view) :- Client
2) Conceptual Level (Logical):- Server
3) Internal Level(Physical) :- Database
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
External /View level:- Client
✓ This layer is closed to the user
✓ External level only shows the relevant Database content to the user in
the form of view and hides the rest part of data
✓ The users does not need to know the database schema like DS,Table
definition etc
✓ User is only concerned about data which is what returned back .
✓ यह सबसे ऊपरी िेयर है ।
✓ User केवि वही data दे खता है जो उसके काम का है (not full DB)।
✓ हर user का अिग-अिग view हो सकता है । Like :- Bank Customer →
केवि अपना account balance और transactions दे ख सकता है ।
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
Conceptual level/Logical level :- Server
✓ Describes the structure of the whole database
✓ The conceptual level done not care for how the data is the database is
actually stored
✓ Database constrains and security are also implemented in this level of
architecture
✓ Programmer and DBA work at this level .
✓ यह मध्य स्तर (middle layer) है ।
✓ परू े database का logical structure define करता है (tables, relationships,
constraints)।
✓ Security और data abstraction इसी level पर manage होते हैं।
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
Internal level/Physical level :-Database
✓ This level describe how data is actually stored in the database
✓ In this data is stored in the external hard drives in the form of bits or
data is stored in files and folders
✓ This level lowest level of the architecture
✓ Describe complex low level data structure in details
✓ यह सबसे नीचिा स्तर है ।
✓ Data को physical storage (hard disk, SSD) पर कैसे store ककया गया है , यह बताता
है ।
✓ File structure, indexing, hashing, compression, encryption इसी िेयर में आते हैं।
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
1) In 1-tier architecture, all components (application, DBMS, database) are
on?
a) Different servers
b) Same system
c) Cloud
d) None
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
2) In 2-tier architecture, the client communicates with?
a) Another client
b) Application server
c) Database server
d) Storage device
Ans:c)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
3) 3-tier architecture is mainly used in?
a) Small local systems
b) Large distributed applications
c) Single user applications
d) None
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
4) The level of data abstraction which describes how the data is actually
stored?
डेटा अमत
ू त
त ा का वह स्तर जो बताता है कक डेटा वास्तव में ककस प्रकार संग्रहहीत ककया जाता है ?
a) Conceptual level
b) Physical level
c) File level
d) None
e) More than one
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
6) Application resides in client machine & database is at server machine is
called…..?
6) एलिीकेशन क्िाइंट मशीन में रहता है और डेटाबेस सवतर मशीन पर होता है उसे क्या कहते हैं?
a) One Tier Architecture
b) Two Tier Architecture
c) Three Tier Architecture
d) More than one
e) Non of these
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
7) Before the use of the DBMS info was stored in the ?
a) File system
b) Data system
c) Cloud system
d) Record system
e) Non of these
Ans:a)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
8) A database is the complex type of the ?
a) Application
b) Manager
c) Data structure
d) File
e) More than one
Ans:c)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
9) Which of the following in not one of the three schemas used in the ANSI?
a) External
b) Internal
c) Conceptual
d) Implementation
e) Non of these
Ans:d)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
10) In 3-tier model, which layer handles business logic?
a) Presentation layer
b) Application layer
c) Database layer
d) Network layer
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
11) External level in DBMS deals with:
a) Physical storage
b) User view
c) Logical design
d) File structure
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
12) Conceptual level defines:
a) Physical storage
b) Network connection
c) Security of OS
d) Logical structure of the entire database
Ans:d)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
13) Multiple user views can be created at which level?
a) Internal
b) Conceptual
c) External
d) Physical
Ans:c)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
14) Security policies and constraints are mainly defined at:
a) External level
b) Conceptual level
c) Internal level
d) Hardware level
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
15) In a banking system, a clerk sees only customer details.
This is an example of?
a) External level
b) Conceptual level
c) Internal level
d) Physical level
Ans:a)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
16) which oh three schemas used in three-schema model shows physical
storage using a particular product or technique?
तीन-स्कीमा मॉडि में प्रयुक्त कौन सी तीन स्कीमा ककसी ववशेष उत्पाद या तकनीक का उपयोग
करके भौततक भंडारण को दशातती है ?
A) Internal
B) External
C) Conceptual
D) Implementation
E) All of them
Ans:a)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
17) Relational schemas and other metadata about relations are stored in a
structure called the …………….?
17) संबंधपरक स्कीमा और संबंधों के बारे में अन्य मेटाडेटा को एक संरचना में संग्रहहीत ककया जाता
है प्जसे …………. कहा जाता है ?
a) Catalog
b) Log
c) Data Dictionary
d) Data where house
e) All of them
Ans:c)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
18) The view of total database content is ?
a) Conceptual view
b) Internal view
c) External view
d) Physical view
e) More than one
Ans:a)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
19) Architecture of a database can viewed as?
a) 1 level
b) 2 level
c) 4 level
d) 3 level
e) Non of these
Ans:d)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
20) A subschema express?
a) The logical view
b) The external view
c) The physical view
d) More than
e) Non of these
Ans:b)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
21) Which of the following is the advantage of view /
a) Data security
b) Hiding complexity
c) Output focused
d) All of them
e) Non of these
Ans:d)
CONCEPT+ MCQ By:- K K SIR Class:03
DBMS
STET/BPSC-4.0/10+2 Computer Teacher
THANKS
CONCEPT+ MCQ By:- K K SIR Class:03
