PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

Which of the following protection techniques will you suggest for this database?

Your Company is designing and developing a number of databases for a stock exchange. One of the
databases will contain highly sensitive data for which high level of security will be required. Although
high processing speed is one of the prime requirements of the customer, for this database, security
of the data will take priority over the processing speed. It needs to be ensured that even if
unauthorized access to the database is obtained, the rogue user is unable to read the data. Which of
the following protection techniques will you suggest for this database?

What will you do to accomplish the task?

You work as an ADO.NET Application Developer for company Inc. The company uses Microsoft Visual
Studio .NET 2008 as its application development platform. You create an ADO.NET application by
using .NET Framework 3.5. The application uses a Microsoft SQL Sever database. You use a DataSet
control in the application. You want to add or refresh rows in the DataSet. You need to ensure that
when you add or refresh row in the DataSet you will get number of rows that are successfully added
or refreshed in the DataSet. What will you do to accomplish the task?

which of the following tables will this command work?

You are a Database Administrator of MySQL database. Few days back, your server crashed. Now, it is
up and online. You need to check the integrity of various tables used in the database. You need to
issue the CHECK TABLE command. For which of the following tables will this command work?
Each correct answer represents a complete solution. Choose two.