1, in the database technology, independent of the computer system model is _c__. A, Object-oriented model B, relational model C, E-R model D, hierarchical model
2, the control center of database system is __b_. A, database, B, database management system C, database administrator D, database application system
3. Use SQL command to increase the value of the age of the student in the student table student by 1 years, the command that should be used is __c_.
A, UPDATE SET age with Age+1 B, REPLACE age with age+1
C, update STUDENT SET age=age+1 D, update STUDENT age with age+1
4, in the relational database, when the database table is established, the restriction of age field value to 12~40岁 is __b__.
A, view integrity constraints B, domain integrity constraints C, referential integrity constraints D, Entity integrity constraints
5. In an SQL statement, an expression equivalent to X BETWEEN and 30 is __d_. A, x>=20 and x<30
B, x>20 and x<30 C, x>20 and x<=30 D, x>=20 and x<=30
6, in the database, the conceptual model is _d__.
A, for real-world modeling, with specific DBMS
B, modeling for the information world, related to specific DBMS
C, for real-world modeling, regardless of the specific DBMS
D, modeling for the information world, regardless of the specific DBMS
7, the database of concurrent operations may bring problems, including __b_. A illegal user's use B loss update C data independence will increase d increase data redundancy
8, in the relational database, the pattern corresponds to the __a___. A, view and all basic table B, view and partial basic table C, basic table D, index
9, to achieve absolute platform-independent web database access technology is _d_. A, ADO B, ActiveX C, Webbaseapi D, JDBC
10, in the following description, the correct description is __b___. A, SQL is a procedural language B, SQL using Database selection problem
1, in the database technology, independent of the computer system model is _c__. A, Object-oriented model B, relational model C, E-R model D, hierarchical model
2, the control center of database system is __b_. A, database, B, database management system C, database administrator D, database application system
3. Use SQL command to increase the value of the age of the student in the student table student by 1 years, the command that should be used is __c_.
A, UPDATE SET age with Age+1 B, REPLACE age with age+1
C, update STUDENT SET age=age+1 D, update STUDENT age with age+1
4, in the relational database, when the database table is established, the restriction of age field value to 12~40岁 is __b__.
A, view integrity constraints B, domain integrity constraints C, referential integrity constraints D, Entity integrity constraints
5. In an SQL statement, an expression equivalent to X BETWEEN and 30 is __d_. A, x>=20 and x<30
B, x>20 and x<30 C, x>20 and x<=30 D, x>=20 and x<=30
6, in the database, the conceptual model is _d__. A, for the modeling of the reality, with the specific DBMS about B, modeling for the information world, related to the specific DBMS C, for the modeling of the reality, with the specific DBMS-independent d, for the information world model, and the specific DBMS Independent
7, the database of concurrent operations may bring problems, including __b_. A illegal user's use B loss update C data independence will increase d increase data redundancy
8, in the relational database, the pattern corresponds to the __a___. A, view and all basic table B, view and partial basic table C, basic table D, index
9, to achieve absolute platform-independent web database access technology is _d_. A, ADO B, ActiveX C, Webbaseapi D, JDBC
10, in the following description, the correct description is __b___. A, SQL is a kind of procedural language B, SQL set operation mode
C, SQL can not be embedded in the high-level language program D, SQL is a DBMS 11, the database system is composed of __a__. A, database, database management system and user B, data files, command files and reports C, database file structure and data D, constants, variables and functions
12. In SQL queries, the WHERE clause is used to indicate __b__. A, query target B, query criteria C, query view D, query results
13, in the following Rdmbs products, belonging to the small database system is _a_. A, Access B, Oracle C, Sybase D, Informix
14, the database type is according to _a_ to divide. A, data Model B, record form C, data access method D, file format
15. The _a_ database, one of the members of the Microsoft Office family, is able to share data resources with other Office components for data exchange, making it easy to generate an office automation system that integrates word processing, graph generation, and data management. A, Access B, Oracle C, Sybase D, Informix
16, database management system is more suitable for the application of _d_. A, CAD B, Process Control C, Scientific computing D, data processing
17. The following four groups of SQL commands, all of which belong to the data definition statement, are _c__. A, Create,drop,alter
B, Create,drop,update C, Create,drop,grant D, Create,drop,select
18, through the Internet and browser processing database, should be _c__ processing. A, centralized B, distributed C, master-slave structure D, above 3 kinds of models
19, the logical independence of the data refers to the __d_. A, logical independence of data and storage structure B, logical independence between data elements
C, logical independence of storage structure and physical structure D, logic independence of data and program
20, in the database technology, independent of the computer system model is _c__. A object-oriented model B relation model C, E-R model D, hierarchical model
21, the 3 basic operations of relational algebra are –d–, projection, and connection. A, relationship and B, implication C, relationship or D, choice
22, the following proposition is not correct is d:a, if the redundant data can be controlled, the data update consistency to ensure
B, the database reduces unnecessary data redundancy C, database data can be shared D, data redundancy does not exist in the database
23. Cannot be implemented in basic SQL: B A, define view B, concurrency control C, define base table D, query view and base table
24. The data model of the relation between entity and entity is called _c___ by using two-dimensional table.
A, Entity – Contact Model B, hierarchical model C, relationship model D, mesh model
25, look for wages in more than 600 yuan and the title for the engineer's record, the logical expression for _d___.
A, "wages" >600. Or. title = "Engineer" B, salary >600. and. title = Engineer
C, "salary" >600. and. "Professional title" = "Engineer" D, salary >600. title = "Engineer"
26, database mirroring can be used for __c_. (1 points)
A, the implementation of database security B, to achieve data sharing C, database recovery or concurrent operation D, to ensure the integrity of the database
27, in the following types of database systems, the most widely used is __c___. (1 points)
A, distributed database system B, logical database system C, relational database system D, hierarchical database system
28, in the following description, the correct description is __b__. (1 points)
A, SQL is a procedural language B, SQL adopt set operation mode C, SQL can not be embedded in the high-level language program D, SQL is a DBMS
