Home Tech info Quiz technology

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.

  1. Question 1. Which dialog box will appear when we run the query?
    Picture 1 of The multiple-choice question set has an answer to Query P1
    1. Update Query

    2. Make-Table Query

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

    1. Update Query

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

    1. FCode, GCode, FnameinVN

    2. FCode, GCode, FnameinVN, FnameinE

    3. FCode, GCode, FnameinE

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

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

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

    1. File Update Query

    2. View Update Query

    3. Query Update Query

    4. Click the Query Type icon on the toolbar, select Update

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

    1. Update data for columns in the table

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

You've just finished reading the article "The multiple-choice question set has an answer to Query P1" edited by the TipsMake team. You can save the-multiplechoice-question-set-has-an-answer-to-query-p1.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

What is Query a test for Query Query in excel Query function
« PREV Your understanding of P7 computer hardware
NEXT » What do you know about software technology P5
Read more