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) B...
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)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller lectknancy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.49. You're not tied to anything after your purchase.
