Question: A customer record has the following data fields: ( CustomerID , Name, Address, Zip code ) . For ensuring security, each customer record in a

A customer record has the following data fields: (CustomerID, Name, Address, Zip code). For ensuring security, each customer record in a database was encrypted before uploading to the cloud. Each data field within the customer record was encrypted separately before storing.
Once all records are stored in the cloud, on a need basis, a query can be executed to retrieve customer records from the cloud based on a given search condition.
Which of the following queries can be executed in the cloud itself without having decrypt the data first? (Note: query is not in any particular query language)
Question 33 options:
retrieve all records where Customer names start with A
retrieve all records where Customer names contain Joe
retrieve all records where CustomerID is equal to 1782
retrieve all records where Customer names end with A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!