Computer Knowledge
Database Management Systems
5,344 Questions
Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.
E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database
Database Management Systems Questions
-
It is an abstract way of describing a database.
-
It uses a three schema approach to software engineering.
-
Conceptual data model is the lowest level ER model.
-
An entity is an abstraction from the complexities of a domain.
-
Entities and relationships can both have attributes.
C
Correct answer
Explanation
This is the highest level ER model in that it contains the least granular detail but establishes the overall scope of what is to be included within the model set. The conceptual ER model normally defines master reference data entities that are commonly used by the organization.
-
Second-order logic
-
Higher-order logic
-
Categorical logic
-
First-order predicate logic
-
Combinational logic
D
Correct answer
Explanation
The relational model for database management is a database model based on first-order predicate logic.
-
Business Layer
-
View Layer
-
Access Layer
-
Design View
-
Process View
C
Correct answer
Explanation
It contains objects that know how to communicate with the place where the data actually reside.
-
File control
-
Output reconciliation control
-
Input validation control
-
Transport level encryption
-
Virtual machine technology
A
Correct answer
Explanation
This security technique applied on the database is used to make certain that data is operated accurately in structured files.
-
Corporate level SLA
-
Sify my storage
-
Wuala
-
Mango DB v.1.8.0
-
CouchDB
D
Correct answer
Explanation
This database is high performance document-centric database released by 10 Gen.
-
ODBC
-
JDBC driver manager
-
JDBC
-
None of these
C
Correct answer
Explanation
This tool provides a database-programming interface for Java programs.
-
Oracle
-
MS-Access
-
Mysql
-
All of the above
C
Correct answer
Explanation
Ensembl uses MySQL as its primary database system for storing and querying genomic data. Oracle is used by some other bioinformatics resources, MS-Access is not suitable for large-scale databases, and MySQL is the correct choice for Ensembl.
-
3-D Models
-
Wireframe
-
Matrix
-
Textual - for example, stories that summarize specific information
-
Diagrams
E
Correct answer
Explanation
Diagrams may be used to depict how data flows from one structure to the other.
-
Temporal cohesion
-
Procedural cohesion
-
Communicational cohesion
-
Logical cohesion
-
Coincidental cohesion
C
Correct answer
Explanation
Communicational cohesion is when parts of a module are grouped because they operate on the same data (e.g. a module which operates on the same record of information).
-
Common coupling
-
External coupling
-
Control coupling
-
Data coupling
-
Pathological coupling
A
Correct answer
Explanation
Common coupling (also known as Global coupling) occurs when two modules share the same global data (e.g., a global variable). Changing the shared resource implies changing all the modules using it.
-
OMT dynamic model
-
OMT functional model
-
Object model
-
Use-case model
-
Test model
C
Correct answer
Explanation
This model describes the structure of objects in a system, their identity, relationships to other object attributes and operations.
-
Transaction_read_uncommitted
-
Transaction_read_committed
-
Transaction_repeatable_read
-
Transaction _Synchronous
-
None of these
D
Correct answer
Explanation
Actually Transaction _Synchronous is a synchronous process and not a transaction isolation level in EJB.
-
Context diagram
-
Data dictionary
-
Structured query language
-
Data flow diagram
-
Structure chart
C
Correct answer
Explanation
The structured query language (SQL) is a standardized language for querying information from a database.
-
good()
-
rdstate()
-
clear()
-
isstate()
A
Correct answer
Explanation
The member function good() is used to check whether the state of the stream for input/output operation is good or not.
-
Entity
-
System architecture
-
Relationship
-
Logical entity relationship
-
Physical entity relationship
B
Correct answer
Explanation
This view of the system is defined as a set of structuring rules that allow a system to contain a set of simpler systems each with its own local perspective.