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
-
Property object
-
Container object
-
Data access object
-
Database object
-
QueryDef object
A
Correct answer
Explanation
It represents built-in characteristics or user defined characteristics of a data access object.
-
TableDef object
-
QueryDef object
-
Relation object
-
Container object
-
Field object
D
Correct answer
Explanation
It holds the information describing the objects, which are grouped into that container.
It corresponds to a column of data type and a set of properties.
-
Recordset object
-
Table type recordset object
-
QueryDef object
-
Field object
-
Snapshot type recordset object
E
Correct answer
Explanation
It contains a fixed set of data, as it exists, when the summary is created.
-
Table type recordset object
-
Dynaset type recordset object
-
Recordset object
-
Data access object
-
DBEngine
B
Correct answer
Explanation
It can refer to either local or attached tables, or to the result of queries.
-
JDBC API
-
JDBC driver manager
-
JDBC ODBC bridge
-
JDBC test suite
-
Native protocol pure java driver
D
Correct answer
Explanation
It helps you to determine that JDBC drivers will run your program.
-
Data mining
-
Transformation
-
Preprocessing
-
Either transformation or data mining
-
None of these
C
Correct answer
Explanation
This is the data cleansing stage where certain information is removed, which is deemed unnecessary and may slow down queries.
-
Slicing and dicing
-
Drill-Down
-
Consolidation
-
Either slicing and dicing or drill-down
-
None of these
C
Correct answer
Explanation
This OLAP database servers analytically involves in the aggregation of data such as simple roll-ups or complex expressions, involving inter-related data.
-
commit
-
log
-
abort
-
either log or abort
-
none of these
A
Correct answer
Explanation
The completion of a transaction is called commit.
-
Remote transaction
-
Distributed query optimization
-
Distributed database
-
Either remote transaction or distributed database
-
None of these
B
Correct answer
Explanation
Distributed query optimisation reduces the amount of required data transfer, when compared to transferring all the table data to the local site for processing.
-
Forget phase
-
Prepare phase
-
Commit phase
-
Either Forget phase or Commit phase
-
None of these
B
Correct answer
Explanation
In prepare phase, the system does not actually commit or roll back the transaction instead all nodes referenced in a distributed transaction is told to prepare to commit.
-
foreign key
-
primary key
-
composite key
-
table relation key
-
candidate key
A
Correct answer
Explanation
It is used for referential integrity between one or more tables.
-
attributes
-
tables
-
databases
-
records
-
entities
A
Correct answer
Explanation
The relationship between attributes is known as functional dependency.
-
Partial dependency
-
Transitive dependency
-
Multivalued dependency
-
Join dependency
-
Both 3 and 4
-
TX_REQUIRED
-
TX_REQUIRES_NEW
-
TX_BEAN_MANAGED
-
Instance passivation
-
Application assembler
B
Correct answer
Explanation
If a transaction is under way, the container temporarily suspends it until the bean's transaction finishes.
-
Snowflake schema
-
Star schema
-
Fact constellation
-
Data
-
Business query view
E
Correct answer
Explanation
It is the perspective of data in the data ware house from the viewpoint of the end user.