欢迎来到建筑考试题库网 建筑考试题库官网
全部科目 > Oracle认证考试 > 1Z0-032

单项选择题

You issue this SQL statement: 
ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO
’/ORADATA/u04/user_data01.dbf’; 
What does this SQL statement do?()

    A.It updates the control file with the new location of the data file. 
    B.It updates only the data dictionary with the new location of the data file. 
    C.It changes the location of the user_data01.dbf file in the operating system. 
    D.It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.

点击查看答案

相关考题

  • 单项选择题
    YouareconfiguringforOracleSharedServer.Whichserviceisrequired?()

    A.Oracle Net Service
    B.Oracle HTTP Service
    C.Oracle Paging Service
    D.Internet Directory Service

  • 单项选择题
    Whichstepisrequiredforrecoverfromaninstancefailure?()

    A.Start up only.
    B.Restore needed data files, then start up.
    C.Complete restore from backup, then start up.
    D.Perform point in time recovery, then start up.

  • 多项选择题
    WhenCONFIGURECONTROLFILEAUTOBACKUPissettoON,RMANautomaticallyperformsacontrolfileautobackupinwhichthreesituations?()

    A.At the end of every RUN block. 
    B.After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
    C.After every BACKUP or COPY command issued at the RMAN prompt. 
    D.At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
    E.Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
    F.After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题