Computer postgraduate entrance examination database question bank

Database question bank

List of topics - Computer postgraduate entrance examination professional question bank

In the development of data management technology , The most independent data is （ ） Stage .__N Nuo computer postgraduate entrance examination

[ database P1000]  In the development of data management technology , The most independent data is （ ） Stage .

In the development of data management technology , The most independent data is （    ） Stage .

A. Database system  B. file system  C. Manual management  D. Data item management

（ ） It is a structured data set stored in the computer .__N Nuo computer postgraduate entrance examination

[ database P1001] （ ） It is a structured data set stored in the computer .

（    ） It is a structured data set stored in the computer .

A. Network system  B. Database system  C. operating system  D. database

In the three-level schema structure of the database , Describing the global logical structure and characteristics of all data in the database is __N Nuo computer postgraduate entrance examination

[ database P1002]  In the three-level schema structure of the database , Describing the global logical structure and characteristics of all data in the database is

In the three-level schema structure of the database , Describing the global logical structure and characteristics of all data in the database is （    ）.

A. External mode  B. Internal mode  C. Storage mode  D. Pattern

As a relational data system , The minimum required relational operation is （ ）.__N Nuo computer postgraduate entrance examination

[ database P1003]  As a relational data system , The minimum required relational operation is （ ）.

As a relational data system , The minimum required relational operation is （    ）.

A. Sort 、 Indexes 、 Statistics  B. choice 、 Projection 、 Connect

C. relation 、 to update 、 Sort  D. Show 、 Print 、 Tabulation

stay select Use in statement group by Sno when ,Sno Must appear in （ ） clause .__N Nuo computer postgraduate entrance examination

[ database P1004]  stay select Use in statement group by Sno when ,Sno Must appear in （ ） clause .

stay select Use in statement group by Sno when ,Sno Must appear in （    ） clause .

A. where B. from C. select D. having

stay where In the conditional expression of the statement , Wildcards that match zero or more characters are （ ）.__N Nuo computer postgraduate entrance examination

[ database P1005]  stay where In the conditional expression of the statement , Wildcards that match zero or more characters are （ ）.

stay where In the conditional expression of the statement , Wildcards that match zero or more characters are （    ）.

A. * B. ? C. % D. _

When decomposing a relational schema , To make decomposition maintain functional dependency 、 It also has loss free connectivity , In the subordinate paradigm, it can reach ( )__N Nuo computer postgraduate entrance examination

[ database P1006]  When decomposing a relational schema , To make decomposition maintain functional dependency 、 It also has loss free connectivity , In the subordinate paradigm, it can reach ( )

When decomposing a relational schema , To make decomposition maintain functional dependency 、 It also has loss free connectivity , In the subordinate paradigm, it can reach ( )

A. 2NF B. 3NF C. BCNF D. 4NF

In relation mode R（U,F） in ,Y∈XF+ yes X→Y Established or not （ ）.__N Nuo computer postgraduate entrance examination

[ database P1007]  In relation mode R（U,F） in ,Y∈XF+ yes X→Y Established or not （ ）.

In relation mode R（U,F） in ,Y∈XF+ yes X→Y Established or not （    ）.

A. Sufficient and necessary conditions  B. Necessary condition  C. sufficient condition  D. Neither sufficient nor necessary conditions

In the relational database design phase , The stage of completing the relational pattern design is （ ）.__N Nuo computer postgraduate entrance examination

[ database P1008]  In the relational database design phase , The stage of completing the relational pattern design is （ ）.

In the relational database design phase , The stage of completing the relational pattern design is （    ）.

A. Demand analysis stage  B. Conceptual design stage  C. Logic design stage  D. Physical design stage

basic E-R Figure is the database （ ）.__N Nuo computer postgraduate entrance examination

Construct from data flow graph E-R Picture time , Generally, when selecting entities, we should first consider （ ）.__N Nuo computer postgraduate entrance examination

following （ ） Not the current common access method .__N Nuo computer postgraduate entrance examination

Once the transaction is committed , Changes to the database are permanent , This is a matter of （ ）.__N Nuo computer postgraduate entrance examination

The fundamental problem of concurrency control is to maintain the state of the database （ ）__N Nuo computer postgraduate entrance examination

In the database system , The definition of access rights is called （ ）.__N Nuo computer postgraduate entrance examination

After the view is created , Stored in the data dictionary is （ ）.__N Nuo computer postgraduate entrance examination

A relational pattern consisting of full code , The highest attainable mode is （ ）.__N Nuo computer postgraduate entrance examination