Second-level ACCESS exams (3) and answers

I. multiple choice question (1) the space complexity of the algorithm refers to A) The length of the algorithm program B) the number of commands in the algorithm program C) the storage space occupied by the algorithm program D) the storage space required during execution (2) the advantage of using A linked list to represent A linear table is that A facilitates random access B) the storage space consumed is less than the sequential storage space C) easy insert and delete operations D) count

I. multiple choice question (1) the space complexity of the algorithm refers to A) The length of the algorithm program B) the number of commands in the algorithm program C) the storage space occupied by the algorithm program D) the storage space required during execution (2) the advantage of using A linked list to represent A linear table is that A facilitates random access B) the storage space consumed is less than the sequential storage space C) easy insert and delete operations D) count

I. multiple choice questions

(1) The spatial complexity of the algorithm refers
A) Length of the Algorithm Program
B) Number of commands in an algorithm program
C) storage space occupied by algorithm programs
D) storage space required during execution

(2) the advantage of using a linked list to represent a linear table is
A) convenient Random Access
B) less storage space consumed than sequential Storage
C) Easy insert and delete operations
D) The physical sequence of data elements is the same as the logical sequence.

(3) In the data structure, data is irrelevant to the computer in use.
A) Storage Structure
B) Physical Structure
C) Logical Structure
D) Physical and storage structures

(4) Structured Program Design emphasizes
A) Program Scale
B) Program Efficiency
C) Advanced Programming Language
D) easy to program

(5) software design includes the structure, data interface, and process design of the software. The process design of the software refers
A) Relationship between modules
B) process description of Converting System structural components into software
C) software hierarchy
D) software development process

(6) The process of checking whether the software product meets the requirement definition is called
A) confirm the test
B) Integration Testing
C) Verification Test
D) Acceptance Test

(7) A data flow diagram is used to abstract the logic model of a software. A data flow diagram consists of some specific symbols. Which of the following is not a valid identifier of a data flow chart?
A) Control Flow
B) Processing
C) Data Storage
D) source and Lake

(8) The main purpose of the application database is
A) solve data confidentiality issues
B) solve data integrity problems
C) solve the Data Sharing Problem
D) solve the problem of large data volume

(9) In the database design, the process of converting the E-R diagram Into the relational data model belongs
A) Demand analysis stage
B) Logic Design Stage
C) Concept Design Stage
D) Physical Design Stage

(10) The development of data management technology has gone through the manual management, file system, and database system stages. The Highest Stage of Data independence is
A) Database System
B) File System
C) manual management
D) data item management

[1] [2] [3] [4] [5] Next page

11) the relationship between DB (database), DBS (Database System), and DBMS (Database Management System) is
A) DBS include DB and DBMS
B) DBMS includes DB and DBS
C) DB includes DBS and DBMS
D) DBS equals DB equals DBMS

(12) The data model shown in

A) Hierarchical Model
B) relational model
C) mesh model
D) None of the above

(13) which of the following relational models is inaccurate?
A) record, A two-dimensional table that meets certain standardization requirements, also known as A link
B) field, a column in the orders table
C) The data item and component quantity are the values of one field in no record.
D) field value range, also known as attribute Field

(14) using the same field "Fasten", the relationship between table 1 and table 2 is

A) one-to-one
B) many-to-one
B) One to multiple
C) many-to-many

(15) use SQL to describe "Search for all information about male teachers in the instructor table". Which of the following statements is true?
A) select from instructor table IF (Gender = 'male ')
B) SELECT gender FROM instructor table IF (Gender = 'male ')
C) SELECT * FROM instructor table WHERE (Gender = 'male ')
D) SELECT * FROM gender WHERE (Gender = 'male ')

(16) The input mask that converts all characters to uppercase is
A)>
B) <
C) 0
D)

(17) The relationship between tables in Access is defined
A) one-to-many relationship
B) many-to-many relationships
C) one-to-one relationship
D) Multi-to-one relationship

(18) which of the following operations are queried?
① Delete a query
② Update Query
③ Cross tabulation Query
④ Append Query
⑤ Generate Table query
A) ① ② ③ ④
B) ② ③ ⑤
C) ③ ④ ①
D) ④ ① ②

(19) which query will bring up a dialog box during execution, prompting the user to enter necessary information and then follow the information for query?
A) Select Query
B) parameter query
C) cross tabulation Query
D) operation Query

(20) functions supported by queries include:
A) Select fields, select records, edit records, implement calculation, create A new table, and create A database.
B) Select fields, select records, edit records, implement calculation, create new tables, and update relationships.
C) Select fields, select records, edit records, perform calculation, create a new table, and set the format.
D) Select fields, select records, edit records, implement computation, create new tables, and create query-based reports and forms.

Previous Page [1] [2] [3] [4] [5] Next page

(21) The meaning of the special operator "ln" is
A) It is used to specify the range of A field value. And is used to connect the specified range.
B) It is used to specify a list of field values. Any value in the list can match the queried field.
C) specify a field that is null.
D) specify a field that is not empty.

(22) In the following example, the function of the criterion is:
A) query the employees who participated in the work before January 1, January.
B) query the employees who joined the work after January 1, December
C. query the employees who have joined the work for 99 years
D. query the employees who participated in the work in January and February.

(23) The information in the form does not include
A) Some tips that the designer attaches to the design window
B) important information entered by the designer during the design window
C) records of the processed table
D) records processed for query

(24) The Window used to create or modify a form is
A) design view
B) Form View
C) data table View
D) Pivot Table View

(25) The type of controls that do not have data sources and can be used to display information, lines, rectangles, or images is
A) Combination Type
B) unbound
C) computing type
D) Non-computing type

(26) which of the following statements do not belong to the control format attribute?
A) Title
B) Text
C) font size
D) font width

(27) A mouse event is an event triggered by a mouse operation. Which of the following events does not belong to a mouse event?
A) "press the mouse"
B) "move the mouse"
C) "Release the mouse"
D) "Mouse lock"

(28) which of the following statements about data source settings in report properties are true?
A) It can only be A table object.
B) only query objects
C) It can be either a table object or a query object.
D) None of the above statements are correct.

(29) The report header in the report is used
A) display the field name in the report or the group name of the record
B) display the report title, drawing, or descriptive text
C) display the summary on this page
D) display the summary of the entire report

(30) determine the type of the following report

A) Vertical Column report
B) Table-based reports
C) Chart reports
D) label report

Previous Page [1] [2] [3] [4] [5] Next page

(31) data access pages can be viewed in two ways:
A) design view and data table View
B) design view