TipsMake

The multiple-choice question set has an answer to Query P1

In the previous articles, the Network Administrator sent you read Query queries. Following the series on this topic, below is the next part of the questionnaire, invite readers to try.

★ Multiple choice questions have a Query option
★ Action Query in Action 2016
  • Question 1. Which dialog box will appear when we run the query?
    The multiple-choice question set has an answer to Query P1 Picture 1
    • Update Query

    • Make-Table Query

    • Select Query
    • Append Query
  • Question 2. This dialog box will appear when we choose which query?
    The multiple-choice question set has an answer to Query P1 Picture 2

    • Update Query

    • Make-Table Query
    • Select Query
    • Append Query
  • Question 3. When the query is run, the field will appear on the screen
    The multiple-choice question set has an answer to Query P1 Picture 3

    • FCode, GCode, FnameinVN

    • FCode, GCode, FnameinVN, FnameinE

    • FCode, GCode, FnameinE

    • FCode, FnaminVN, FnameinE
  • Question 4. When running the following query, what will be the result?
    The multiple-choice question set has an answer to Query P1 Picture 4
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN with records with SOTIEN> = 1000000
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN with records with SOTIEN <= 1000000
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN with records with SOTIEN> 1000000
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN
  • Question 5. When running the following query, what will be the result?
    The multiple-choice question set has an answer to Query P1 Picture 5
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN with records with SOTIEN> = 1000000
    • Appear fields NOW, TENKHOAN, SOTIEN, MAKHOAN with records with SOTIEN> = 1000000 and date columns sorted in ascending order
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN with records with SOTIEN> 1000000
    • Appear fields IMMEDIATE, TENKHOAN, SOTIEN, MAKHOAN
  • Question 6. When running the following query, what will be the result?
    The multiple-choice question set has an answer to Query P1 Picture 6

    • Appear TENDV, DIACHI, TEL, Year, SOTIEN fields with condition 100000> = SOTIEN> = 20000

    • Appear TENDV, DIACHI, TEL, Year, SOTIEN fields with condition 100000 <= SOTIEN <= 20000
    • Appear TENDV, DIACHI, TEL, Nam, SOTIEN fields with conditions 100000> = SOTIEN> = 20000
    • Appear TENDV, DIACHI, TEL, Nam, SOTIEN fields with condition 100000 <= SOTIEN <= 20000
  • Question 7. When you run the following query, what results will you give?
    The multiple-choice question set has an answer to Query P1 Picture 7
    • Create a new table with NOW, SOTIEN, TENDV, and DIACHI fields
    • Appeared schools IMMEDIATE, SOTIEN, TENDV, DIACHI
    • Both A and B
    • All is wrong
  • Question 8. What happens when I run the following query?
    The multiple-choice question set has an answer to Query P1 Picture 8
    • The records in the PHIEU COLLECTION have SOTIEN
    • The records in the PHIEU COLLECTION table with SOTIEN> = 20000 will be deleted
    • The records in the PHIEU COLLECTION table with SOTIEN> 20000 will be deleted
    • Appeared fields SIGHT, SOTIEN, SOPHIEU, LYDO with SOTIEN> = 20000
  • Question 9. How do I choose the query type to Update Query?

    • File Update Query

    • View Update Query

    • Query Update Query

    • Click the Query Type icon on the toolbar, select Update

    • Only C and D are right
  • Question 10. Make-table function What is the Table query?

    • Update data for columns in the table

    • Connect data in two tables with the same structure together
    • Create a new table from the current database
    • All is wrong

Discover more

What is Query a test for Query Query in excel Query function
Isabella Humphrey

Share by

Isabella Humphrey
Update 24 May 2019

You should read it