dbms-all-keys-mcq-question

DBMS - Different Types of Keys MCQ

Q1.

Primary key can be?

[ Technical Assistant NIT JSR 2022]

(A).NULL
(B).NOT NULL
(C).Both NULL and NOT NULL
(D).Depends on situation

Q2.

Which of the following is NOT a superkey in a relational schema with attributes V,W,X,Y,Z and primary key VY?

[ VVIQ]

(A).VWXZ
(B).VXYZ
(C).VWXY
(D).WVXYZ

Q3.Which of the following key contains the minimum number of fields to ensure uniqueness.
[ ]

(A).Primary key
(B).Foreign key
(C).Super key
(D).Candidate key

Q4..................... is a subset of a super key.
[ VVIQ]

(A).Primary key
(B).Foreign key
(C).Super key
(D).Candidate key

Q5.A .......................is a group of single or multiple keys which identifies rows in a table.
[ VVIQ]

(A).Primary key
(B).Super key
(C).Foreign key
(D).Candidate key

Q6.Primary keys must contain
[ VVIQ]

(A).UNIQUE values
(B).NOT NULL values
(C).NULL values
(D).both option A & B

Q7.Key to represent relationship between tables is called
[ SBI Clerk 2010]

(A).Primary key
(B).Foreign key
(C).Secondary key
(D).Candidate key

Q8............is an invalid type of database key.
[ IBPS Clerk 2013]

(A).Primary key
(B).Foreign key
(C).Secondary key
(D).Structured primary key

Q9............is a primary key of one file that also appears in another file.
[ IBPS Clerk 2013]

(A).Primary key
(B).Foreign key
(C).Secondary key
(D).All of the above

Q10.The purpose of the primary key in a database is to
[ IBPS Clerk 2015]

(A).unlock the database
(B).maping of the database
(C).uniquely identify a record
(D).None

1.Database and management System MCQ.
2.Data Communication and Networking MCQ.
3.Operating System MCQ.
4.Data Structure MCQ
5.Digital Electronics MCQ
6.Bank/sbi/ibps MCQ
7.Software Engineering MCQ
8.Compiler Design MCQ

Software Engineering Practice MCQs

1. Software Engineering - COCOMO Model, Flow Process, Matrices, Complexity MCQ
2. Software Engineering - SRS ,Feasibility study,maintenance,design,management MCQ
3. Software Engineering - Testing , Different Types of Testing in Software Engineering MCQ
4. Software Engineering - Software Development Life Cycle (SDLC) MCQ
5. Software Engineering - Software Process Specification MCQ
6. Software Engineering-Fundamental of software engineering

Computer Awarness Practice MCQs

1. Computer troubleshooting hardware, software ,repair and maintenance MCQs
2. Microsoft Office Power point Related MCQ Question
3. Microsoft Office Excel Related MCQ Question
4. Computer Hardware Related All MCQ Question
5. Computer Memory Related All MCQ Question
6. Microsoft Windows Related All MCQ Question
7. Microsoft Office MCQ Question
8. Introduction to Computer

Digital Electronics MCQs

Computer Architecture Practice MCQs

1. Computer Organisation & Architecture - Memory interface & All types of memory MCQs
2. Computer Organisation & Architecture - Input/Output Organization, DMA , Interrupt MCQs
3. Computer Organisation & Architecture - Control unit/CPU Control Design, ALU MCQs
4. Computer Organisation & Architecture - Pipeline and Vector Processing MCQs
5. Computer Organisation & Architecture - Machine Instruction MCQs
6. Computer Organisation & Architecture - Addressing Modes | Different Types of Address Mode MCQs
7. Computer Organisation & Architecture - Data representation | Floating Point | Magnitude | Complements MCQs

DBMS - Different Types of Keys MCQ

Tutorials

DBMS MCQs

Networking MCQs

Data structure MCQs

Computer Architecture MCQs

Compiler Design MCQs

Software Engineering MCQs

Programming MCQs

Operating System MCQs

Digital Electronics MCQs

Web Technology MCQs

Most Important Topics

Engineering Mathematics

Computer Awareness

Ms word

Follow Us :

lerybook.com
91\C B.L SAHA ROAD TOLLYGUNG KOLKATA-700053 (WEST BENGAL)

DBMS - Different Types of Keys MCQ

Tutorials

Most Important Topics

Follow Us :

lerybook.com 91\C B.L SAHA ROAD TOLLYGUNG KOLKATA-700053 (WEST BENGAL)

lerybook.com
91\C B.L SAHA ROAD TOLLYGUNG KOLKATA-700053 (WEST BENGAL)