Which of the following constraints can be used to enforce the uniqueness of rows in a table?  

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?

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:

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?

Which one is the correct syntax for resetting the space quota for directories in HDFS?

Which object is used by the RecordReader class for reading data from an InputSplit class?

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?