-
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set?()
A . DBMS_WORKLOAD_REPOSITORY
B . DBMS_RESOURCE_MANAGER
C . DBMS_SQLTUNE
D . DBMS_ADVISOR
-
You are designing a forest structure to meet the business and technical requirements. How many forests should you create?()
A . One
B . Two
C . Three
D . Four
-
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? ()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
You are evaluating the implementation of Microsoft Application Virtualization (App-V) to deploy App2. What is the minimum number of application packages you should create?()
A . 2
B . 3
C . 4
D . 1
-
You are developing a custom-collection class.You need to create a method in your class. You need to ensure that the method you create in your class returns a type that is compatible with the Foreach statement. Which criterion should the method meet?()
A . The method must return a type of either IEnumerator or IEnumerable.
B . The method must return a type of IComparable.
C . The method must explicitly contain a collection.
D . The method must be the only iterator in the class.
-
Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?()
A . SRW.BREAK
B . SRW.SET_ALTER
C . SRW.REFERENCE
D . SRW.DO_SQL
E . SRW.RUN_REPORT
F . SRW.SET_FIELD
-
You have a print server that runs Windows Server 2003 Service Pack 2 (SP2). You need to create a report of all the printers that are on the server and the drivers that they use. What should you do?()
A . Open The Printers and Faxes control panel applet and select the details view. Take a screen capture of the Printers and Faxes window.
B . Run the command %systemroot%\system32\net.exe share > printers.txt.
C . Run the command cscript %systemroot%\system32\prnmngr.vbs –l > printers.txt.
D . Run the command cscript %systemroot%\system32\prnport.vbs -l > printers.txt.
-
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan?()
A . RATIO
B . EMPHASIS
C . ACTIVE_SESS_POOL_MTH
D . RESOURCE_DEGREE_LIMIT_ABSOLUTE
-
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?()
A . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
B . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C . CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
E . CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE
-
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte?()
A . This clause is not valid for a temporary or undotablespace.
B . If thetablespaceis in the NOLOGGING mode, no operation on thetablespacewill generate redo.
C . Thetablespacewill be IntheNOLOGGING mode by default, if not specified while creating atablespace.
D . Thetablespace-level logging attribute can be overridden by logging specification at the table, index, materialized view, materialized view log, and partition levels.
-
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?()
A . SYSTEM
B . OUTLN
C . INTERNAL
D . SYS
-
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()
A . The source database backup must be copied over the net for test database.
B . The source database must be run in ARCHIVELOG mode if the database is open.
C . The source database must be shut down cleanly if the database is in mounted state.
D . A net service name should be set up and a listener configured with the target as well as the source database.
-
You executed the following command to create a tablespace called SALES_DATA: > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace ()
A . The database automatically determines the extent-sizing policy for the tablespace.
B . The segments are automatically shrunk when the contents are removed from them.
C . The allocation of extents within the tablespace is managed through the dictionary tables.
D . The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E . The space utilization description of the data blocks in segments is managed through free lists.MANUAL
-
You are designing a migration strategy to create user IDs for all company users in the new environment. What should you do?()
A . Create a script that uses Active Directory Services Interfaces (ADSI) to import all user account into the new environment.
B . Create new accounts for all users. Create a trust relationship between the existing environment and the new environment to enable access to resources in the existing environment.
C . Import all user accounts into the new environment by using the Active Directory Migration Tool (ADMT).
D . Import all user accounts into the new environment. Instruct users to no change their passwords during the migration phase so that they can access resources in the existing environment.
-
You create a tabular employee report and are concerned about readability because the employee records are very close together. What is the best way to increase the amount of white space between the records?()
A . In the layout model increase the size of the employee record fields.
B . In the report wizard increase the display width values of the employee record fields.
C . In the property palette increase the size of the repeating frame surrounding the employee records.
D . In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.
-
You are designing a forest structure to meet the business and technical requirements. How many forests should you create?()
A . One
B . Two
C . Three
D . Four
-
You use Microsoft .Net Framework 4 to create a Windows Form application. You created a new application, you then wrote the code below: Thread.CurrentThread.CurrentUICulture = Thread.CurrentThread.CurrentCulture Which of the following options are TRUE? ()
A . The user interface will make use of the currently configured culture settings in the Control Panel at present.
B . The user interface will make use of new culture settings.
C . The user interface will make use of the culture settings that were installed with the operating system.
-
You are developing an application to create a new file on the local file system.You need to define specific security settings for the file. You must deny the file inheritance of any default security settings during creation.What should you do?()
A . Create the file by using a new FileStream object by passing the FileSecurity object as a parameter to the FileStream constructor.
B . Create a new FileSecurity object.
C . Apply the permissions by using the File class.
D . Create a new FileSystem Access Rule object for each permission that you need,and add each rule to the FileSecurity object.
E . Create a new FileSystem Audit Rule object and add it to the FileSecurity object.
-
You create a mobile Web application. You need to use a Command control to post user input from the UI elements back to the server. What are two possible ways to achieve this goal?()
A . Place the Command control within an instance of the System.Web.UI.MobileControls.SelectionList control.
B . Place the Command control within an instance of the System.Web.UI.MobileControls.ObjectList control.
C . Place the Command control within an instance of the System.Web.UI.MobileControls.Form control.
D . Place the Command control within an instance of the System.Web.UI.MobileControls.Panel control.
-
You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group?()
A . CPU_MTH
B . NEW_CPU_MTH
C . CPU_P1
D . CPU_P2
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? ()
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
-
You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.
You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.
What should you do?
A.Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.
B.Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.
C.Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.
D.Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.
-
You are the network administrator for All servers run Windows Server 2003.You are creating a backup schedule for the main file server.You need to create a schedule so that backup jobs are completed in the shortestamount of time possible.What should you do?()
A. Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.
B. Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.
C. Schedule a copy backup every day.
D. Schedule a normal backup every day.
-
How can you initiate the source determination when you create a purchase requisition manually? There are 2 correct answers to this question.()
A.Use the button Assign Source of Supply in the header of the purchase requisition
B.Set the indicator for automatic source determination in the respective item of the purchase requisition
C.Set the indicator for automatic source determination in the header of the purchase requisition before you enter purchase requisition items
D.Use the button Assign Source of Supply in the respective item of the purchase requisition
此题为多项选择题。