You are maintaining data for its products in the Products table, and want to see the products that are 50 or more in number, far from the minimum stock limit. The structure of the Products table is:

        ProductID
        ProductName
        CurrentStock
        MinimumStock

Two possible queries are:

(a)select * from products where currentStock > MinimumStock + 50
(b)select * from products where currentStock - 50 > MinimumStock

Choose the appropriate option with regard to the above queries.

The AND operator displays a row if ANY conditions listed are true. The OR operator displays a row if ALL of the conditions listed are true

Examine the query:- select (2/2/4) from tab1; where tab1 is a table with one row. This would give a result of:

Which field is the ideal candidate for the primary key in a student record base?

A production house needs a sale report where total sale of the day is more than $20,000. Which of the following query should be used?

Which statements are false?

Which one is the correct data type of the 'totalMB' element of the clusterMetrics object used in the YARN ResourceManager REST API?

Which are NOT the properties of the app (Application) object of NodeManager REST API?

Which Hadoop DFSAdmin command generates a list of DataNodes?

Which Hadoop command is used for copying a source path to stdout?

In case of a Multiquery execution, which code indicates retrievable errors for an execution?