An object type is a user-defined composite data type.
The attributes of an object type can be those of other object types.
A PL/SQL table of records is an example of a nested object type.
An object type must be declared as a type before the actual object itself can be declared.
第1题:
第2题:
You work as an application developer at Certkiller .com. You are developing an application that makes use of a Queue class object named MyQueue. This Queue class object will be used to store messages sent by the user during application run time. The application that you are developing provides an interface for administrators and an interface for users to create message reports.You want to ensure that all user messages stored in the MyQueue object are removed when an administrator selects the reset option.What should you do?()
第3题:
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?()
第4题:
You are designing an n-tier Java EE application. You have already decided that some of your JSPs willneed to get data from a Customer entity bean. You are trying to decide whether to use a Customer stubobject or a Transfer Object. Which two statements are true?()
第5题:
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()
第6题:
The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?()
第7题:
You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? ()
第8题:
You are developing an ASP.NET Web application. The application must pass an object that contains user-specific data between multiple pages. The object ismore than 100 KB in size when serialized.You need to minimize the amount of data is sent to the user. What should you do?()
第9题:
RUN_PRODUCT
SET_REPORT_OBJECT_PROPERTY
RUN_REPORT_OBJECT
FIND_REPORT_OBJECT
REPORT_OBJECT_STATUS
COPY_REPORT_OBJECT_OUTPUT
第10题:
Whole database
Tablespaces
Datafiles
Archive logs
Redo logs
第11题:
Objects from classes that use aggregation cannot be serialized
An object serialized on one JVM can be successfully deserialized on a different JVM
The values in fields with the volatile modifier will NOT survive serialization and deserialization
The values in fields with the transient modifier will NOT survive serialization and deserialization
It is legal to serialize an object of a type that has a supertype that does NOT implement java.io.Serializable
第12题:
heap tables
object tables
partitioned tables
index-organized tables (IOTs)
第13题:
You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery :Type screen?()
第14题:
Which three statements concerning the use of the java.io.Serializable interface are true?()
第15题:
An administrator wants to delete an account object using the Database Cleanup utility. Which of the following is the correct syntax to perform this task?()
第16题:
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: a) high availability of data b) faster primary key access to the table data c) compact storage for the table Which type of tables would you use to achieve these objectives?()
第17题:
Which object is added to a form module when you copy the reusable calender class?()
第18题:
You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()
第19题:
You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database. What should you do?()
第20题:
You work as an application developer at Certkiller .com. You are currently in the process of creating a class that stores data about Certkiller .com’s customers. Certkiller .com customers are assigned unique identifiers and various characteristics that may include aliases, shipping instructions, and sales comments. These characteristics can change in both size and data type. You start by defining the Customer class as shown below: public class Customer { private int custID; private ArrayList attributes; public int CustomerID { get {return custID;} } public Customer (int CustomerID) { this.custID = CustomerID; this.attributes = new ArrayList (); } public void AddAttribute (object att) { attributes.Add (att); } } You have to create the FindAttribute method for locating attributes in Customer objects no matter what the data type is.You need to ensure that the FindAttributemethod returns the attribute if found,and you also need to ensure type-safety when returning the attribute.What should you do?()
第21题:
Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group.
Write server-side subprograms, and call the subprograms from the form application.
Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.
第22题:
The stub will increase network traffic.
The Transfer Object will decrease data staleness.
The stub will increase the logic necessary in the JSPs.
In both cases, the JSPs can use EL expressions to get data.
Only the Transfer Object will need to use a Business Delegate.
第23题:
Add attributes to the session object.
Add attributes on the request object.
Add parameters to the request object.
Use the pageContext object to add request attributes.
Add parameters to the JSP’s URL when generating the request dispatcher.