Tab canvas.
Pop up canvas.
Spread table canvas.
Vertical toolbar canvas.
第1题:
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()
第2题:
You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? ()
第3题:
You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?()
第4题:
You need to add a pop-up menu to the CV_EMP canvas to display when a user right-clicks the mouse within the canvas. How could you create the pop-up menu?()
第5题:
You work as an ASP.NET Web Application Developer for SomeCompany. The company uses Visual Studio .NET 2010 as its application development platform. You create an ASP.NET Web application using .NET Framework 4.0. You create a Web page in the application. The Web page will get large sets of data from a data source. You add a DataPager control to the page. You are required to display navigation controls that enable you to create a custom paging Ul for the DataPager control. What will you do?()
第6题:
You are designing a Windows Azure application that will provide online backup storage for very large media files. The application must be capable of storing an average of 1 GB of data for each user. The application must provide random read/write access. You need to recommend a durable data storage solution. What should you recommend?()
第7题:
Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property.
Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
第8题:
GET_RELATION_PROPERTY
SET_RELATION_PROPERTY
GET_BLOCK_PROPERTY
GET_FORM_PROPERTY
第9题:
Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property.
Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.
第10题:
table
transactional trigger
stored procedure
FROM clause query
第11题:
One content canvas and multiple stacked canvases.
One content and one stacked canvas.
Tab canvas with several tab pages.
One content canvas.
A horizontal and vertical toolbar.
第12题:
Built-in Packages
Menus
PL/SQL Libraries
Object Libraries
Form Module
第13题:
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?()
第14题:
You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? ()
第15题:
You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?()
第16题:
You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?()
第17题:
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?()
第18题:
database table
transactional trigger
stored procedure
FROM clause query
client-side procedure
第19题:
Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property.
Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor.
Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
第20题:
Use a Windows Azure Drive.
Use Windows Azure page blob storage.
Use Windows Azure block blob storage.
Use local storage on a Windows Azure instance.
第21题:
Use the Layout Editor to create a pop-up menu, assign commands to the menu in the Menu Editor, and attack the menu items to the canvas.
Use the Report Wizard to create a pop-up menu and attack the menu items to the canvas.
Alter the pop-up Menu Property value in the Property Palette of the canvas.
Use the Object Navigator to create a pop-up menu, assign commands to the menu items, and attack the menu to items or canvases.
第22题:
— quick
— skip-buffer
— single-transaction
— tab
第23题:
Tab canvas.
Pop up canvas.
Spread table canvas.
Vertical toolbar canvas.
第24题:
V$BACKUP_CORRUPTION
V$COPY_CORRUPTION
V$DATABASE_BLOCK_CORRUPTION
RC_BACKUP_CORRUPTION