JOIN ADRE 2.0 Telegram Group

Relational Database Management System MCQs with Answers | DBMS Objective Questions and Answers

Questions
16 A super key is a set of one or more attributes that, taken collectively, allow us
A to identify uniquely an entity in the entity set
B to make the key most powerful for faster retrieval
C to increase effectiveness of database access
D none of the above

Answer: Option [A]
17 What is the degree of a table with 1000 rows and 10 column ?
A 10
B 100
C 1000
D None of the above

Answer: Option [A]
Advertisement
APSC CCE PRELIMS Mock Test - 1 Start Test
APSC CCE PRELIMS Mock Test - 2 Start Test

DOWNLOAD CURRENT AFFAIRS PDF FROM APP

18 Which of the following commands is used to get all the columns in a table ?
A #
B *
C %
D @

Answer: Option [B]
19 One of the following is a valid record-based data models :
A Object-oriented model
B Relational model
C Entity-relationship model
D None of the above

Answer: Option [B]
20 Consider the relation scheme R(A, B, C, D) where A is candidate key. With no information about FDs involved, then R is in which normal form ?
A First Normal Form
B Second Normal Form
C BCNF
D Third Normal Form

Answer: Option [D]

APSC PRELIMS FULL LENGTH MOCK TEST

Take Mock Tests

Government Schemes Mock Test Start Test!
Political Science Mock Test – 42 Start Test
History Test – 190 Start Test
Quantitative Aptitude Test Start Test!
Trigonometry - Mock Test Start Test!
Data Interpretation - Mock Test Start Test!
General Awareness - Mock Test Start Test!
Reasoning Ability - Mock Test Start Test!
Englist(Antonyms) Mock Test 1 Start Test!
Quantitative Aptitude (Percentage) Mock Test Start Test!
Economy Mock Test 1 Unlock Test!
Books & Authors - Test 2 Unlock Test!

Chapters

apsc cce prelims 2024 test series