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
Update 24 May 2019
What is Querya test for QueryQuery in excelQuery function

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile