What operator tests column for absence of data

Related Posts: • What operator tests column for the absence of data? • Data can be supplied to PigUnit tests from: • "Which testing is the re-execution of some subset of tests… • Which data type can store unstructured data in a column? • The _______ operator takes the results of two queries and… • Which operator is used to compare a value to a specified…

Table 19-3 Guidelines for Choosing an Operator When Creating a Column Filter Operator Usage Guidelines is equal to / is in Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column matches the value in the filter. is not equal to / is not in Valid for a column that contains text, numbers, or dates. Specify a single value or multiple values. Results include only records where the data in the column does not match the value in the filter. is less than Valid for a column that contains numbers or dates. Specify a single value. Results include only records where the data in the column is less than the value in the filter. is greater than Valid for a column that contains numbers or dates. Specify a single value. Results include only records where the data in the column is greater than the value in the filter. is less than or equal to Valid for a column that contains numbers or dates. Specify a single value or multiple values. Results include only records where the data in the column is less than or the same as the value in the filter. is greater than or equal to Valid for a column that contains numbers or dates. Specify a single value or multiple values. Results include only records where the data in the column is greater than or the same as the value in the filter. is between Valid for a column that contains numbers or dates. Specify two values. Result include only records where...

• TRUNCATE removes single single rows from the table, whereas DELETE used for delete all rows from a table • DELETE use for delete a table whereas TRUNCATE use for delete database • DELETE can removes a single row with where condition but TRUNCATE Can not delete single row • None of the above Show Answer Solutions Tags: 60+ Best SQL Interview Questions, SQL MCQ questions for placement,SQL interview questions, Previously asked SQL Questions, Frequently asked SQL Questions,SQL Questions for TCS, SQL Interview Questions for Freshers, SQL Interview Questions for Experience, Accenture SQL Interview Questions, SQL Objective Questions for Interview,