adplus-dvertising
frame-decoration

Question

What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

a.

display all customers with CustID from 10 to 100

b.

display all customers with CustID above 10

c.

display all customers with CustID below 100

d.

display all customers with CustID from 11 to 99

Posted under MS Access MS Office

Answer: (d).display all customers with CustID from 11 to 99

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

Similar Questions

Discover Related MCQs

Q. How to make a date field DOB store the dates like “2002/10/17” ?

Q. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

Q. In an application created using the database wizard, the main menu is presented as a:

Q. Which leads you through the process of creating a table?

Q. Which data type is better to use for storing the price of an item?

Q. Which do you click to display the table’s primary key and indexes in a separate window?

Q. After right click the field selector button, which do you choose to delete a field in design view?

Q. Which tool is used to generate printout of a table’s structure?

Q. Which of the following is not a legitimate section for form objects?

Q. Which control types is most often associated with a bound control?

Q. Which control type do you use to create a calculated control?

Q. Which is not a view for displaying a report object?

Q. The report footer section is most useful for displaying:

Q. Which function can not be used for calculated controls in a report?

Q. Which setting you must modify to print a report using letterhead?

Q. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

Q. Which is not an option for customizing a datasheet window?

Q. Which is not a command that is selectable from right click menu of a field column?

Q. What do you call the process of restricting the display of records in a table to those matching a particular criterion?

Q. In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?