单选题What does the Metadata Application Programming Interface (API) allow you to do?()A Repair damaged data dictionary entries.B Delete data dictionary information about database objects you no longer need.C Extract data definition commands from the data di

题目
单选题
What does the Metadata Application Programming Interface (API) allow you to do?()
A

Repair damaged data dictionary entries.

B

Delete data dictionary information about database objects you no longer need.

C

Extract data definition commands from the data dictionary in a variety of formats.

D

Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator


相似考题
参考答案和解析
正确答案: C
解析: 暂无解析
更多“单选题What does the Metadata Application Programming Interface (API) allow you to do?()A Repair damaged data dictionary entries.B Delete data dictionary information about database objects you no longer need.C Extract data definition commands from the data di”相关问题
  • 第1题:

    ●A (72) is a file that contains metadata—that is,data about data.

    (72)A.document

    B.Excel table

    C. database

    D.data dictionary


    正确答案:D

  • 第2题:

    A data ( ) is a file that contains metadata - that is, data about data.

    A.structure
    B.table
    C.base
    D.dictionary

    答案:D
    解析:
    数据字典就是包含元数据的文件,即关于数据的数据。

  • 第3题:

    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.

    正确答案:D

  • 第4题:

    What does the Metadata Application Programming Interface (API) allow you to do?()

    • A、Repair damaged data dictionary entries.
    • B、Delete data dictionary information about database objects you no longer need.
    • C、Extract data definition commands from the data dictionary in a variety of formats.
    • D、Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator

    正确答案:C

  • 第5题:

    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?() 

    • A、V$DATABASE 
    • B、DBA_TABLES 
    • C、SYSAUD$ 
    • D、EMP

    正确答案:B

  • 第6题:

    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()

    • A、Configure a Linked Server connection to the application database.
    • B、Write a query that uses an OPENDATASOURCE command.
    • C、Write a query that uses an OPENQUERY command.
    • D、Configure a Remote Server connection to the application database.

    正确答案:B

  • 第7题:

    You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding, the Session objects are not lost.  What should you do?()

    • A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. 
    • B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 
    • C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 
    • D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 

    正确答案:B

  • 第8题:

    单选题
    You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()
    A

    Configure a Linked Server connection to the application database.

    B

    Write a query that uses an OPENDATASOURCE command.

    C

    Write a query that uses an OPENQUERY command.

    D

    Configure a Remote Server connection to the application database.


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

  • 第9题:

    单选题
    You have a Web application that is configured for personalization. You need to access personalization data from one of the pages of the Web application by using the minimum amount of administrative effort. What should you do?()
    A

     Access the personalization data from the Session property of the HttpContext object.

    B

     Access the personalization data from the Application property of the HttpContext object.

    C

     Access the personalization data from the Cache property of the HttpContext object.

    D

     Access the personalization data from the Profile property of the HttpContext object.


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

  • 第10题:

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


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

  • 第11题:

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第12题:

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


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

  • 第13题:

    A data ( ) is a file that contains metadata - that is, data about data.

    A .structure
    B .table
    C .base
    D .dictionary

    答案:D
    解析:
    数据字典就是包含元数据的文件,即关于数据的数据。

  • 第14题:

    _____ is a file that contains metadata-that is, data about data.

    A.Document
    B.Excel table]
    C.Database]
    D.Data dictionary

    答案:D
    解析:
    数据字典是一个包含元数据(即关于数据的数据)的文件。

  • 第15题:

    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.

    正确答案:C

  • 第16题:

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第17题:

    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()

    • A、SYSTEM 
    • B、OUTLN 
    • C、INTERNAL 
    • D、SYS

    正确答案:D

  • 第18题:

    You have a Web application that is configured for personalization. You need to access personalization data from one of the pages of the Web application by using the minimum amount of administrative effort. What should you do? ()

    • A、Access the personalization data from the Session property of the HttpContext object.
    • B、Access the personalization data from the Application property of the HttpContext object.
    • C、Access the personalization data from the Cache property of the HttpContext object.
    • D、Access the personalization data from the Profile property of the HttpContext object.

    正确答案:D

  • 第19题:

    单选题
    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
    解析: 暂无解析

  • 第20题:

    单选题
    You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
    A

    V$DATABASE 

    B

    DBA_TABLES 

    C

    SYSAUD$ 

    D

    EMP


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

  • 第21题:

    单选题
    You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?()
    A

    Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.

    B

    Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.

    C

    Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.

    D

    Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.


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

  • 第22题:

    单选题
    You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding, the Session objects are not lost.  What should you do?()
    A

    Use the InProc Session Management mode to store session data in the ASP.NET worker process. 

    B

    Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 

    C

    Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 

    D

    Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 


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

  • 第23题:

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


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