1
Which normal form is considered adequate for database design?
A
3NF
B
2NF
C
1NF
D
4NF
Explanation
Generally, 3NF (Third Normal Form) is considered sufficient and desirable for most database designs.
Advance Computer Science
Database Management System
20
MEDIUM
2
MPPSC State Forest Service Examination 2014A weak entity set is a
A
Entity set whose existence depends on another weak entity set
B
Entity set whose existence depends on another strong entity set
C
Entity set whose existence dependency does not matter
D
None of these
Explanation
A weak entity set is one that depends on another 'strong' or 'owner' entity set for its existence.
3
TRB Poly. Lect. 2017ALL or NONE refers:
A
Consistency
B
Isolation
C
Durability
D
Atomicity
Explanation
The principle of Atomicity states that a transaction occurs on an 'all-or-none' basis; if any part of the transaction fails, the entire transaction fails.
4
ISRO Scientist/Engineer 2007A view of a database that appears to an application program is known as
A
Schema
B
Subschema
C
Virtual table
D
None of these
Explanation
A subschema is the part of the database that is visible to a particular application or user.
5
Which of the following function in SQL is used to return the smallest value of the selected column?
A
MAX()
B
MIN()
C
COUNT()
D
AVG()
Explanation
The MIN() function is used to find the smallest value from a column.
Sign up free to save progress
No credit card required
6
A data can be stored in the format of-
A
Table
B
Schema
C
Views and reports
D
All of the above
Explanation
Data in a database is organized and presented through tables, schemas, and reports/views.
7
CGPSC Asstt. Prof. 2014 (IT)An entity set which may not have sufficient attributes to form a primary key is termed as:
A
Relationship set
B
Strong entity set
C
Redundant set
D
Trivial entity set
Explanation
A weak entity set is one that does not have sufficient attributes to form a primary key and depends on another entity (Owner Entity) for its existence.
8
RPSC VPIITI 2012 (CS)Which of the join operations do not preserve non matched tuples :-
A
Left outer join
B
Right outer join
C
Inner join
D
Natural join
Explanation
Inner join returns only those rows that match in both tables; it discards non-matching rows.
9
Punjab State Civil Supplies Corp. Ltd. 13.11.2011A virtual relation composed of columns from one or more related relations is called a/an:
A
Index
B
View
C
Relational map
D
Base table
Explanation
A View is a virtual table derived from the data of one or more tables (relations).
10
Which of the following is correct full form of RDBMS?
A
Relational database management system
B
Relative database management system
C
Rotational database manageable service
D
Regional database management system
Explanation
RDBMS stands for 'Relational Database Management System'.
Full Mock Tests
Take Full-Length Mock Tests
Test your complete preparation with timed mock tests. Get detailed analytics and compare scores with other aspirants.
Explore Test Series
11
TNPSC 2016 (Degree) P-IIOLAP stands for:
A
Online Analysis and processing
B
Online Analytical Processing
C
One time Analysis and Processing
D
One time Analytical Processing
Explanation
OLAP stands for 'Online Analytical Processing'.
12
APPSC Lect. Degree College 07.06.2017 (CS)A primary key for an entity is
A
A candidate key
B
Any attribute
C
A unique attribute
D
A super key
Explanation
A primary key is a specific candidate key chosen from among all candidate keys that can uniquely identify an entity.
13
Which of the following is not a Unified Modeling Language (UML) diagram?
A
Class diagram
B
Deployment diagram
C
Sequence diagram
D
Star diagram
Explanation
Examples of UML diagrams include Class diagrams, Deployment diagrams, Sequence diagrams, State diagrams, etc. 'Star diagram' is related to data warehousing (star schema), not standard UML diagrams.
14
RPSC VPITI 2014 (IT)In the daily running of the business which of the following information systems are used?
A
Operational planning systems
B
Transaction Processing systems (TPS)
C
Process control system
D
Office automation system (OAS)
Explanation
Transaction Processing Systems (TPS) are used to record and manage daily business transactions (such as sales, inventory, payroll).
15
Database normalization was developed by-
A
Charles Bachman
B
Francis Bacon
C
E.F. codd
D
William Drebbel
Explanation
The concept of Database Normalization was introduced by E.F. Codd as part of his relational model.
16
TNPSC 2016 (Degree) P-IISelection operations are ......... and natural join operations are ......... .
A
Commutative, Associative
B
Associative, commutative
C
Associative, associative
D
Commutative, commutative
Explanation
Selection operations are commutative, and natural join operations are associative.
17
TNPSC 2016 (Degree) P-IIThe changes made by one transaction are not visible to others till the commit point, this property is called:
A
Automicity
B
Consistency
C
Isolation
D
Durability
Explanation
According to ACID properties, 'Isolation' ensures that concurrent transactions do not interfere with each other and that changes made by one transaction remain invisible to others until committed.
18
Which one of the following does prevent action that ends links between the tables?
A
foreign Key
B
primary Key
C
check constraint
D
default
Explanation
Foreign Key is used to maintain referential integrity between two tables, preventing actions that would break the links.
19
Which clause in SQL is used to filter records and extract only those records that fill a specified condition?
A
SELECT
B
WHERE
C
UNIQUE
D
NULL
Explanation
The WHERE clause is used to filter the result-set in SQL statements.
20
Which command does allow users to insert data in database tables?
A
Update
B
Insert
C
Put data
D
Delete
Explanation
The INSERT command is used to add new rows (data) into a database table.
Free Forever
Track Your Progress
Sign up for free to save your progress, access unlimited questions, and get personalized recommendations.
You're Doing Great! 🎯
Sign up free to unlock unlimited questions, save your progress, and access all Database Management System questions.
Unlimited PYQs Progress Tracking Mock Tests
✨ Free forever • No credit card • 2 sec signup with Google
All Chapters
Advance Computer Science
1234567891011121314151617Current1819202122
Fundamentals of Computer
513+ questions
Word Processing (MS Word)
457+ questions
Spreadsheet Software (MS Excel)
147+ questions
Presentation Software (MS PowerPoint)
162+ questions
DBMS Software (MS Access)
224+ questions
C and C++ Programming
128+ questions
Java
89+ questions
.NET and C#
61+ questions
Artificial Intelligence and Machine Learning
175+ questions
Python Programming
92+ questions
Blockchain Technology
83+ questions
Principles of Programming and OOPs
630+ questions
Data Structures and Algorithms
288+ questions
Computer Organization and Operating System
302+ questions
Communication and Network Concepts
627+ questions
Network Security
97+ questions
Database Management System
223+ questions
System Analysis and Design
226+ questions
Internet of Things and its Application
318+ questions
Major Developments in IT
103+ questions
Pedagogy of Computer Science
119+ questions
Digital Logic Systems
268+ questions