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 technology platforms and products

What is the certification requirement for an application running on the Sun Oracle Database Machine?

  1. The application must be certified on Oracle Database 11gR2.

  2. The application must be certified on Oracle Database 11 or higher.

  3. The application certification does not matter as long as the middleware is appropriately certifed for the Sun Oracle Database Machine.

  4. Application certification does not matter for the Sun Oracle Database Machine.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Applications running on the Sun Oracle Database Machine must be certified on Oracle Database 11gR2, as this is the database version that Exadata initially supported and optimized for. Certification on Oracle Database 11 or higher is insufficient without the specific R2 requirement. Middleware certification does not substitute for application certification, and certification does matter for Exadata deployments.

Multiple choice technology platforms and products

Which of the following is an example of a weakness in the offerings from competitors to the Sun Oracle Database Machine?

  1. The competition cannot handle mixed OLTP and Reporting demands.

  2. The competition has limited flash capabilities.

  3. The competition is not fully fault tolerant.

  4. The competition uses commodity hardware
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Competitors to the Sun Oracle Database Machine have several weaknesses: they cannot handle mixed OLTP and reporting demands effectively, have limited flash capabilities compared to Exadata's smart flash cache, and are not fully fault tolerant across all layers. Using commodity hardware is actually a shared characteristic, not a weakness: the Exadata also uses commodity components but adds software intelligence.

Multiple choice technology platforms and products

Storage indexes provide for better performance in a manner most similar to which of the following features?

  1. Materialized views

  2. Hybrid Columnar Compression

  3. Parallelism

  4. Partitioning
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Storage indexes in Exadata provide performance optimization most similarly to partitioning. Both features work by eliminating unnecessary data access: storage indexes track min/max values in storage regions to skip entire regions during queries, while partitioning allows the optimizer to skip entire partitions. Materialized views pre-compute results, Hybrid Columnar Compression reduces storage, and parallelism distributes work across processes.

Multiple choice technology platforms and products

Emphasis on the complete solution and speed of deployment of the Sun Oracle Database Machine is most appropriate in which of the following sales scenarios?

  1. The opportunity centers around a hardware refresh.

  2. The customer has an existing data warehouse with poor IO performance.

  3. The competition is advocating for an "appliance" solution.

  4. none of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When competitors advocate an 'appliance' solution, emphasizing Exadata's complete solution and rapid deployment is most effective. This positions Exadata as a proven, integrated alternative rather than comparing feature-by-feature. Hardware refresh scenarios emphasize cost, existing DW issues emphasize performance, neither is the primary 'complete solution' pitch.

Multiple choice technology platforms and products

At which of the following levels is the Sun Oracle Database Machine considered to be "Fault Tolerant"?

  1. Database, Storage, and Network

  2. Database and Storage

  3. Database only

  4. Database and Network

  5. Fault tolerance will be fully available in the next version of the Sun Oracle Database Machine.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Sun Oracle Database Machine is fault tolerant at three levels: Database (via RAC, ASM, and Data Guard), Storage (via ASM disk mirroring and cell redundancy), and Network (via multiple network paths and InfiniBand redundancy). This comprehensive fault tolerance differentiates Exadata from competitors who may only address one or two layers.

Multiple choice technology platforms and products

Which of the following are the top "Line of Business" priorities in an Exadata data warehousing opportunity?

  1. Business Value, Ease of Access, Results in Time for Deadlines, and "Best in Class" Infrastructure.

  2. Business Value, Improved Security, Results in Time for Deadlines, and "Good Enough" Infrastructure

  3. Reduced Cost, Ease of Access, Results in Time for Deadlines, and "Best in Class" Infrastructure.

  4. Business Value, Ease of Access, Results in Time for Deadlines, and "Good Enough" Infrastructure.

  5. Reduced Cost, Improved Security, Results in Time for Deadlines, and "Good Enough" Infrastructure.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

For Exadata data warehousing opportunities, the top Line of Business priorities are Business Value (justifying the investment), Ease of Access (self-service for business users), Results in Time for Deadlines (meeting SLA requirements), and 'Good Enough' Infrastructure (avoiding over-engineering). 'Best in Class' infrastructure and reduced cost are less critical than these operational priorities.

