In September, 2008, the second-level written examination paper of the National Computer Rank Examination.
Visual FoxPro database programming
(Examination time is 90 minutes, full mark 100)
First, multiple-choice questions (2 points for each small question, 70 points for * * *)
Of the following four options a), b), c) and d), only one option is correct. Please scribble the correct options on the answer sheet, and the answers will not be scored on the test paper.
The initial state of the (1) stack is empty. Now, the elements 1, 2, 3, 4, 5, A, B, C, D and E are put on the stack in turn, and then released from the stack in turn, so the order of the elements is as follows.
a) 12345 abcde B)edcba 5432 1
c)abcde 12345D)5432 1 edcba
(2) The following statement is correct.
A) The circular queue has two pointers, a head and a tail, so the circular queue is nonlinear.
B) In a circular queue, only the queue head pointer is needed to reflect the dynamic changes of the elements in the queue.
C) In a circular queue, only the tail pointer is needed to reflect the dynamic changes of the elements in the queue.
D) The number of elements in the circular queue is determined by the queue head and queue tail pointers.
(3) method of bisection in an ordered linear table of length n, the worst-case number of comparisons is
a)O(N)B)O(N2)C)O(log2n)D)O(N log2n)
(4) The following statement is correct.
A) The storage of sequential storage structure must be continuous, and the storage space of chain storage structure is not necessarily continuous.
B) Sequential storage structure is only for linear structure, and chain storage structure is only for nonlinear structure.
C) Sequential storage structures can store ordered tables, but chain storage structures cannot.
D) Chain storage structure saves storage space than sequential storage structure.
(5) The line segments with arrows in the data flow diagram represent
A) control flow b) event drive c) module call d) data flow
(6) In software development, the tools that can be used in the requirements analysis stage are
A)N-S diagram B)DFD diagram c) pad diagram d) program flow chart
(7) In the object-oriented method, what is not the basic feature of "object"?
A) consistency b) classification c) polymorphism d) uniqueness of identification
(8) A dormitory can accommodate multiple students, so the connection between the physical dormitory and the students is
A) one to one b) one to many c) many to one d) many to many.
(9) In the three stages of data management technology development, data * * * enjoys the best position.
A) manual management stage b) file system stage
C) Database system stage d) The three stages are the same.
(10)R, s and t have the following three relationships:
B.C.
m 1 3
R S T
A b
m 1
nitrogen
B.C.
1 3
3 5
If the relation T is obtained from the relations R and S by operation, the operation used is
A) cartesian product b) intersection c) and d) natural connection.
(1 1) Set the properties of the form title as follows.
A) title b) text c) tag d) title
(12) The way to release and close the form is
A) release b) delete c) lose focus d) destroy.
(13) The operation of selecting fields from the table to form a new relationship is
A) choose b) connect c) items d) and.
(14) The default extension of files created by the Modify command is
A)prg B)app C)cmd D)exe
(15) After describing the array, the initial values of the array elements are
A) integer 0 B) indefinite value c) logical truth d) logical false
(16) The file with mpr extension is
A) menu file b) menu program file c) menu comment file d) menu parameter file
(17) After executing the following program segment, the value of the memory variable y is
x=76543
y=0
DO WHILE x & gt0
y=x% 10+y* 10
x=int(x/ 10)
Endor
A)3456 B)34567 C)7654 D)76543
(18) In SQL SELECT query, you should use phrases to sort the query results.
A)ASC B)DESC C) grouping basis d) sorting basis
(19) Let A be "Computer Grade Examination" and the result is expressed as "Examination"
A) left (a, 4) B) right (a, 4) C) left (a, 2) D) right (a, 2)
(20) Regarding opinions and questions, the following statement is correct.
A) Views and queries can only be created in the database.
B) Neither the view nor the query can be established in the database.
C) Views can only be created in the database.
D) Queries can only be established in the database.
(2 1) the phrase equivalent to INTO TABLE in SQL SELECT statement is
A) transfer to DBF B) transfer to table c) transfer to FOEM D) transfer to file.
22)22) Create database command is used to create
A) database b) relationship c) table d) data file
(23) to execute the program temp.prg, the command that should be executed is
A)DO PRG temp.prg B)DO temp.prg
C)DO CMD temporary program D)DO FORM temporary program
(24) execute the command myform = createobject ("form ") to create a form. In order to display the form on the screen, you should execute the command.
My form. List b) My forms. show
C) my form. Show d) my form. Display form
(25) If there is a student table, the command to correctly add the field "average score" is
A) average score a) students who modify the form add F(6.2)
B) change DBF students to add an average score of F 6,2.
C) Average score C) Change table students plus F (6,2)
D)D) The average score of student insertion in the change table is 6.2.
(26) Page frame controls are also called tab controls. There can be multiple pages in a page frame. The attribute of pages is
A) Count B) Pages C) Quantity D) Pages
(27) the command to open an existing form file is
A) modify the form b) edit the form
C) open the form d) read the form.
(28) In menu design, you can specify the access keys of menu items when defining the menu name. The menu name with the access key "X" for the specified menu item is defined as
A) comprehensive query \
C) comprehensive query (\
(29) suppose a form has a text box Text 1 and a command button group CommandGroup 1. A command button group is a container object, which contains two command buttons, Command 1 and Command2. If you want to access the Value property value of the text box in the method of the Command 1 command button, the correct expression is
A) this. ThisForm.Text 1。 Value b) this. Parent.Parent.Text 1。 value
C) parents. Parent.Text 1。 Value d) this. Parent.Text 1。 value
(30) In the following statement about the data environment and the association between two tables in the data environment, it is true that
A) The data environment is an object, and the relationship is not an object.
B) The data environment is not an object, but a relationship is an object.
C) The data environment is an object, and the relationship is an object in the data environment.
D) Data environments and relationships are not objects.
(31) ~ (35) Use the following relationship:
Customer (customer number, name, contact person, postal code, telephone number)
Product (product number, name, specification, unit price)
Purchase order (order number, customer number, order date)
Name of purchase order (order number, serial number, product number, quantity)
(3 1) The correct command to query motherboards and hard disks with unit price above 600 yuan is
A) select * from products with unit price > 600 and (name = "motherboard" and name = "hard disk")
B) Select * from products with unit price > 600 and (name = "motherboard" or "hard disk").
C) Select * from products with unit price > 600 and (name = "motherboard" and name = "hard disk")
D) Select * from products with unit price > 600 and (name =' motherboard' or name =' hard disk').
(32) The correct command to query the customer information with the word "network" in the customer name is
A) select * FROM customer as the name, such as "%network%"
B) select * FROM customer for name = "%network% "
c)SELECT * FROM customer WHERE name = " % network % "
D)SELECT * FROM customer, where the name is similar to "%network%"
(33) the correct command to query the relevant information of pending purchase orders is
A) Select name, contact person, telephone number, customer order number and purchase order.
Where are the customers. Customer number = purchase order. Customer number and order date are empty.
B) Select name, contact person, telephone number, customer order number and purchase order.
Where are the customers. Customer number = purchase order. Customer number and order date = empty.
C) Select name, contact person, telephone number, customer order number and purchase order.
For customers. Customer number = purchase order. Customer number and order date are empty.
D) Select name, contact person, telephone number, customer order number and purchase order.
For customers. Customer number = purchase order. Customer number and order date = empty.
(34) the correct command to query the purchase order quantity and the average amount of all purchase orders is
A) select count (unique order number), AVG (quantity * unit price)
Add purchase order name details on the product from the product. Product Number = Purchase Order Name Details. Product number
B) select the count (order number), AVG (quantity * unit price)
Add purchase order name details on the product from the product. Product Number = Purchase Order Name Details. Product number
C) Select Count (unique order number), AVG (quantity * unit price)
From the product, the purchase order name is good on the product. Product number = purchase order name. Product number
D) select the count (order number), AVG (quantity * unit price)
From the product, the purchase order name is good on the product. Product number = purchase order name. Product number
(35) Suppose there are customer records with customer number (keyword) of C1~ C10 * *10 in the customer table, and there are eight purchase order records with order number (keyword) of or 1 ~ or8 * * in the purchase order table. The following commands can be executed correctly.
A) insert the purchase order value ('or5',' C5', {2008/10//kloc-0})
B) insert the purchase order value ('or5',' c 1 1', {2008/10})
C) insert the purchase order value ('or9',' c 1 1', {2008/10/0}).
D) Insert the purchase order value ('or9',' C5', {2008/10//kloc-0})
Fill in the blanks (2 points for each blank, 30 points for * * *)
Please write each blank correct answer on the horizontal line with the serial number from 1 to 15 on the answer sheet, and the answer will not be scored on the test paper.
Note: command keywords must be spelled completely.
(1) The result of traversing the following binary tree in intermediate order is 1.
(2) According to the general steps of software testing, the integration test should be carried out after two tests.
(3) The three elements of software engineering include methods, tools and processes, among which, 3 supports the control and management of all aspects of software development.
(4) Database design includes conceptual design, 4 and physical design.
(5) In a two-dimensional table, 5 of a tuple cannot be divided into smaller data items.
(6) the select * from student6file student command stores the query results in the student.txt text file.
(7) The calculation result of left ("12345.6789", len ("substring ")) is 7.
(8) The unconditional SQL DELETE command will delete 8 records of the specified table.
(9) In the SQL SELECT statement, nine phrases should be used in order to store the query results in a temporary table.
(10) Each database table can have multiple indexes, but 10 indexes can only have 1 indexes.
(1 1) Views and queries can be designed in the database, where 1 1 cannot be independently stored as files (stored in the database).
(12) A set of check box controls are designed in the form. You can choose 12 or 13.
(13) In order to hide information (such as displaying "*") when entering a text box, you need to set the 14 property of the control.
(14) When compiling a project into an application, if the application contains files that need to be modified by users, it must be marked as 15.
September 2008 National Computer Rank Examination Level 2 VFP Written Test Reference Answer
First, multiple choice questions
1-5 BDCAD
6- 10 BABCD
1 1- 15 DACAD
16-20 BBDBC
2 1-25 AABCA
26-30 BC
3 1-35 BDAAD
Second, fill in the blanks
1、DBXEAYFZC
2. Unit
3. Process
4. Logic design
Step 5: ingredients
6. To
7、" 1234 "
8. All
9, enter the cursor
10, mainly
1 1, view
12, zero
13, double
14, password characters
15, excluding
In September, 2007, the second-level VFP written test paper of the National Computer Rank Examination.
First, multiple-choice questions (2 points for each small question, 70 points)
Only one of the following four options (a), (b), (c) and (d) is correct. Please mark the correct options in the corresponding position on the answer sheet, and the answers will not be scored on the test paper.
(1) software refers to
A) procedures b) procedures and documents
C) Algorithm plus data structure d) Complete set of programs, data and related documents.
(2) The purpose of software debugging is
A) find out the mistakes b) correct them.
C) Improve the performance of the software d) Verify the correctness of the software.
(3) In the object-oriented method, information hiding depends on
A) inheritance of objects b) polymorphism of objects
C) encapsulation of objects d) classification of objects
(4) In the following statements, what does not meet the requirements of good programming style is
A) the efficiency of the program is the first, and the clarity is the second; The program is readable.
C) There should be necessary comments in the program d) There should be prompt information before data input.
(5) The following statement is correct.
A) The efficiency of program execution is closely related to the storage structure of data.
B) The efficiency of program execution only depends on the control structure of the program.
C) The efficiency of program execution only depends on the amount of data processed.
D) None of the above three statements is correct.
(6) The following statement is correct
A) The logical structure and storage structure of data must be one-to-one.
B) Because the computer storage space is a vector storage structure, the data storage structure must be a linear structure.
C) Arrays in programming languages are generally sequential storage structures, so arrays can only be used to deal with linear structures.
D) None of the above three statements is correct.
(7) In the worst case, the comparison time of bubble sorting is
a)n(n+ 1)/2 B)nlog 2n C)n(n- 1)/2d)n/2
(8) There are 70 leaf nodes and 80 nodes with degree 1 in the binary tree, so the summary points in the binary tree are
a)2 19 B)22 1 C)229D)23 1
(9) The following statement is correct.
A) The database system is an independent system and does not need the support of the operating system.
B) The fundamental goal of database technology is to solve the problem of data sharing.
C) The database management system is a database system.
D) None of the above three statements is correct.
(10) The following statement is correct.
A) In order to establish the relationship, we must first construct the logical relationship of data.
B) Each component of each tuple in a two-dimensional table representing relationships can also be divided into several data items.
C) The attribute list of a relationship is called a relationship pattern.
D) A relationship can include multiple two-dimensional tables.
(1 1) usually appears in the form of a window in Visual Foxpro, and the visualization tools used to create and modify application components such as tables, forms and databases are called.
A) guide b) designer c) generator d) project manager
(12) command? The result of VARTYPE(TIME ()) is
A)C B)D C)T D) error.
(13) command? The result of LEN (space (3)- space (2)) is
1 B)2 C)3 D)5
(14) In Visual Foxpro, the default extension of menu program files is
A)mnx B)mnt C)mpr D)prg
(15) If you want to display the year in date or date-time data with 4 digits, you should use the setting command.
A) turn on the century b) turn off the century
C) Set the century to 4 D) Set the century to 4.
(16) It is known that there are character fields such as title and surname in the table. To build an index, it is required to sort by title first, and then sort by gender when the titles are the same. The correct command is
A) index of professional title+gender and ttt b) index of gender+professional title and ttt
C) Indicators on professional title, gender and technology transfer
(17) In Visual Foxpro, the trigger time of the Unload event is
A) release the form b) open the form.
C) Create the form d) Run the form.
(18) The function of selecting the 0 command is
A) Select the unused workspace with the lowest number b) Select the workspace No.0.
C) Close the table of the current workspace d) Select the current workspace.
(19) The following statements about database tables and free tables are incorrect.
A) Both database tables and free tables can be created with table designer.
B) Both database tables and free tables support inter-table association and referential integrity.
C) Free tables can be added to the database to become database tables.
D) Database tables can be moved out of the database and become free tables.
(20) The description of the ZAP command is correct.
A) The A)ZAP command can only delete the current record of the current table.
B) The B)ZAP command can only delete records marked for deletion in the current table.
C) The C)ZAP command can delete all records in the current table.
D) The D)ZAP command can delete the table structure and all records.
(2 1) The tabs that are available in the View Designer but not in the Query Designer are
A) Sort by b) Update condition c) Group by d) Miscellaneous
(22) When creating a query using Query Designer, in order to specify whether duplicate records (corresponding to DISTINCT) are included in the query results, the tags that should be used are
A) Sort by b) Join c) Filter d) Other
(23) In Visual Foxpro, the return statement of the procedure is
A) go back b) come back c) come back d) come back.
(24) The validity rules of fields in database tables are as follows
A) logical expression b) character expression
C) numerical expression d) all three above are possible.
(25) Suppose that in the form designer environment, there is a text box in the form and it has been selected as the current object. Now select the Value attribute from the properties window, and then enter = {2001-9-10}-{2001-8-20} in the setting box. Excuse me, after the above operation, the data type of the Value attribute of the text box is:
A) Date type b) Numeric type c) Character type d) Errors in the above operations.
(26) In the SQL SELECT statement, phrases should be used to store the query results in a temporary table.
A) to cursor b) to cursor
C) to DBF D) to DBF
(27) In form design, some specific keywords, attributes and events are often used. The following items are attributes.
A) This b) This form c) Title d) Click.
(28) The following procedure calculates the sum of all digits of an integer. The statements that should be underlined are
Stop the conversation
Enter "x=" to x.
s=0
Do WHILE x! =0
s=s+MOD(x， 10)
Endor
s
Start a conversation
a)x = int(x/ 10)B)x = int(x % 10)C)x = x-int(x/ 10)D)x = x-int(x % 10)
(29) In the ALTER TABLE statement of SQL, you should use phrases to add new fields.
A) Create b) Add c) Column d) Add
Questions (30) to (35) use the following data table:
student DBF: Student ID (c, 8), name (c, 6), gender (c, 2), date of birth (d).
Choose courses. DBF: student number (c, 8), course number (c, 3) and grade (n, 5 1).
(30) To query all students born after 1982 (inclusive), the correct SQL statement is
A) select * the place where the students were born > = {1982-03-20} and gender = "male"
B) select * the student's birthplace < = {1982-03-20} and gender = "male".
C) choose * student's birthplace > = {1982-03-20} or gender = "male"
D) select * the student's birthplace < = {1982-03-20} or gender = "male".
(3 1) Calculate the average scores of all courses that Liu Ming has taken. The correct SQL statement is
A) select AVG from the course selection, where name = "Liu Ming "
B) choose AVG from students and choose courses, where name = "Liu Ming "
C) Choose AVG from the students and choose the place where the students are. Name = "Liu Ming"
D) Choose AVG (Grade) from the students, and students can choose courses here. Student number = course selection. Student ID and Name = "Liu Ming"
(32) Assume that the third and fourth digits of the student number are professional codes. To calculate the average score of the elective course number "10 1" for students of various majors, the correct SQL statement is
A) Select the major as SUBS (student number, 3,2), with an average score of AVG (grade), in which the course number is = "10/"grouped by major.
B) Select SUBS (student number, 3,2) as the major and AVG (grade) as the average score, in which the course number = "10 1" is grouped by 1.
C) Select SUBS (student number, 3,2) as the major and AVG (grade) as the average score, in which the course number = "10 1" is sorted by major.
D) Select ASSUB (student number, 3,2), with an average score of AS AVG (grade), where the course number = "1 01"is sorted by1.
(33) Query the students with the highest scores in the elective course number "10 1". The correct SQL statement is
A) select students. Student ID, student name, and the location where the student was selected. Student number = course selection. Student ID and course number = "10 1" and score > = all (choose score from course selection).
B) select students. Student ID, student name, and the location where the student was selected. Student number = course selection. Student number and grade > = all (choose the score from the course number = "10 1")
C) select students. Student number, student name, and the location where the student was selected. Student number = course selection. Student number and grade > = any (choose the score from the course number = "10 1")
D) select students. Student ID, student name, and the location where the student was selected. Student number = course selection. Student ID and course number = "10 1" and score > = all (choose a score from course number = "10/").
(34) Insert a record in the Course Selection table. The student number, course number and grade are "0208011","103" and 80 respectively. The correct SQL statement is
A) Insert the course value ("0208011","103", 80).
B) Insert the value ("0208011","103", 80) to select the course (student number, course number, grade).
C) Insert values ("0208011","103", 80) into the course selection (student number, course number, grade).
D) Insert the form values of course selection (student number, course number and grade) ("0208011","103", 80).
(35) Change the record score of course selection with student number "02080 1 10" and course number "102" to 92. The correct SQL statement is
A)A) update the level of the course set with 92, where the student number = "02080 1 10 "and the course number =" 102 "
B) The score of the updated curriculum is 92, in which the student number is "02080110, and the course number is"102 ".
C) update the course setting score with 92, in which the student number = "02080 1 10 "and the course number =" 102 ".
D) update from the course setting score =92, in which the student number = "02080 1 10 "and the course number =" 102 ".
Fill in the blanks (2 points for each blank, 30 points for * * *)
Please write each blank correct answer on the horizontal line with the serial number 1 ~ 15 on the answer sheet, and the answer will not be scored on the test paper.
Note: if you fill in the blanks with command keywords, you must spell them completely.
(1) Software requirements specifications should be complete, clear, correct, verifiable and modifiable, among which 1 is the most important.
(2) Among the two basic testing methods, one of the principles of 2-test is to ensure that each independent path in the module under test is executed at least once.
(3) The storage structure of linear tables is mainly divided into sequential storage structure and chain storage structure. Queue is a special linear table, and circular queue is a three-level storage structure of queue.
(4) The middle order traversal result of the following ambiguity tree is 4.
(5) In the E-R diagram, the rectangle represents 5.
(6) The following command is used to query that the field in the employee table of "department number" in the record is empty.
SELECT * FROM employee's department number 6.
(7) In SQL SELECT query, the HAVING statement cannot be used alone, but always used together after clause 7.
(8) In SQL SELECT query, clause 8 is used to eliminate duplicate records in query results.
(The non-SQL command to modify the table structure in Visual FoxPro is 9.
(10) In Visual FoxPro, the first form event raised when running a form is the 10 event.
(1 1) In Visual FoxPro, use the LOCATE ALL command to search the records in the table according to the conditions. If no record is found, the return value of function e of () should be 1 1.
(12) In the Visual FoxPro form, when the user clicks the command button with the mouse, the 12 event of the command button will be triggered.
(13) In Visual FoxPro, suppose there is an option group on the form: ○ male ○ female, and the Value of the value attribute of this option group is assigned to 0. When the first option button "Male" is selected, the Value attribute value of this option group is 13.
(14) In the Visual FoxPro form, the property used to determine whether the check box is selected is 14.
(15) In SQL, the INSERT, DELETE and update commands are insert, delete and 15.
September 2007 National Computer Rank Examination Level 2 VFP Reference Answer
First, multiple-choice questions:
1-5 DBCAA
5- 10 CCABA
1 1- 15 badka
16-20 AAABC
2 1-25 BDCAA
26-30 BC
3 1-35 DBDAB
Second, fill in the blanks:
1, ambiguity
2. White box testing
Step 3 order
4、ACBDFEHGP
5. Entity Set
6) is empty
7) Grouping basis
8) Unique
9) Modify the structure
10) load
1 1)。
12) Click
13) 1 or "male"
14) value
15) update