网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Arelation(from the relational database model)consistsof(由⋯⋯组成)a set of tuples(元组),whichimplies(意味着)that().
A.all tuples in a relation must be distinct(独一无二的)
B.every relation has a key(键)
C.all of the above
D.for any two tuples,the values associated with one or more of thei rattributes(属性)must differ
参考答案
更多 “ Arelation(from the relational database model)consistsof(由⋯⋯组成)a set of tuples(元组),whichimplies(意味着)that(). A.all tuples in a relation must be distinct(独一无二的)B.every relation has a key(键)C.all of the aboveD.for any two tuples,the values associated with one or more of thei rattributes(属性)must differ ” 相关考题
考题
● (73) is a query language for manipulating data in a relational database.(73) A. AssembleB. SQLC. C++D. Fortran
考题
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
考题
（73)is a query language for manipulating data in a relational database.A.AssembleB.SQLC.C++D.Fortran
考题
The relational database model requires the data be(110)through programs that don't rely on the position of the data in the database. This is in direct(111)to the other database mode, where the program has to follow a series of pointers to the data it seeks. A program(112)a relational database simply asks for the data it seeks; the DBMS performs the necessary searches and(113)the information. The(114)on how the search is done are specific to the DBMS and vary from product to product.A．accessedB．movedC．readD．wrote
考题
(73) is a query language for manipulating data in a relational database.A.Assemble SX
（73） is a query language for manipulating data in a relational database.A.AssembleB.SQLC.C++D.Fortran
考题
● (73) is a query language for manipulating data in a relational database.(73)A. AssembleB．SQLC． C++D． Fortran
考题
The entity-relationship（E-R）data model is based on a perception of a real world that consists of a clletion of basic objects,called（ ），and of relationships among these objects.An entity is a“thing”or"object"in the real world that is distinguishable from other objects.Entities are described in a database by asetof（ ）:A relationship isan association among several entities.The set of all entities of the same type and the set of all relationships of the ametype are termed an entity sct and relationship set,respectively.The overall logical structure（schema）of a database can be expressed graphically by an E-R diagram,which is built up from the fllowing components:（ ）represent entity set,（ ）represent atributes,ete.In addition to entities and relations,the E-R model represents certain（请作答此空）to which thecontents of a database must conform.The entity-relationship model is widely used in database design.A.things
B.objects
C.conditions
D.constrains
考题
Accelerated analysis approaches emphasize the construction of（ ）to more rapidly identify business and user requirements for a new system. As an accelerated analysis technology，（ ）reads the program code and automatically generates the equivalent system model， and the code can be obtained from （请作答此空）. All system analysis approaches require some form of（ ）which includes those techniques to be used to identify or extract system problems and solution requirements from user community. （ ）is a classical set of techniques used to collect information about system problems， opportunities， solution requirements， and priorities.
A. existing database and application program
B. application program and user interface
C. existing database and user interface
D. existing database，application program and user interface
考题
The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？（）A、set the SESSIONS to 1 in the parameter fileB、grant SINGLE SESSION privilege to all of the usersC、set the SESSIONS_PER_USER to 1 in the users’ profileD、grant RESTRICTED SESSION privilege to all of the database usersE、create a role with SINGLE SESSION privilege and assign the role to the users
考题
数据库领域中最常用的数据模型有四种，它们是（）。A、基本模型（Basic Model）B、关系模型（Relational Model）C、面向对象模型（Object Oriented Model）D、网状模型（Network Model）E、层次模型（Hierarchical Model）
考题
The staff is not able to access a database server. The server has an ’Operating System not found’error and is set to boot from a fiber channel SAN. All other database servers are set to boot from the SAN and access the same switch and data as this database server. Which of the following is the MOST likely cause of the problem？（）A、The SAN is offlineB、Fiber channel switchC、Multiple failed drives in the SAND、HBA
考题
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（） A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature
考题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
考题
What does it mean if a backup is expired?（）A、The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. B、The backup set has one or more invalid blocks in it and is not usable for recovery. C、The backup set contains one or more tablespaces no longer in the database. D、The backup set contains one or more missing backup set pieces.E、The backup set is from a previous version of RMAN and was not upgraded.
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
考题
单选题You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMANRUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }A
NOMOUNTB
MOUNTC
OPEND
RESTRICTED
考题
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A
to enable operating system authentication for a remote clientB
to restrict the scope of administration to identical operating systemsC
to allow the start up and shut down of the database from a remote clientD
to enable the administration of the operating system from a remote clientE
to disable the administration of the operating system from a remote client
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）A
For the database, you should turn on the TRUSTWORTHY database optionB
For the database, the PAGE_VERIFY database option should be set to CHECKSUMC
For the database, the database compatibility level option should be set to 10D
For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
考题
单选题Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）A
User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；B
User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；C
User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；D
User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；E
User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；
考题
多选题数据库领域中最常用的数据模型有四种，它们是（）。A基本模型（Basic Model）B关系模型（Relational Model）C面向对象模型（Object Oriented Model）D网状模型（Network Model）E层次模型（Hierarchical Model）
考题
单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）A
by using the RMAN utilityB
by using the export/import utilityC
by using the ALTER DATABASE commandD
by enabling the change tracking feature
考题
单选题Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A
The minimum memory size for the database buffer cache is set to 100 mb.B
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC
The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D
The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
考题
问答题Is relational DBMS physical data model suitable for spatial data？如果不适合，有哪两类解决途径？
热门标签
最新试卷
