Computer Knowledge

Database Management Systems

5,543 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

Multiple choice

CDPD means

  1. cellular digital popular data

  2. cellular digital packet data

  3. complex digital packet data

  4. complex digital popular data
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

CDPD stands for Cellular Digital Packet Data. It was a data transmission technology used on analog cellular networks (AMPS) in the 1990s. It allowed for packet-switched data to be sent during the idle periods of voice channels, providing an early form of mobile internet access.

Multiple choice

Which of the following is/are correct about Recovery Time Objective (RTO) in Disaster Recovery plan?

  1. It refers to the maximum length of time a system can be down after a failure or disaster.

  2. RTO determines the amount of lost revenue per amount of lost time.

  3. It specifies a point in time that data must be recovered and backed up in order for business operations to resume.

  4. It determines the expected time for the business operations.

  5. Only 1 and 2
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are correct statements about Recovery Time Objective in Disaster recovery plan.

Multiple choice

Which of the following is/are applicable for Recovery Point Objective (RPO) in Disaster recovery plan?

  1. It determines the data recovery and backing time for business processes.

  2. It determines the minimum frequency at which interval backups need to occur.

  3. It refers to the maximum length of time a system can be down after a failure or disaster before the company is negatively impacted by the downtime.

  4. All of the above

  5. Only 1 and 2
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are correct about Recovery Point Objective (RPO) in Disaster recovery plan.

Multiple choice

What is the role of sequencer in request manipulation in burp suite?

  1. This tool is a better choice for application security.

  2. It defines the application's status in terms of sessions.

  3. It maintains the application performance for virus security.

  4. All of the above

  5. Both (1) and (2)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are correct statements about Sequencer tool for request manipulation in burp suite.

Multiple choice

Which of the following is known as 'Vulnerability Monitor' component in vulnerability assessment?

  1. It is used to identify and store the information related to vulnerabilities in the system.

  2. It collects the information and executes the files for the database specific to the vulnerability monitor.

  3. It checks the version of a started program for vulnerabilities against a special database.

  4. The vulnerability check is performed in the background mode and does not delay the program start.

  5. Both (3) and (4)
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are the correct statements.

Multiple choice

What is 'ISOLATION LEVEL SERIALIZE' parameter in SET TRANSACTION statement in PL/SQL?

  1. It is used to check the resource to be updated by multiple transactions.

  2. If a transaction requires row locks held by another transaction, the transaction will wait until the row locks are released.

  3. It assigns the transaction to a rollback segment identified by 'segment_name'.

  4. It assigns a name to the transaction identified by 'transaction_name'.

  5. Both (1) and (3)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

If a transaction attempts to update a resource that has been updated by another transaction and uncommitted, the transaction will fail.

Multiple choice

Which of the following statements is/are incorrect about 'SAVEPOINT' clause in Rollback statement in PL/SQL?

  1. It is used to undo all the changes for the current session.

  2. It is used to force the rollback of a transaction that may be corrupt or in doubt.

  3. ROLLBACK TO SAVEPOINT savepoint 1 is the syntax for this clause.

  4. ROLLBACK WORK TO SAVEPOINT savepoint 1 is the syntax for this clause.

  5. Both (2) and (3)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is called 'FORCE' clause in Rollback statement.