5 years ago in Database Management System

What rows will this select statement return ?
SELECT * FROM products WHERE ordernumber > = 1000

[A] All rows in the products table whose order number is greater than or equal to 1000
[B] All rows in the products table whose order number is less than or equal to 1000
[C] The first 1000 rows of the product table
[D] All rows in the products table whose order number is greater than 1000
Loading...
Next Question

Overall Stats

Attempted 343
Correct 146
Incorrect 31
Viewed 166

Answers

Guest
Guest
Shamsa hafeez
Shamsa hafeez - 1 week ago

Shamsa hafeez from Lahore, Pakistan is saying All rows in the products table whose order number is greater than or equal to 1000 is correct answer

Tsega Asresa Mengistu
Tsega Asresa Mengistu - 1 week ago

Tsega Asresa Mengistu from Dessie, Ethiopia is saying All rows in the products table whose order number is greater than or equal to 1000 is correct answer

Serkie Mekonnen
Serkie Mekonnen - 1 week ago

Serkie Mekonnen from Dessie, Ethiopia is saying All rows in the products table whose order number is greater than or equal to 1000 is correct answer

Deep
Deep - 1 month ago

Deep from Kolkata, India is saying All rows in the products table whose order number is greater than or equal to 1000 is correct answer

Arpita Dhote
Arpita Dhote - 1 month ago

Arpita Dhote from Pune, India is saying All rows in the products table whose order number is greater than or equal to 1000 is correct answer

Related Questions

The number of attributes in relation is called as its .....................

  • [A] Cardinality
  • [B] Degree
  • [C] Tuple
  • [D] Row

View Answer

The ..................... is essentially used to search for patterns in target string.

  • [A] Like predicate
  • [B] Null predicate
  • [C] in predicate
  • [D] out predicate

View Answer

..............defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

  • [A] Schema
  • [B] Program
  • [C] Instance
  • [D] none

View Answer

Which one of the following is a direct benefit of databse normalization?

  • [A] higher query processing efficiency
  • [B] smaller number of tables
  • [C] reduced I/O for most queries
  • [D] reduced data redundancy

View Answer

Versatile report generator can provide ?

  • [A] Columnar totals
  • [B] Subtotal
  • [C] Calculation
  • [D] ALL

View Answer