Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in DBMS. It will be very useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.
- _________ is a collection of conceptual tools for describing data, data relationships, data semantics etc.,
A. Front End
B. Database Administrator
C. Data Models
D. None of the Above
Answer
C. Data Models - In E-R diagram, attributes are represented by ________
A. ellipse
B. rectangle
C. diamond
D. None of the Above
Answer
A. ellipse - Key to represent relationship between tables is called _________
A. Primary key
B. Secondary Key
C. Foreign Key
D. None of the Above
Answer
C. Foreign Key - A logical schema ___________
A. is the entire database
B. is a standard way of organizing information into accessible part
C. describes how data is actually stored on disk
D. None of the Above
Answer
B. is a standard way of organizing information into accessible part - In the relational modes, cardinality is termed as __________
A. number of tuples
B. number of tables
C. number of constraints
D. None of the Above
Answer
A. number of tuples - An entity set that does not have sufficient attributes to form a primary key is a __________
A. strong entity set
B. weak entity set
C. simple entity set
D. None of the Above
Answer
B. weak entity set - __________ is a primary key of one file that also appears in another file.
A. Physical Key
B. Primary Key
C. Foreign Key
D. Logical Key
Answer
C. Foreign Key - ______________ is an invalid type of database key.
A. Structured primary key
B. Atomic primary key
C. Primary key
D. Composite primary key
Answer
A. Structured primary key - __________ is a diagrammatically representation of entities and relationship between them.
A. E-R Diagram
B. Chart
C. Model
D. None of the Above
Answer
A. E-R Diagram - In E-R diagram, relationship type is represented by ________
A. ellipse
B. rectangle
C. diamond
D. None of the Above
Answer
C. diamond
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
