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

Multiple choice

Example of non-numeric data is

  1. Employee address

  2. Examination score

  3. Bank balance

  4. All of the above

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Non-numeric data refers to information that cannot be represented as numbers, such as text, addresses, names, or descriptions. An employee's address contains alphanumeric characters and special symbols, making it non-numeric. Examination scores and bank balances are numeric data as they can be expressed as numbers.

Multiple choice

A company while sending its data to consultancy, sent the salary in one file and rest of the information in other file. Which function can be used to make a consolidated data with salary and rest of the information?

  1. HLOOKUP function

  2. VLOOKUP function

  3. GETPIVOTDATA function

  4. GET function

  5. GOT function
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The function merges the two files in sequential and orderly manner and makes a consolidated files at user end.

Multiple choice

In oracle DBMS, which is the strong password management feature that ensures a user cannot use the same password for a specific duration of time?

  1. Account blocking

  2. Account locking

  3. Password history

  4. Password verification

  5. Password matching
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBMS keeps the track of old password for specified duration of time as mentioned in the policy, and it does not allow the user to reset the same password for that duration.