itgle.com

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMA

题目

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

  • A、 control file
  • B、 all datafiles
  • C、 password file
  • D、 online redo log file
  • E、 archive redo log file
  • F、 server parameter file
  • G、 only the SYSTEM datafile
相似考题

1.PremierePro项目文件的扩展名是()。A.prprojB.premiereC.proD.proj

2.Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOGMAXLOGFILES20MAXLOGMEMBERS3MAXDATAFILES30MAXINSTANCES10MAXLOGHISTORY1200LOGFILEGROUP1（’/disk1/prod/orders/db/log1a.dbf’，’/disk2/prod/orders/db/log1b.dbf’）SIZE100KGROUP2（’/disk1/prod/orders/db/log2a.dbf’，’/disk2/prod/orders/db/log2b.dbf’）SIZE100K，DATAFILE’/disk1/prod/orders/db/database1.dbf’，’/disk2/prod/orders/db/file1.dbf’；

3.Linux上,ps –ef|grep smon显示结果为 ora_smon_prod,则可知道哪个参数的值是prod()A. INSTANCE_NAMEB. DB_UNIQUE_NAMEC. DB_NAMED. ORACLE_SID

4.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

更多“Your PROD database&en”相关问题

  • 第1题：

    143、PremiereProCS3的项目文件的扩展名是（）。

    • A、prproj
    • B、premiere
    • C、pro
    • D、proj

    正确答案:A

  • 第2题：

    AS400登录至实装制造画面流程（）。

    • A、PROD-1
    • B、PROD-2
    • C、PROD-4
    • D、PROD-3

    正确答案:C

  • 第3题：

    Premiere Pro CS3的项目文件的扩展名是（）.

    • A、prproj
    • B、premiere
    • C、pro
    • D、proj

    正确答案:A

  • 第4题：

    You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

    • A、 Data Pump Export and Import
    • B、 conventional export and import
    • C、 the CONVERT command of RMAN
    • D、 the BACKUP AS COPY. command of RMAN

    正确答案:D

  • 第5题：

    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

    • A、the CONVERT command of RMAN
    • B、Data Pump Export and Import into the same database
    • C、conventional export and import into the same database
    • D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
    • E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

    正确答案:A,E

  • 第6题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


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

  • 第7题：

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）
    A

     LARGE_POOL_SIZE

    B

     DB_CREATE_FILE_DEST

    C

     LOG_ARCHIVE_DEST

    D

     CONTROL_FILES

    E

     LOG_ARCHIVE_FORMAT

    F

     DB_BLOCK_SIZE


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

  • 第8题：

    单选题
    You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）
    A

    functions

    B

    packages

    C

    procedures

    D

    database triggers

    E

    anonymous PL/SQL block


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

  • 第9题：

    多选题
    You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）
    A

    the CONVERT command of RMAN

    B

    Data Pump Export and Import into the same database

    C

    conventional export and import into the same database

    D

    the BACKUP DATABASE and RESTORE DATABASE commands of RMAN

    E

    the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN


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

  • 第10题：

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database：  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD？（）
    A

    DB_BLOCK_SIZE

    B

    CONTROL_FILES

    C

    LARGE_POOL_SIZE

    D

    LOG_ARCHIVE_DEST

    E

    LOG_ARCHIVE_FORMAT

    F

    DB_CREATE_FILE_DEST


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

  • 第11题：

    单选题
    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）
    A

    SQL*Plus

    B

    iSQL*Plus

    C

    Management Server

    D

    Management Repository

    E

    Oracle Enterprise Manager 10g Database Control


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

  • 第12题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


    正确答案： G,F
    解析： 暂无解析

  • 第13题：

    容易变动的测试仪器应该采用哪种SPC控制？（）

    • A、ProD.uCtSPC
    • B、TesterSPC
    • C、Pro
    • D、uCt或者TesterSPC

    正确答案:B

  • 第14题：

    （）是网站检验软件。

    • A、Fireworks
    • B、SiteMapper
    • C、Linkbot Pro
    • D、Phtoshop

    正确答案:B,C

  • 第15题：

    下列哪种氨基酸能直接脱氨生成α-酮酸：（）

    • A、Leu
    • B、Thr
    • C、Pro
    • D、Ala

    正确答案:B

  • 第16题：

    In which situation will you run the script containing the following statement？（）   CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG        MAXLOGFILES 20        MAXLOGMEMBERS 3        MAXDATAFILES 30        MAXINSTANCES 10        MAXLOGHISTORY 1200        LOGFILE        GROUP 1 （   ’/disk1/prod/orders/db/log1a.dbf’，        ’/disk2/prod/orders/db/log1b.dbf’        ）SIZE 100K        GROUP 2 （   ’/disk1/prod/orders/db/log2a.dbf’，        ’/disk2/prod/orders/db/log2b.dbf’        ） SIZE 100K，        DATAFILE   ’/disk1/prod/orders/db/database1.dbf’，                                           ’/disk2/prod/orders/db/file1.dbf ’；  

    • A、 when all the control files are missing and only a binary backup of the current control file exists
    • B、 when a multiplexed copy of the current control file is missing
    • C、 when all the control files are missing and only an ASCII representation of the binary control file exists
    • D、 when the SPFILE is missing

    正确答案:B

  • 第17题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第18题：

    单选题
    Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）
    A

    increase the undo retention

    B

    create more undo segments

    C

    create another undo tablespace

    D

    increase the size of the undo tablespace


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

  • 第19题：

    单选题
    The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）
    A

    1, 4, 5, 2, 3

    B

    1, 4, 3, 2, 5

    C

    4, 5, 2, 3, 1

    D

    2, 3, 4, 5, 1

    E

    1, 4, 2, 3, 5


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

  • 第20题：

    单选题
    You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
    A

    The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

    B

    The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

    C

    The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.

    D

    The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.


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

  • 第21题：

    多选题
    You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）
    A

    the CONVERT command of RMAN

    B

    Data Pump Export and Import into the same database

    C

    conventional export and import into the same database

    D

    the BACKUP DATABASE and RESTORE DATABASE commands of RMAN

    E

    the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN


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

  • 第22题：

    单选题
    You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）
    A

     Data Pump Export and Import

    B

     conventional export and import

    C

     the CONVERT command of RMAN

    D

     the BACKUP AS COPY. command of RMAN


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

  • 第23题：

    单选题
    In which situation will you run the script containing the following statement？（）   CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG        MAXLOGFILES 20        MAXLOGMEMBERS 3        MAXDATAFILES 30        MAXINSTANCES 10        MAXLOGHISTORY 1200        LOGFILE        GROUP 1 （   ’/disk1/prod/orders/db/log1a.dbf’，        ’/disk2/prod/orders/db/log1b.dbf’        ）SIZE 100K        GROUP 2 （   ’/disk1/prod/orders/db/log2a.dbf’，        ’/disk2/prod/orders/db/log2b.dbf’        ） SIZE 100K，        DATAFILE   ’/disk1/prod/orders/db/database1.dbf’，                                           ’/disk2/prod/orders/db/file1.dbf ’；
    A

     when all the control files are missing and only a binary backup of the current control file exists

    B

     when a multiplexed copy of the current control file is missing

    C

     when all the control files are missing and only an ASCII representation of the binary control file exists

    D

     when the SPFILE is missing


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

相关内容