You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition o

题目

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

  • A、Use the DESCRIBE command in the EMP_DEPT VU view.
  • B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
  • C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
  • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
  • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
  • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
相似考题

1.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?()A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

2.Your mobile device runs the latest version of the Microsoft Windows Mobile operating system.Your mobile device supports the use of Bluetooth and Infrared (IR) for data synchronization. You need to configure data synchronization on your computer to only use Bluetooth.Which three actions should you perform?（）A.AB.BC.CD.DE.EF.F

3.You are the administrator of an Active Directory domain named Auser reports that he cannot log on to a Windows Server 2003 computer that containsa critical application.You discover that the organizational unit (OU) in which the server is located wasdeleted. You discover that the user rights for this server are controlled by GroupPolicy.You need to restore access to the server. You need to achieve this goal by using theminimum amount of administrative effort.What should you do?（）A. Perform a normal restoration of the System State data for the domain controller. Force replication.B. Perform an authoritative restoration of the System State data for the domain controller. Mark the OU for replication.C. Re-create the OU that was deleted. Reapply Group Policy, and then add the computer account and any necessary users or groups.D. Perform an Automated System Recovery (ASR) restoration on the domain controller.

4.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

参考答案和解析
正确答案:D
更多“You need to perform certain data”相关问题

  • 第1题：

    You are the network administrator for TestKing.com. All network servers run Windows Server 2003.A member server named ServerTK1 is configured to run shadow copies without a storage limit. ServerTK1 has the disk configuration shown in the following table.You need to create additional free space on DATA1. You also need to improve the performance of ServerTK1 and ensure that it has sufficient space for shadow copies in the future.Which two actions should you perform? （）(Each correct answer presents part of the solution. Choose two)

    A. Delete the shadow copies of DATA1.

    B. Delete Backup.bkf on DATA3.

    C. In the properties of DATA1, relocate the shadow copies to DATA2.

    D. In the properties of DATA1, relocate the shadow copies to DATA3.

    E. Delete DATA3 and extend the DATA1 partition to include the space on DATA3.


    参考答案：A, D

  • 第2题：

    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、flash back all the tables in the data file， one by one
    • B、restore the data file to a new location and perform a media recovery
    • C、flash back the database; there is no need to restore the data file
    • D、restore the data file from the most recent backup and flash back the database

    正确答案:B

  • 第3题：

    You are the network administrator for The sales department stores data on a server that runs Windows Server 2003. The backup schedule for the server includes a normal backup on Sundays and incremental backups on every other day of the week. The sales department data includes a report that is created by an automated process. The report is included in the standard backup schedule for the server. The automated process runs on Wednesdays and Sundays. The process overwrites the previous version of the report. You need to be able to restore the report if the standard backup is unavailable. You need to create an additional backup for the report. The backup for the report cannot interfere with other backup jobs. What should you do?（）

    • A、Perform a normal backup on Wednesday night and on Sunday night.
    • B、Perform a differential backup on Wednesday night and on Sunday night.
    • C、Perform a incremental backup on Wednesday night and on Sunday night.
    • D、Perform a copy backup on Wednesday night and on Sunday night.

    正确答案:D

  • 第4题：

    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

    • A、You must configure block change tracking file
    • B、You must have first level 1 backups for RMAN to restore blocks
    • C、You must ensure that the SALES database is mounted or open
    • D、You must have full or level 0 backups for RMAN to restore blocks
    • E、You must take the tools01.dbf data file offline before you start a block media recovery

    正确答案:C,D

  • 第5题：

    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

    • A、 You do not need to restore all the data files.
    • B、 You do not need to open the database with the RESETLOGS operation
    • C、 You do not need to perform a full backup after the RESETLOGS operation.
    • D、 You do not need to recover all the data files to the same system change number （SCN）.

    正确答案:C

  • 第6题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）

    • A、 Filter data by using expressions.
    • B、 Specify the default values for each parameter.
    • C、 Create an available values list for each parameter.
    • D、 Create report parameters by using query parameters to filter data at the data source.

    正确答案:A,B

  • 第7题：

    You are the administrator of an Active Directory domain named A user reports that he cannot log on to a Windows Server 2003 computer that contains a critical application. You discover that the organizational unit (OU) in which the server is located was deleted. You discover that the user rights for this server are controlled by Group Policy. You need to restore access to the server. You need to achieve this goal by using the minimum amount of administrative effort. What should you do?（）

    • A、Perform a normal restoration of the System State data for the domain controller. Force replication.
    • B、Perform an authoritative restoration of the System State data for the domain controller. Mark the OU for replication.
    • C、Re-create the OU that was deleted. Reapply Group Policy, and then add the computer account and any necessary users or groups.
    • D、Perform an Automated System Recovery (ASR) restoration on the domain controller.

    正确答案:B

  • 第8题：

    You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation.  What should you do？（）

    • A、Create a System Restore point.
    • B、Perform an Automated System Recovery （ASR） backup and restore.
    • C、In the Backup and Restore Center window， click the Back up files button.
    • D、In the Backup and Restore Center window， click the Back up computer button.

    正确答案:C

  • 第9题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第10题：

    多选题
    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）
    A

    Use NTFS file system compression on the volume.

    B

    Use row-level compression on the document table.

    C

    Use varbinary(MAX) data type with FILESTREAM storage.

    D

    Enable row-level compression on all columns that use the vardecimal() data type.


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

  • 第11题：

    单选题
    You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
    A

     You do not need to restore all the data files.

    B

     You do not need to open the database with the RESETLOGS operation

    C

     You do not need to perform a full backup after the RESETLOGS operation.

    D

     You do not need to recover all the data files to the same system change number （SCN）.


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

  • 第12题：

    多选题
    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）
    A

    You must configure block change tracking file

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


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

  • 第13题：

    You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server is configured as shown in the following table.You need to ensure that you can restore the server and all its data in the event of a complete system failure.You perform an Automated System Recovery (ASR) backup.What else should you backup? （）

    A.volume C

    B.volume D

    C.volume E

    D.the system state


    参考答案：C

  • 第14题：

    Server1 contains a folder named D:/Salesdata, which contains important company data. The hardware-monitoring software reports that the disk that contains volume D is in danger of imminent disk failure. You order a replacement disk, but you must wait at least one day for the disk to be delivered. You discover that you do not have a backup of the D:/Salesdata folder because a recent backup was configured incorrectly. You need to back up the D:/Salesdata folder so that you can restore the data if the disk fails. You need to achieve this goal as quickly as possible. What should you do? （）

    • A、Perform a normal backup of the D:/Salesdata folder.
    • B、Perform an incremental backup of the D:/Salesdata folder.
    • C、Perform a differential backup of the D:/Salesdata folder.
    • D、Perform a daily backup of the D:/Salesdata folder.
    • E、Enable Shadow Copies on volume D:/Configure the shadow copy location as C:/.

    正确答案:A

  • 第15题：

    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

    • A、Use the DESCRIBE command in the EMP_DEPT VU view.
    • B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
    • C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
    • D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
    • E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
    • F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

    正确答案:D

  • 第16题：

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、 Flash back all the tables in the data file， one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database， there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第17题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

    • A、You must ensure that the SALES database is mounted or open.
    • B、You must restore a backup control file to perform a block media recovery.
    • C、You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

    正确答案:A,E

  • 第18题：

    You are the administrator of the TestKing company network. The network consists of a single Active Directory domain named The network includes 20 member servers running Windows Server 2003 and 4 domain controllers running Windows Server 2003. All client computers run Windows XP Professional. A member server named TestKingSrvA functions as a file server. TestKingSrvA has a locally attached tape device. You need to create a backup schedule for TestKingSrvA. All data on TestKingSrvA must be backed up once a week. Every day, you need to back up only the data that was changed after the last weekly backup. You need to minimize the amount of time taken to restore the data in the event of a hardware failure. What should you do? （）(Choose two)（）

    • A、Perform a normal backup every week.
    • B、Perform a copy backup every week.
    • C、Perform a differential backup every week.
    • D、Perform an incremental backup every week
    • E、Perform a normal backup every day.
    • F、Perform a copy backup every day.
    • G、Perform a differential backup every day.
    • H、Perform an incremental backup every day.

    正确答案:A,G

  • 第19题：

    You need to ensure that you can recover system configuration and data if your computer hard disk fails.  What should you do？ （）

    • A、Create a system restore point.
    • B、Create a backup of all file categories.
    • C、Create a Complete PC Backup and Restore image.
    • D、Perform an Automated System Recovery （ASR） backup.

    正确答案:C

  • 第20题：

    单选题
    You need to rename a data file of a tablespace. How would you perform this？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第21题：

    单选题
    You have a single Active Directory directory service domain. You back up your domain controllers on a nightly basis. An organizational unit （OU） is accidently deleted. You need to restore the objects that were located in the OU.  What should you do？（）
    A

     Perform a nonauthoritative restore of the domain controller.

    B

     Perform an authoritative restore of the domain controller.

    C

     Restore the system state data on the domain controller.

    D

     Restore the system volume on the domain controller.


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

  • 第22题：

    单选题
    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

     Flash back all the tables in the data file， one by one.

    B

     Restore the data file to a new location and perform a media recovery.

    C

     Flash back the database， there is no need to restore the data file.

    D

     Restore the data file from the most recent backup and flash the database.


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

  • 第23题：

    多选题
    You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）
    A

    SYSTEM

    B

    SYSAUX

    C

    UNDO

    D

    USERS

    E

    TEMP

    F

    This restore is not possible


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

  • 第24题：

    单选题
    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）
    A

    Use the DESCRIBE command on the EMP_DEPT_VU view.

    B

    Use the DEFINE VIEW command on the EMP_DEPT_VU view.

    C

    Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.

    D

    Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

    E

    Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.

    F

    Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.


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

相关内容