The code will be executed successfully.
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
第1题:
You executed the following code: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( NAME => ’JOB_A’, ATTRIBUTE => ’JOB_PRIORITY’, VALUE => 7); END; / After analyzing the above code, what conclusion will you draw?()
第2题:
You have created a resource plan, DAY. You execute the following code: SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE ( PLAN => ’DAY’, COMMENT => ’DEPARTMENTS PLAN’, GROUP_OR_SUBPLAN => ’DEPARTMENTS’, CPU_P1=0); END; Then, you issue the following code: SQL> BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE ( PLAN => ’DAY’, COMMENT => ’DEPARTMENTS PLAN’, GROUP_OR_SUBPLAN => ’DEVELOPERS’, CPU_P2=100); END; What will be the impact of executing the above code?()
第3题:
You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?()
第4题:
You create a Web page named TestPage.aspx and a user control named TestUserControl.ascx. TestPage.aspx uses TestUserControl.ascx as shown in the following line of code.
第5题:
You are developing a Windows Communication Foundation (WCF) service to replace an existing ASMX Web service.The WCF service contains the following code segment. (Line numbers are included for reference only.) 01 [ServiceContract( )] 02 03 public interface IEmployeeService 04 { 05 [OperationContract( )] 06 EmployeeInfo GetEmployeeInfo(int employeeID); 07 08 } 09 10 public class EmployeeService : IEmployeeService 11 { 12 13 public EmployeeInfo GetEmployeeInfo(int employeeID) 14 { 15 ... 16 } 17 } 18 19 20 public class EmployeeInfo 21 { 22 ... 23 public int EmployeeID { get; set; } 24 public string FirstName { get; set; } 25 public string LastName { get; set; } 26 27 }The existing Web service returns the EmployeelD as an attribute of the Employeelnfo element in the response XML.You need to ensure that applications can consume the service without code changes in the client. What should you do?()
第6题:
SQL Access Advisor
Undo Advisor
Segment Advisor
SQL Tuning Advisor
第7题:
OHMJ
PINK
QJOL
POKE
第8题:
Replace the GridView control with a ListView control.
Set the ClientIDMode attribute to Predictable in the web.config file.
Set the ClientIDRowSuffix attribute of each unique GridView control to a different value.
Set the @ OutputCache directives VaryByControl attribute to the ID of the GridView control.
第9题:
A
B
C
D
第10题:
The statement will fail.
The statement will be executed successfully, and the new time zone will be set for the database.
The statement will be executed successfully, but the new time zone will be set for the current session.
The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
第11题:
The code will be executed successfully.
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
第12题:
A
B
C
D
第13题:
You created the ORDERS table in your database by using the following code: SQL> CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE); Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL> INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’); SQL> INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’); SQL> COMMIT; Next, you issued the following statement to change the time zone for the database: SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’; What will be the result of executing the above statement?()
第14题:
You issued the following block of code: SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP( ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE); END; SQL>/ Which option is NOT a result of executing the above code?()
第15题:
You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later you are asked to retrieve information from this application domain, which is the current application domain. What can you do to achieve this objective?()
第16题:
You work as an application developer at Certkiller .com. Certkiller .com has instructed you to create a class named MetricFormula. This class will be used to compare MetricUnit and EnglishUnit objects.The MetricFormula is currently defined as follows (Line numbers are used for reference purposes only): 1. public class MetricFormula2. { 3. 4. } You need to ensure that the MetricFormula class can be used to compare the required objects. What should you do? ()
第17题:
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?()
第18题:
Insert the following code at line 02. [DataContractFormat()] Insert the following code at line 22. [DataMember()]
Insert the following code at line 02. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAtttibute()]
Insert the following code at line 09. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAttribute()]
Insert the following code at line 19. [DataContractFormat()] Insert the following code at line 22. [DataMember()]
第19题:
The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.
The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.
The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.
The second code will not execute because one resource plan cannot be used by more than one subplan.
第20题:
The priority of the lne_job1 job would be set to 1.
The lne_job1 job would be executed synchronously.
The lne_job1 job would run immediately in the users current session.
The lne_job1 job would retain its current priority.
The job will immediately take priority over all running jobs.
第21题:
第22题:
Use the following code to declare the FindAttribute method: public T FindAttribute (T att) {//Find attribute and return the value }
Use the following code to declare the FindAttribute method: public object FindAttribute (object att) {//Find attribute and return the value }
Use the following code to declare the FindAttribute method: public T FindAttribute
Use the following code to declare the FindAttribute method: public string FindAttribute (string att) {//Find attribute and return the value }
第23题:
The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.
The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
第24题:
The switch privilege is granted to the PROG_ROLE role.
The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
The users cannot grant the switch privilege to other users.
The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.