You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?

  1. Home

Question:
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?

1.5

2.8

3.24

4.Not enough information to tell

Posted Date:-2021-02-19 08:10:43

More MCQS Questions and answers

  1. A(n) _____ is a control that, when clicked, executes an action or series of actions.
  2. A(n) _____ is an image control that displays in the background of a page on a form or report.
  3. A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
  4. A(n) _______________ query makes changes to or moves records in a dynaset, in a single operation.
  5. According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
  6. HTML stands for ____.
  7. If you need a calculation in an unbound control, you can create a custom _____.
  8. In Access 2007 to make changes in the Trust Center, you need to go to the ____.
  9. What does an inner join display?
  10. Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
  11. Which of the following functions is used to all the values in a numeric field?
  12. Which of the following is the default join between two recordsets?
  13. You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
  14. A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
  15. A global join will be created automatically when using tables in a(n) _____.
  16. A Smart Tag can be set using the _____ tab in the property sheet.
  17. A summary query can be created by adding which row to the design grid of a select query?
  18. A(n) _______________ query locates data from one or more tables.
  19. ccording to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
  20. For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
  21. How can a user open the Expression Builder dialog box?
  22. If a color property contains “#336699”, how many blue units are in the color?
  23. In a junction table, the _____ field consists of the foreign key from both the linked tables.
  24. In a query, what symbol is used to surround a parameter’s user prompt?
  25. In a query, which row do you need to place wildcards to affect a parameter?
  26. In a query’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
  27. In Access 2007, to set a table to open as a document tab, you need to go to the ____.
  28. The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
  29. The _____ function returns a string that has been converted to uppercase text.
  30. The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
  31. The _____ Symbol Smart Tag launches Microsoft Explorer and obtains a stock quote.
  32. The Allow _____ property controls whether new records can be added through the form.
  33. The page count of a report can be determined by clicking the _______ button.
  34. The three parts of an IIF function are separated by _____.
  35. What is an index?
  36. When adding an image, which size mode will change the height or width of the image fit the control?
  37. When you add fields in ____, a Field List pane displays.
  38. Which colors are used to define a custom color?
  39. Which function evaluates a “true/false” expression and then performs one of two actions?
  40. Which function extracts the name of the month from a date/time value?
  41. Which of the following is a standard file format language for web documents?
  42. Which of the following is NOT true about background images?
  43. Which of the following is the file extension for an Extensible Markup Language?
  44. Which of the following queries can create a table?
  45. Which of the following queries modifies fields not records?
  46. Which of the following queries prompts users for input data by displaying dialog boxes?
  47. Which of the following types of joins displays records with the same value in the common field?
  48. Which part of the IIF expression is the action performed if the true condition exists?
  49. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
  50. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in 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!