niusouti.com

单选题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 d

题目
单选题
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.

相似考题

1.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

2.YouissuethisSQLstatement:ALTERDATABASERENAMEFILE’／ORADATA／u02／user_data01.dbf’TO’／ORADATA／u04／user_data01.dbf’;WhatdoesthisSQLstatementdo?()A.Itupdatesthecontrolfilewiththenewlocationofthedatafile.B.Itupdatesonlythedatadictionarywiththenewlocationofthedatafile.C.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystem.D.Itchangesthelocationoftheuser_data01.dbffileintheoperatingsystemandupdatesthecontrolfilewiththenewlocationofthedatafile.

3. You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.

4.You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?A．Increase the maximum file size of Sales_Data to 1,500MB.B．Use the DBCC SHRINKDATABASE statement.C．Set automatic file growth to 10 percent.D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.

更多“单选题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 d”相关问题

  • 第1题：

    Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）

    • A、RESTORE DATAFILE ’/DISK2/user_data01.dbf’
    • B、RESTORE DATAFILE ’/DISK3/user_data01.dbf’
    • C、SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
    • D、SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’

    正确答案:C

  • 第2题：

    You issued the following statement：  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What will be the result of issuing the statement？（）  

    • A、 The control file will be multiplexed.
    • B、 The control file will be recreated.
    • C、The script containing the CREATE CONTROLFILE statement will be created.
    • D、 The binary backup of the control file will be created.

    正确答案:C

  • 第3题：

    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）

    • A、 The statement will be executed successfully， and a new time zone will be set for the database.
    • B、 The statement will be executed successfully， but a new time zone will not be set for the database.
    • C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
    • D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

    正确答案:D

  • 第4题：

    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

  • 第5题：

    In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；

    • 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 a script containing the CREATE CONTROLFILE statement exists
    • D、 when the SPFILE is missing

    正确答案:A

  • 第6题：

    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

    • A、Create the database by using a single data file and a single log file.
    • B、Create the database by using a single data file and multiple log files.
    • C、Create the database by using a single log file and multiple filegroups.
    • D、Create the database by using a single log file and a filegroup that has multiple data files.

    正确答案:C

  • 第7题：

    单选题
    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.


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

  • 第8题：

    单选题
    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）
    A

     The statement will not execute successfully.

    B

     The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days

    C

     The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.

    D

     Backups will be deleted from the media after 400 days.


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

  • 第9题：

    单选题
    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
    A

     The statement will be executed successfully， and a new time zone will be set for the database.

    B

     The statement will be executed successfully， but a new time zone will not be set for the database.

    C

     The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.

    D

     The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.


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

  • 第10题：

    单选题
    You issued the following statement：  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What will be the result of issuing the statement？（）
    A

     The control file will be multiplexed.

    B

     The control file will be recreated.

    C

    The script containing the CREATE CONTROLFILE statement will be created.

    D

     The binary backup of the control file will be created.


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

  • 第11题：

    单选题
    In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；
    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 a script containing the CREATE CONTROLFILE statement exists

    D

     when the SPFILE is missing


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

  • 第12题：

    单选题
    Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
    A

    RESTORE DATAFILE ’/DISK2/user_data01.dbf’

    B

    RESTORE DATAFILE ’/DISK3/user_data01.dbf’

    C

    SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’

    D

    SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’


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

  • 第13题：

    You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

    • A、Image of the control file
    • B、Location of the control file
    • C、Contents of the control file in text format
    • D、SQL command to re-create the database
    • E、SQL command to re-create the control file
    • F、Contents of the control file in binary format

    正确答案:E

  • 第14题：

    One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

    • A、drop and re­create the read­only tablespaces
    • B、rename the read­only data files to their correct file names
    • C、change the tablespace status from read/write to read­only
    • D、re­create the read­only tablespace because it is automatically removed

    正确答案:B

  • 第15题：

    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

    • A、 The statement will fail.
    • B、 The statement will be executed successfully， and the new time zone will be set for the database.
    • C、 The statement will be executed successfully， but the new time zone will be set for the current session.
    • D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

    正确答案:A

  • 第16题：

    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DBVERIFY utility
    • C、 by using Block Media Recovery
    • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

    正确答案:C

  • 第17题：

    You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement：    SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400；    What is the outcome of this statement？ （）

    • A、 The statement will not execute successfully.
    • B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days
    • C、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.
    • D、 Backups will be deleted from the media after 400 days.

    正确答案:A

  • 第18题：

    单选题
    You backed up the control file to trace. Which statement is true about the trace file generated？（）
    A

    The trace file is in binary format.

    B

    The trace file has a SQL script to re-create the control file.

    C

    The trace file is a backup set created during the backup of the control file. 

    D

    The trace file contains the instructions to manually re-create the control file.

    E

    The trace file is an image copy of the control file created during the backup of the control file.


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

  • 第19题：

    单选题
    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）
    A

     by using the DBMS_REPAIR package

    B

     by using the DBVERIFY utility

    C

     by using Block Media Recovery

    D

     by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command


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

  • 第20题：

    单选题
    You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）
    A

    A text copy of the control file.

    B

    A binary copy of the control file.

    C

    A file containing a SQL statement which will re-create the database.

    D

    A file containing a SQL statement which will re-create the control file.


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

  • 第21题：

    单选题
    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）
    A

    Create the database by using a single data file and a single log file.

    B

    Create the database by using a single data file and multiple log files.

    C

    Create the database by using a single log file and multiple filegroups.

    D

    Create the database by using a single log file and a filegroup that has multiple data files.


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

  • 第22题：

    单选题
    One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）
    A

     drop and re-create the read-only tablespaces

    B

     rename the read-only data files to their correct file names

    C

     change the tablespace status from read/write to read-only

    D

     re-create the read-only tablespace because it is automatically removed


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

  • 第23题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services （SSIS） package to perform an extract， transform， and load （ETL） process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components： A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average， 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do？（）
    A

     Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint. 

    B

     Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint. 

    C

     Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.

    D

     Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.


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

  • 第24题：

    单选题
    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）
    A

     The statement will fail.

    B

     The statement will be executed successfully， and the new time zone will be set for the database.

    C

     The statement will be executed successfully， but the new time zone will be set for the current session.

    D

    The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.


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

相关内容