（）——DataBase Management System，简称（），DBMS运行在操作系统之上对数据库进行统一的管理和控制，并且使数据库能为多个用户共享，同时还能保证数据的（），还要保证数据的高度独立性等。

题目

（）——DataBase Management System，简称（），DBMS运行在操作系统之上对数据库进行统一的管理和控制，并且使数据库能为多个用户共享，同时还能保证数据的（），还要保证数据的高度独立性等。

相似考题

1.●SQL Server is a RDBMS(Relational Database Management System)made by Microsoft.This means that the data is stored in two dimensional (74) .(74) A．documentsB．databasesC．filesD．tables

2.SQL Server is a RDBMS(Relational Database Management System)made by Microsoft. This means that the data is stored in two dimensional(70)。A．documentsB．databasesC．filesD．tables

3.A Database Management System(DBMS) consists of a collection of interrelated data and a collection of () to access to that dataA.programsB.memoryC.spaceD.password

4.Which of the following is not responsibility of DBA(Data Base Administrator)?A．Database management system designB．Database schema definitionC．Database schema modificationD．Integrity constraint specification

更多“（）——DataBase Management System，简”相关问题

  • 第1题：

    A Database Management System(DBMS)consists of A.collection of interrelated data and a collection of（）to access to that data.

    A.programs
    B.memory
    C.space
    D.password

    答案：A
    解析：
    翻译：
    数据库管理系统（DBMS）由一组相关的数据和（71）来访问这些数据的集合。
    A.程序B.内存C.空间D.密码

  • 第2题：

    System management mode


    正确答案:系统管理方式，为操作系统和核心程序提供节能管理和系统安全管理机制。

  • 第3题：

    下列选项中，表示数据库的英文名称是（）

    • A、Database Management System
    • B、Database
    • C、Database System
    • D、System

    正确答案:B

  • 第4题：

    Prior to implementing an LPAR system， which of the following needs to be done？（）

    • A、A graphics monitor must be attached to the server
    • B、Cluster System Management （CSM） software must be installed
    • C、The LPAR system must have an Hardware Management Console （HMC） connected
    • D、Each LPAR must be configured with a CDROM for operating system installation

    正确答案:C

  • 第5题：

    You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）

    • A、Oracle Management Agent
    • B、Enterprise Manager with Grid Control
    • C、Enterprise Manager with Database Control
    • D、Operating System Socket for incoming requests
    • E、Real Application Cluster （RAC） with three instances
    • F、Enterprise Manager with Generic Database Management

    正确答案:A

  • 第6题：

    Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（） 

    • A、 ALTER SYSTEM KILL SESSION
    • B、 ALTER SYSTEM DISCONNECT SESSION
    • C、 ALTER SYSTEM QUIESCE RESTRICTED
    • D、 ALTER SYSTEM ENABLE RESTRICTED SESSION

    正确答案:D

  • 第7题：

    单选题
    n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
    A

     Oracle Migration Assistant

    B

     Recovery Manager （RMAN）

    C

     Oracle Data Pump Export and Import

    D

     conventional Oracle Export and Import

    E

     operating system utilities to copy the files to the ASM instance


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）
    A

    Oracle Management Agent

    B

    Enterprise Manager with Grid Control

    C

    Enterprise Manager with Database Control

    D

    Operating System Socket for incoming requests

    E

    Real Application Cluster （RAC） with three instances

    F

    Enterprise Manager with Generic Database Management


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）
    A

     The operating system local time zone will be set for a user session using the operating system environment variable.

    B

     The database local time zone will be set for a user session using the operating system environment variable.

    C

     The operating system local time zone will be set for the database using the operating system environment

    D

     The database local time zone will be set for the database using the operating system environment variable.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager（RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）
    A

    RMAN would relocate all the database files to an ASM disk group.

    B

    RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

    C

    RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.

    D

    RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You work as the exchange administrator at TestKing.com. The TestKing.com network contains an Exchange Server 2010 Organization. TestKing.com has its headquarters in Stockholm where you are located.The TestKing.com network contains a database availability group （DAG）. You receive an instruction fromthe management to devise a Mailbox database security solution for the organization. Management wantsthe read/write performance to be maximized as well as ensuring that any access to the database isprohibited in the event of theft. What should you do？（）
    A

    You should recommend that management make use of DAG network encryption.

    B

    You should recommend that management make use of Encrypted File System （EFS）

    C

    You should recommend that management make use of Windows BitLocker Drive Encryption.

    D

    You should recommend that management make use of Rights Management Service RMS.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    With which level in IBM Maximo Asset Management V6.2 are Purchase Contracts associated？ （）
    A

     Set Level

    B

     System Level

    C

     Database Level

    D

     Organization Level


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第14题：

    With which level in IBM Maximo Asset Management V6.2 are Purchase Contracts associated？ （）

    • A、 Set Level
    • B、 System Level
    • C、 Database Level
    • D、 Organization Level

    正确答案:D

  • 第15题：

    Which of the following can deploy system plans generated by the IBM System Planning Tool （SPT）？（）

    • A、 The Hardware Management Console （HMC） and Integrated Virtualization Manager （IVM）.
    • B、 The Hardware Management Console （HMC） and Advanced System Manager Interface （ASMI）.
    • C、 Integrated Virtualization Manager （IVM） and Advanced System Manager Interface （ASMI）.
    • D、 Integrated Virtualization Manager （IVM） and BladeCenter Advanced Management Module （AMM）.

    正确答案:A

  • 第16题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第17题：

    You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

    • A、 Enable Flashback Data Archive for the tables.
    • B、 Specify undo retention guarantee for the database.
    • C、 Enable supplemental logging for the database.
    • D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
    • E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

    正确答案:A

  • 第18题：

    You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  

    • A、 The operating system local time zone will be set for a user session using the operating system environment variable.
    • B、 The database local time zone will be set for a user session using the operating system environment variable.
    • C、 The operating system local time zone will be set for the database using the operating system environment
    • D、 The database local time zone will be set for the database using the operating system environment variable.

    正确答案:B

  • 第19题：

    单选题
    Which database does WX Central Management System (WX CMS) software use to store historical data?（）
    A

    Oracle

    B

    MySQL

    C

    Sybase

    D

    Microsoft Access


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    Examine the parameter setting in your database: Which statement is correct about the database?（）
    A

    Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

    B

    The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

    C

    The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

    D

    Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You need to increase the size of a paging file. What should you do? （）
    A

    From Disk Management， shrink the boot partition.

    B

    From Disk Management， shrink the system partition.

    C

    From System， modify the Advanced system settings.

    D

    From System， modify the System protection settings.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）
    A

    Oracle Migration Assistant

    B

    Recovery Manager （RMAN）

    C

    Oracle Data Pump Export and Import

    D

    conventional Oracle Export and Import

    E

    operating system utilities to copy the files to the ASM instance


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following can deploy system plans generated by the IBM System Planning Tool （SPT）？（）
    A

     The Hardware Management Console （HMC） and Integrated Virtualization Manager （IVM）.

    B

     The Hardware Management Console （HMC） and Advanced System Manager Interface （ASMI）.

    C

     Integrated Virtualization Manager （IVM） and Advanced System Manager Interface （ASMI）.

    D

     Integrated Virtualization Manager （IVM） and BladeCenter Advanced Management Module （AMM）.


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）
    A

     ALTER SYSTEM KILL SESSION

    B

     ALTER SYSTEM DISCONNECT SESSION

    C

     ALTER SYSTEM QUIESCE RESTRICTED

    D

     ALTER SYSTEM ENABLE RESTRICTED SESSION


    正确答案： D
    解析： 暂无解析

相关内容