单选题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?()A The code will be executed successfully.B The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.C The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.D The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
单选题
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?()
A
The code will be executed successfully.
B
The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.
C
The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
D
The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
参考解析
解析:
暂无解析
相关考题:
Youexecutedthefollowingcode:BEGINDBMS_SCHEDULER.SET_ATTRIBUTE(NAME=’JOB_A’,ATTRIBUTE=’JOB_PRIORITY’,VALUE=7);END;/Afteranalyzingtheabovecode,whatconclusionwillyoudraw?() A.Thecodewillbeexecutedsuccessfully.B.ThecodewillnotbeexecutedsuccessfullybecausethevalueoftheVALUEparametermustbe1,2,or3.C.ThecodewillnotbeexecutedsuccessfullybecausethevalueoftheVALUEparametermustrangebetween1and5.D.ThecodewillnotbeexecutedsuccessfullybecausenoSET_ATTRIBUTEprocedureexistsintheDBMS_SCHDULERpackage.
You accepted the recommended SQL Profile by executing the following code: DECLARE sqlprofile_name varchar2(30); BEGIN sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE( task_name = ’my_task’, profile_name = ’my_profile’); END; Which advisor will analyze this profile?() A、 SQL Access AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor
Consider the following code snippet: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( name = ,,lne_job1, attribute = ,,job_priority, value = 1); END; / If this code were executed, which of the following statements would be true?()A、 The priority of the lne_job1 job would be set to 1.B、 The lne_job1 job would be executed synchronously.C、 The lne_job1 job would run immediately in the users current session.D、 The lne_job1 job would retain its current priority.E、 The job will immediately take priority over all running jobs.
Where can you add your own PL/SQL code in relation-handling triggers?()A、Before the "End default relation program section" comment. B、After the "Begin default relation program section" comment. C、Before the "Begin default relation program section" comment. D、It is not possible to modify the relation-handling code that Forms automatically creates for relations.
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?() A、 The code will be executed successfully.B、 The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
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?() A、 The statement will fail.B、 The statement will be executed successfully, and the new time zone will be set for the database.C、 The statement will be executed successfully, but the new time zone will be set for the current session.D、The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
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?() A、 The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B、 The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C、 The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D、 The second code will not execute because one resource plan cannot be used by more than one subplan.
You issued the following block of code: SQLBEGIN 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?() A、 The switch privilege is granted to the PROG_ROLE role.B、 The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.C、 The users cannot grant the switch privilege to other users.D、 The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.
You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?() A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C、 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.D、 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.
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?()A、 Use the following code: AppDomain appInfo = ApplicationDomain.Current;B、 Use the following code: AppDomain appInfo = AppDomain.CurrentDomain ();C、 Use the following code: AppDomain appInfo = Thread.GetDomain ();D、 Use the following code: AppDomain appInfo = MainThread.GetDomain ();
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. On TestUserControl.ascx, you need to add a read-only member named CityName to return the value "New York". You also must add code to TestPage.aspx to read this value. Which two actions should you perform?()A、Add the following line of code to the TestUserControl.ascx.cs code-behind file. public string CityName { get { return "New York"; } } B、Add the following line of code to the TestUserControl.ascx.cs code-behind file. protected readonly string CityName = "New York"; C、Add the following code segment to the TestPage.aspx.cs code-behind file. protected void Page_Load(object sender, EventArgs e) { string s = testControl.CityName; } D、Add the following code segment to the TestPage.aspx.cs code-behind file. protected void Page_Load(object sender, EventArgs e) { string s = testControl.Attributes["CityName"]; }
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? ()A、 Add the following code on line 1: : IComparable {B、 Add the following code on line 1: : IComparer {C、 Add the following code on line 3: public int Compare (object x, object y) {// implementation code }D、 Add the following code on line 3: public int CompareTo (object obj) {// implementation code }
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?()A、Insert the following code at line 02. [DataContractFormat()] Insert the following code at line 22. [DataMember()]B、Insert the following code at line 02. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAtttibute()]C、Insert the following code at line 09. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAttribute()]D、Insert the following code at line 19. [DataContractFormat()] Insert the following code at line 22. [DataMember()]
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?()A、 Use the following code to declare the FindAttribute method: public T FindAttribute (T att) {//Find attribute and return the value }B、 Use the following code to declare the FindAttribute method: public object FindAttribute (object att) {//Find attribute and return the value }C、 Use the following code to declare the FindAttribute method: public T FindAttribute (T att) {//Find attribute and return the value }D、 Use the following code to declare the FindAttribute method: public string FindAttribute (string att) {//Find attribute and return the value }
单选题You accepted the recommended SQL Profile by executing the following code: DECLARE sqlprofile_name varchar2(30); BEGIN sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE( task_name = ’my_task’, profile_name = ’my_profile’); END; Which advisor will analyze this profile?()A SQL Access AdvisorB Undo AdvisorC Segment AdvisorD SQL Tuning Advisor
单选题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?()AInsert the following code at line 02. [DataContractFormat()] Insert the following code at line 22. [DataMember()]BInsert the following code at line 02. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAtttibute()]CInsert the following code at line 09. [XmlSerializerFormat()] Insert the following code at line 22. [XmlAttribute()]DInsert the following code at line 19. [DataContractFormat()] Insert the following code at line 22. [DataMember()]
单选题ABCDEFGHIJKLMNOPQRSTUVWXYZ The alphabet is here to help you with these questions. You need to work out a different code for each question.Example If the code for FOOT is ENNS, what is the code for TOE?Answer SND If the code for ORANGE is RUDQJH, what does SLQN mean?AOHMJBPINKCQJOLDPOKE
单选题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?()A The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D The second code will not execute because one resource plan cannot be used by more than one subplan.
单选题You are implementing an ASP.NET application that uses data-bound GridView controls in multiple pages. You add JavaScript code to periodically update specific types of data items in these GridView controls. You need to ensure that the JavaScript code can locate the HTML elements created for each row in these GridView controls, without needing to be changed if the controls are moved from one page to another. What should you do?()AReplace the GridView control with a ListView control.BSet the ClientIDMode attribute to Predictable in the web.config file.CSet the ClientIDRowSuffix attribute of each unique GridView control to a different value.DSet the @ OutputCache directives VaryByControl attribute to the ID of the GridView control.
单选题Consider the following code snippet: BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE ( name = ,,lne_job1, attribute = ,,job_priority, value = 1); END; / If this code were executed, which of the following statements would be true?()A The priority of the lne_job1 job would be set to 1.B The lne_job1 job would be executed synchronously.C The lne_job1 job would run immediately in the users current session.D The lne_job1 job would retain its current priority.E The job will immediately take priority over all running jobs.
单选题You are developing an application that runs by using the credentials of the end user. Only users who are members of the Administrator group get permission to run the application. You write the following security code to protect sensitive data within the application.bool isAdmin=false; WindowsBuiltInRole role=WindowsBuiltInRole.Administrator; ...... if(!isAdmin) throw new Exception("User not permitted"); You need to add a code segment to this security code to ensure that the application throws an exception if a user is not a member of the Administrator group. Which code segment should you use?()A AB BC CD D
问答题ABCDEFGHIJKLMNOPQRSTUVWXYZ The alphabet is here to help you with these questions.You need to work out a different code for each question.Choose the correct answer.ExampleIf the code for FOOT is ENNS,what is the code for TOE? Answer:SND.If the code for ORANGE is RUDQJH, what does SLQN mean?A.OHMJB.PINKC.QJOLD.POKE
单选题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?()A The statement will fail.B The statement will be executed successfully, and the new time zone will be set for the database.C The statement will be executed successfully, but the new time zone will be set for the current session.DThe statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
单选题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?()A Use the following code to declare the FindAttribute method: public T FindAttribute (T att) {//Find attribute and return the value }B Use the following code to declare the FindAttribute method: public object FindAttribute (object att) {//Find attribute and return the value }C Use the following code to declare the FindAttribute method: public T FindAttribute (T att) {//Find attribute and return the value }D Use the following code to declare the FindAttribute method: public string FindAttribute (string att) {//Find attribute and return the value }
单选题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?()A The code will be executed successfully.B The code will not be executed successfully because the value of the VALUE parameter must be 1, 2, or 3.C The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.D The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
单选题You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?()A The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.B The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.C 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.D 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.
单选题You work as an application developer at Certkiller .com. You have recently created a multithreaded application to manage Certkiller .com’s inventory system. The fulfillment task has to be executed on a regular basis, while other tasks are performed in the application. The task does not need any input to start. You are required to create and start the fulfillment thread using the appropriate code.What code should you use?()A AB BC CD D
单选题You issued the following block of code: SQLBEGIN 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?()A The switch privilege is granted to the PROG_ROLE role.B The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.C The users cannot grant the switch privilege to other users.D The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.