Question: How to compare two strings are equal or not with logical operators in between those strings. These strings are table columns ? Let's say countrycode

How to compare two strings are equal or not with logical operators in between those strings. These strings are table columns ?

Let's say countrycode , domainNumber , employeeType are the columns of the table . We want to compare the expressions that are formed by these columns with logical operators in between in any order are not same .

Example 1 :

str1: (country_code ='US' AND domain_num ='5' OR employee_type ='FT')

str2 : (country_code ='US' OR domain_num ='5' AND employee_type ='FT')

Answer : False

Example 2 :

(employee_type = 'P' AND (domain_num = '1' or domain_num = '3') AND country_code = 'US')

(country_code = 'US' AND (domain_num = '1' or domain_num = '3') AND employee_type = 'P')

Answer : True

Example 2 : (employee_type = 'P' AND (domain_num = '3' or domain_num = '1') AND country_code = 'US')

(country_code = 'US' AND (domain_num = '1' AND domain_num = '3') AND employee_type = 'P')

Answer : False

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!

Java 1. The data file. The first part of your assignment is to select a subject for a data file, which will be a simple version of what is called a "database." A data file typically contains...

Logical operators and comparing Strings In this exercise you will get experience using "and", "or", and "not" in Java using the logical operators &&, ||, and !. You will also learn how to compare...

Let r and s be solutions to the quadratic equation x 2 b x + c = 0. For n N, define d0 = 0 d1 = r s dn = b dn1 c dn2 (n 2) Prove that dn = r n s n for all n N. [4 marks] (b) Recall that a commutative...

ttth Suppose that the sequence of bags {Bn | n N} is recursively enumerated by the computable function e(n, x) = fn(x), [7 marks] Hence prove that the set of all recursive bags cannot be recursively...

"Fortran, Algol and Lisp invented most programming language concepts 50 years ago; adding the concept of object-orientation suffices to explain all programming languages to date". To what extent is...

1. What is the issue being addressed in the paper? 2. What are the findings of the paper? 3. Why is this paper important to auditors, and what are the implications of this paper for the auditing...

ENSURE WORK IS ORIGINAL OR I REJECT AND REPORT YOU TON THE SUPPORT INSTANTLYThe end result does now not should be taken care of. You may additionally expect n 6 length(xs). [Hint: Function least is a...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Satellite Data Retrieval, Reference Frames, Numerical and Analytical Orbital Propagation SSD Individual Assignment RMIT University Figure 1: Example errors between a ground truth ephemeris and...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

The data in Table P2.3 are available for two companies, A and B, all stated in millions. (a) Calculate each company's return on equity (ROE) and return on total assets (ROA). (b) Why Company B's ROE...

Let v1, v2 be two vectors in a vector space V. Show that v1 and v2 are linearly dependent if and only if one of the vectors is a scalar multiple of the other.

When one unit charges another unit in the same company for goods it ships to its foreign subsidiaries, the charge is called a ( n ) _ _ _ _ _ _ _ _ price.

Bauer Manufacturing uses departmental cost driver rates to allocate manufacturing overhead costs to products. Manufacturing overhead costs are allocated on the basis of machine - hours in the...

1. How would you evaluate The Limiteds approach for communicating information about benefits to its employees? What might you have done differently if you were an HR professional in the company?

2. Discuss the following statement: Health care costs are out of control in the United States, and increasing conflicts between employers and employees are likely as employers try to reduce their...

1. Why are benefits strategically important to employers, and what are some key strategic considerations?