Multiple choice technology platforms and products

Hybrid Columnar Compression is a feature of which product?

  1. Exadata Storage Server Software

  2. Oracle Database 11gR2

  3. Oracle Database 11gR1

  4. Exadata Storage Server Hardware
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hybrid Columnar Compression (HCC) is a feature of Exadata Storage Server Software, not Oracle Database itself. While HCC is accessed through database commands, the compression technology is implemented in the Exadata storage cell software and requires Exadata hardware to function. Standard Oracle Database editions (11gR2, 11gR1) do not include HCC.

Multiple choice technology platforms and products

Which of the following questions might be asked of a Solution Architect to identify a Sun Oracle Database Machine opportunity?

  1. How do you preserve a single source of the truth?

  2. Is your current solution entirely fault tolerant?

  3. Are you planning to consolidate data warehouses?

  4. Do business users complain about high latency issues?
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

All four questions probe pain points that Exadata Database Machine addresses: data silos/single source of truth, fault tolerance/high availability, data warehouse consolidation needs, and performance/latency issues. These are standard discovery questions for solution architects to identify data warehousing and consolidation opportunities.

Multiple choice technology platforms and products

When positioning the Sun Oracle Database Machine in a data warehousing opportunity, which of the following points should be emphasized?

  1. Return of results up to 20 times faster, thereby enabling better and faster business decisions

  2. Simplification and reduction of data warehousing costs by up to 70%

  3. Return of results up to 20 times faster and reduction of data warehousing costs by up to 70%

  4. All answers are incorrect
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Exadata's key value propositions are performance acceleration (up to 20x faster query results) AND cost reduction (up to 70% reduction in data warehousing costs). Option C correctly combines both primary benefits, while A and B each only state one benefit.

Multiple choice technology platforms and products

When positioning the Sun Oracle Database Machine against a Sun Solaris or other Sun Server, it is important to emphasize the benefits of custom servers and storage over commodity components.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Exadata emphasizes commodity hardware (industry-standard servers and storage components) differentiated by intelligent software innovations like Smart Scan, Hybrid Columnar Compression, and Smart Flash Cache. The positioning message is about software excellence on commodity components, NOT custom hardware.

Multiple choice technology platforms and products

In Hybrid Columnar Compression, data is organized by

  1. Table instead of Column

  2. Index instead of Table

  3. Column instead of Row

  4. Row instead of Column
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Hybrid Columnar Compression stores data in a columnar format rather than traditional row-oriented storage. This enables better compression ratios for similar data types within a column (e.g., many repeated state codes), improving storage efficiency and query performance for analytical workloads.

Multiple choice technology platforms and products

What products are included in the Oracle Exadata Storage Server Software Support agreement?

  1. Oracle Database Support

  2. Oracle Enterprise Linux Support

  3. Oracle Exadata Storage Server Support

  4. Oracle Real Application Clusters
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

The Oracle Exadata Storage Server Software Support specifically covers the Exadata storage server software stack (Option C) and Oracle Enterprise Linux OS running on the storage servers (Option B). Oracle Database licenses and RAC options are separate support agreements not included in this storage-server-focused support package.

Multiple choice technology platforms and products

Process Commander is based on an open database architecture architecture that works with Microsoft SQL Server, Oracle, and IBM UDB/DB2.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Pega Process Commander (PRPC) is designed with an open database architecture that supports multiple RDBMS platforms including Microsoft SQL Server, Oracle, and IBM DB2/UDB. This multi-platform support is a key architectural feature.

Multiple choice technology platforms and products

Which of the following property is not an aggregate property?

  1. Page

  2. PageList

  3. PageGroup

  4. SingleValue

  5. ValueGroup

  6. ValueList
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Pega, properties can be aggregate (containing multiple values) or single-value. Page, PageList, PageGroup, ValueList, and ValueGroup are all aggregate property types - they can hold multiple values or nested structures. SingleValue is NOT an aggregate property - it holds exactly one scalar value like a string, number, or date, making it the correct answer for what is NOT an aggregate property.