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
-
Table spaces
-
Partitioned tables
-
Views
-
Data segment compression
-
Integrity constraints
D
Correct answer
Explanation
This method in physical design structures should be used with highly redundant data such as tables with many foreign keys.
-
Selection
-
Conversion
-
Summarisation
-
Splitting/Joining
-
Enrichment
D
Correct answer
Explanation
This task in data transformation includes the types of data manipulation a user need to perform on the selected parts of source records.
-
Full extraction
-
Incremental extraction
-
Online extraction
-
Offline extraction
-
Flat files
B
Correct answer
Explanation
This type of logical extraction method extracts only the data that has changed, since a well defined event back in history.
-
Logical data model
-
Physical data model
-
Conceptual data model
-
Dimensional modeling
-
E-R modeling
C
Correct answer
Explanation
This data model describes data from a high level and defines the problem rather than the solution from the business point of view.
-
Fact constellation schema
-
Sub-schema
-
Data dictionary
-
Snowflake schema
-
Star schema
D
Correct answer
Explanation
This schema in data warehouse is a method of normalising the dimension tables in a star schema.
-
Data warehouses are not usually relational but multidimensional.
-
Data warehouses cannot be indexed.
-
Data warehouses exist as persistent storage.
-
These provides specific support of functionality.
-
These provides large amounts of integrated and often temporal data.
B
Correct answer
Explanation
This property of data warehouse is not correct as data warehouses can be indexed to optimise performance.
-
The repository model
-
The abstract machine model
-
Client-Server model
-
Control model
-
Broadcast model
C
Correct answer
Explanation
This system model is a distributed system model which shows how data and processing is distributed across a range of processors.
A
Correct answer
Explanation
Oracle allows a maximum of 20 database write processes.
-
PMON
-
SMON
-
Database writer
-
Log writer
-
Checkpoint
A
Correct answer
Explanation
PMON performs process recovery when user process fails.
-
V$CONTROLFILE_RECORD_SECTION
-
V$CONTROLFILE
-
V$CONTROLFILE_SECTION
-
DBA_CONTROLFILE_SECTION
-
DBA_CONRTOLFILE_RECORD_SECTION
-
internal errors
-
block corruption errors
-
deadlock errors
-
errors occurred during dispached processes
-
external errors
B
Correct answer
Explanation
ORA-1578 – block corruption errors
-
Only 1
-
Only 2
-
Only 3
-
Both 1 and 2
-
Both 1 and 3
A
Correct answer
Explanation
Non-secure remote connections use only password files to authenticate DBA to connect with Oracle as a privileged user.
-
Performing start up and shut down operations
-
Creating database
-
Altering database
-
Archiving log and recovery
-
Including the restricted session privilege
B
Correct answer
Explanation
Creating database – Not authorised operation
-
The Oracle login process
-
The Oracle server process
-
The system monitor process
-
Both 1 and 3
-
PMON
B
Correct answer
Explanation
When a user starts a new session in a database server, the Oracle server process is involved first.
-
Network administrator
-
Security officer
-
Database administrator
-
Application administrator
-
Database user
C
Correct answer
Explanation
Database administrator is responsible for planning for backup and recovery of database information.