NCP-DB Exam Questions with Correct Answers

NCP-DB Exam Questions with Correct
Answers
Which type of database is known for its ability to handle large-scale data with high
availability and fault tolerance?
a) Relational database
b) NoSQL database
c) In-memory database
d) Graph database - Answer-b) NoSQL database

How can you achieve high availability in a database system?
a) By implementing data replication and failover mechanisms
b) By encrypting sensitive data at rest and in transit
c) By optimizing database schema and indexing strategies
d) By partitioning the data into smaller logical units - Answer-a) By implementing data
replication and failover mechanisms

When applying procedural concepts to restore source databases, which programming
paradigm is commonly used?
a) Object-oriented programming
b) Functional programming
c) Procedural programming
d) Event-driven programming - Answer-c) Procedural programming

What does patching refer to in database management?
a) Applying updates and fixes to the database software
b) Making a copy of the database for testing purposes
c) Encrypting sensitive data in the database
d) Creating a duplicate of the database for redundancy - Answer-a) Applying updates
and fixes to the database software

Which of the following is a benefit of NDB databases?
a) Schema flexibility
b) Vertical scaling only
c) Limited data replication options
d) High availability and fault tolerance - Answer-d) High availability and fault tolerance

What is the primary goal of configuring NDB high availability?
a) Ensuring the availability and uptime of the NDB service
b) Optimizing query execution for faster data processing
c) Reducing network latency and improving performance
d) Securing the NDB instance with strong access controls - Answer-a) Ensuring the
availability and uptime of the NDB service

, Which factor is NOT typically considered when selecting a database engine for
provisioning?
a) Data consistency and transaction support
b) Hardware and infrastructure requirements
c) Developer community and support resources
d) Network latency and bandwidth - Answer-d) Network latency and bandwidth

How should database patches be published after testing?
a) Make them available for download on a secure website
b) Distribute them through a software update mechanism
c) Notify users and provide instructions for manual installation
d) All of the above - Answer-d) All of the above

Why would you assign a static IP address to an NDB instance?
a) To ensure the NDB instance can be accessed from any network
b) To facilitate load balancing and high availability for the NDB instance
c) To improve security by restricting access to a specific IP address
d) To simplify network configuration and avoid IP conflicts - Answer-d) To simplify
network configuration and avoid IP conflicts

When applying procedural concepts to provision databases, which programming
paradigm is commonly used?
a) Object-oriented programming
b) Procedural programming
c) Functional programming
d) Event-driven programming - Answer-b) Procedural programming

Log Catch-Up Operation - Answer-Copies transaction logs from the source database to
NDB based on a specified schedule.

Service Level Agreements (SLAs) - Answer-Data retention policies that let you specify
for how long NDB retains the log backups and snapshots taken by the time machine

What is the first step to installing NDB? - Answer-Download image file from Support
Portal

True or False: For Oracle and SQL you must create a software profile - Answer-True

Compute Profile - Answer-specifies the size of the database server VM

Network Profile - Answer-specifies the VLAN for the new database server VM

True or False: NDB has a default network profile - Answer-False (NDB does NOT have
a default network profile)