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

  1. Home

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

1.By setting required to ‘Yes’

2.By using default value

3.By defining validation rule

4. By using forma

Posted Date:-2021-02-19 14:57:20

More MCQS Questions and answers

  1. What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
  2. How to make a date field DOB store the dates like “2002/10/17” ?
  3. In a datasheet, what does each column represent?
  4. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
  5. What is an intersection of a row and a column?
  6. Which criteria do not return the position “Officer” as a match?
  7. Which is the valid data type in Access?
  8. Which leads you through the process of creating a table?
  9. Which object is used to create a form?
  10. Which of the following is not a database application?
  11. Which of the following is not an action query?
  12. Which tool do you use to create a query object?
  13. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
  14. A ________ is a unit of information in a ________
  15. After right click the field selector button, which do you choose to delete a field in design view?
  16. How many relations may exist between tables in databases?
  17. HSAM stands for ________
  18. In a datasheet, what does each row represent?
  19. In an application created using the database wizard, the main menu is presented as a
  20. In databases, Locking level is also called as
  21. In MS Access, Text Data type may contain maximum character of
  22. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
  23. 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?
  24.  An organized collection of logically related data is known as 
  25. The basic elements of a form or a report are called
  26. The report footer section is most useful for displaying
  27. What do you call a collection of records matching parameters of a query?
  28. What do you call a primary key field included in another table?
  29. What do you call the process of restricting the display of records in a table to those matching a particular criterion?
  30. What does the expression [detail] ! [product] * 1.30 do?
  31. What is the full form of SQL?
  32. What is the purpose of indexing?
  33. Which control type do you use to create a calculated control?
  34. Which control types is most often associated with a bound control?
  35. Which criteria return only those addresses beginning with the letter “K”?
  36. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
  37. Which data type is better to use for storing the price of an item?
  38. Which do you click to display the table’s primary key and indexes in a separate window?
  39. Which function can not be used for calculated controls in a report?
  40. Which is not a command that is selectable from right click menu of a field column?
  41. Which is not a view for displaying a report object?
  42. Which is not an option for customizing a datasheet window?
  43. Which of the following is not a legitimate section for form objects?
  44. Which of the following is not a logical database structure?
  45. Which of the following is not a view for interacting with a form object?
  46. Which query do you use to answer the question “What is the average salary of the employees”?
  47. Which query do you use to answer the question “Which employees earn more than $5000 a month?
  48. Which setting you must modify to print a report using letterhead?
  49. Which tool is used to generate printout of a table’s structure?
  50. Which type of field is incremented automatically?
Search
Olete Team
Online Exam Test Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Test website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!