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 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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
