Beida Jade Bird Second semester 123 chapters database choice problem

1 The first chapter:

1. Suppose that a teacher can teach multiple courses, one course can be taught by several teachers, and between teachers and courses: C

A. One-to-one relationship B. One-to-many relationship c. Many-to-many relationships D. Many-to-many relationships

2. In the E-r diagram, a long provide NdFeB and an ellipse are used to denote C

A. Contact, attribute b. Attribute, entity C. Entity, attribute D. Properties, contact

3. The graph used to represent the relationship between database entities is a

A. Entity Relationship B. Data Model Diagram C. Entity Classification Diagram D. None of the above

4 the so-called entity refers to the real world with the distinction between the characteristics of other things or attributes, and other entities associated with the object, right? A

A To B. Wrong

5. The following are valid mapping constraints. D

A Many-to-many B. Many to one C. One to the other D. above are

6. With regard to the design paradigm of the database, the following statement is wrong C

A The design paradigm of the database helps standardize the design of the database B. The design paradigm of the database helps reduce data redundancy C. When designing a database, you must strictly abide by the design paradigm. The higher the pattern level, the better the system performance

Chapter II:

1. The following () stored procedure is used to add a database security account and grant it access rights. A

A.sp_grandbaccess B. sp_grantlogin C. Sp_grantuser D Sp_grantall

2. After successfully logging into SQL Server, you can access any database, which is a

A Error B. That's right

3. When creating data, you need to specify the (C) attribute

A, database initial size (size) B. The physical and logical name of the database where the database is stored E. Access rights to the database

4. When creating a book loan form, the "Return date" defaults to the current day and must be later than the "borrowing date" and shall be subject to (A)

A Check constraint B. Default constraint C. PRIMARY KEY constraint D. FOREIGN KEY constraints

5. A field that wants to hold the phone number, the paragraph should use (B) data type

A char (B.varchar) C.text D.int

6 in SQL Server, delete the database using the (D) statement

A REMOVE B DELETE C akert D DROP

Chapter III

1 batch processing is a collection of one or more SQL statements sent by a unit, which is said (A)

A Yes, B wrong.

2 users can define local variables, or they can define global variables, which is said (B)

A to B wrong

3 the following (B) statements can be used to exit from a while statement block

A CLOSE B break C more than D is not

4 to execute a set of statements 10 times, the following (B) structure can be used to accomplish this task.

A IF? ELSE B and C case D are not

5 when assigning a value to a variable, the resulting data is derived from a column in the table, and (a) should be used

A SELECT B Print C SET

6 run the following statement in a new query in SQL Server, resulting in (D)

CREATE TABLE numbers (N1 int N2 numberic (5,0) N3 numberic (4,2))

Go Insert numbers VALUES (1.5,1.5,1.5) Select * from numbers

A returns 2, 2, and 1.50 for record B returns 1.5, 1.5, and 1.5 for Recordset C The CREATE TABLE command does not execute because the column N2 cannot be set to a precision of 0
D returns recordsets for 1, 2, and 1.50

Beida Jade Bird Second semester 123 chapters database choice problem