Repair damaged data dictionary entries.
Delete data dictionary information about database objects you no longer need.
Extract data definition commands from the data dictionary in a variety of formats.
Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator
第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
第2题:
第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?()
第4题:
What does the Metadata Application Programming Interface (API) allow you to do?()
第5题:
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
第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?()
第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?()
第8题:
Configure a Linked Server connection to the application database.
Write a query that uses an OPENDATASOURCE command.
Write a query that uses an OPENQUERY command.
Configure a Remote Server connection to the application database.
第9题:
Access the personalization data from the Session property of the HttpContext object.
Access the personalization data from the Application property of the HttpContext object.
Access the personalization data from the Cache property of the HttpContext object.
Access the personalization data from the Profile property of the HttpContext object.
第10题:
Use the DESCRIBE command in the EMP_DEPT VU view.
Use the DEFINE VIEW command on the EMP_DEPT VU view.
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
第11题:
use the external table population
use the Oracle Data Pump export and import utility
use the conventional path data load of SQL*Loader utility
use the direct path data load of Oracle export and import utility
第12题:
SYSTEM
OUTLN
INTERNAL
SYS
第13题:
第14题:
第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?()
第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?()
第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?()
第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? ()
第19题:
It updates the control file with the new location of the data file.
It updates only the data dictionary with the new location of the data file.
It changes the location of the user_data01.dbf file in the operating system.
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.
第20题:
V$DATABASE
DBA_TABLES
SYSAUD$
EMP
第21题:
Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
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.
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.
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.
第22题:
Use the InProc Session Management mode to store session data in the ASP.NET worker process.
Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database.
Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm.
Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm.
第23题:
The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.
The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.