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
-
Data cube
-
Data loading
-
Data transformation
-
Data quality
-
None of these
A
Correct answer
Explanation
Data cube allows data to be modelled and viewed in multiple dimensions.
-
solid part $\rightarrow$faces$\rightarrow$edges $\rightarrow$vertices
-
solid part$\rightarrow$edges $\rightarrow$faces$\rightarrow$vertices
-
vertices$\rightarrow$edges$\rightarrow$faces$\rightarrow$solid parts
-
vertices$\rightarrow$faces$\rightarrow$edges$\rightarrow$solid part
C
Correct answer
Explanation
Correct data structure for solid models is given by,
Vertices $\rightarrow$ edges $\rightarrow$ faces $\rightarrow$ solid parts
-
Data
-
Record
-
Data file
-
System
C
Correct answer
Explanation
Correct Answer: Data file
-
database
-
data file
-
data mart
-
data group
B
Correct answer
Explanation
Correct Answer: data file
B
Correct answer
Explanation
Correct answer.
The second numeral represents the maintenance release level. 2 is the database maintenance release number.
-
1, 2 and 3
-
1, 2, 3 and 4
-
1, 3, 4 and 5
-
2, 3 and 4
-
2, 4 and 5
C
Correct answer
Explanation
This option is correct because 1, 3, 4 and 5 are authorised operations.
-
It is a non-shared memory.
-
It is created when a server process is started.
-
Each server process is allocated One PGA.
-
Total memory used by all individual PGAs is called total instance PGA memory.
-
Database initialization parameters are used to set the size of individual PGAs.
E
Correct answer
Explanation
This statement is false. You use database initialization parameters to set the size of the instance PGA, not individual PGAs.
-
Database buffer cache
-
Log buffer
-
Large pool
-
Java pool
-
Shared pool
B
Correct answer
Explanation
In SGA memory structure, the size of the log buffer cannot be changed after instance startup.
-
The Oracle login process
-
The Oracle server process
-
SMON
-
PMON
-
The recoverer process
B
Correct answer
Explanation
When a user starts a new session in a database server, the oracle server process is involved first.
-
PMON
-
SMON
-
Database writer
-
Log writer
-
Checkpoint
A
Correct answer
Explanation
PMON performs process recovery when user process fails.
C
Correct answer
Explanation
Oracle allows a maximum of 20 database writer processes (DBW0-DBW9 and DBWa-DBWj).
-
V$CONTROLFILE_RECORD_SECTION
-
V$CONTROLFILE
-
V$PARAMETER
-
V$DATABASE
-
SHOW PARAMETER CONTROL_FILES
A
Correct answer
Explanation
V$CONTROLFILE_RECORD_SECTION displays information about the control file record sections.
-
Examine log files
-
CREATE CONTROLFILE
-
Transport tablespaces between databases
-
Make a logical backup of the rollback segment tablespace
-
Determine if platforms are supported and determine endianness
C
Correct answer
Explanation
This option is correct because the transport tablespaces between databases is a task a DBA can perform using the export/import facility.
-
To minimise downtime
-
To prevent further corruption of a damaged datafile
-
To allow automatic recovery of the datafile
-
To recover it later, when database is in NOARCHIVELOG mode
-
To maximise uptime
C
Correct answer
Explanation
When the database is in MOUNT state, a datafile is set to offline to allow its automatic recovery.
-
every time a tablespace is created
-
once for an entire database
-
every time a user is created
-
when time data is created
-
Both (1) and (2)
B
Correct answer
Explanation
A set of dictionary tables is created once a database is created.