You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15）） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.D、 You cannot shrink the SCOTT.EMP table.

考题 You have developed an application that simplifies hard drive management for Certkiller .com‘s administrators.The application that you created logs all modifications made to physical hard drives on an hourly basis.You now need to create an EventQuery object for this application.What should you do?（）A.B.C.D.

查看答案

考题 You have recently created an application, and want to capture all debugging text messages generated by it.You would like these debugging messages to display on the command line. The application that you created contains the following code:Debug.WriteLine (Start the processing);Console.WriteLine (Generated by Console.WriteLine);Debug.WriteLine (End the processing);You need to ensure that you are able to capture all debugging messages to the command line.What should you do?（）A.B.C.D.

查看答案

考题 You would like to create a custom performance counter for an application that you created recently.To do this, you decide to create a custom category named ApplicationPerformance and a performance counter named HitNumber.You need to ensure that this counter is shared across numerous applications.What should you do?（）A.B.C.D.

查看答案

考题 Which describes the default behavior when you create a table? () A. The table is accessible to all users.B. Tables are created in the public schema.C. Tables are created in your schema.D. Tables are created in the DBA schema.E. You must specify the schema when the table is created.

查看答案

考题 While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

查看答案

考题 The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）A、You obtain the results retrieved from the public synonym HR created by the database administrator.B、You obtain the results retrieved from the HR table that belongs to your schema.C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

查看答案

考题 You are employed as the Exchange administrator at Company.com.The Company.com network contains an Exchange 2010 Organization.Company.com has its headquarters in Stockholm where you are located.During the course of the week you receive an instruction from the CIO to make sure those messages in the Inbox folder of a Company.com employee named Kara Lang is moved to a custom folder when it reaches 50 days. What should you do？（）A、You should consider having a new mail folder created using Microsoft Office Outlook. Thereafter a journal rule should e created.B、You should consider having a new mail folder created using Microsoft Office Outlook.Thereafter the Managed Content Settings wizard should be run from the Inbox manage default folder.C、You should consider having a managed custom folder created. Thereafter a transport rule should be created.D、You should consider having a managed custom folder created.Thereafter the Managed Content Settings wizard should be run from the Inbox managed default folder.

查看答案

考题 You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）A、 .SQL B、 .PLL C、 .PLDD、 .PRT

查看答案

考题 While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、 A primary key must have been created.B、 A mapping table must have been created.C、 An overflow tablespace must have been specified.D、 The PCTTHRESHOLD option must have been specified.

查看答案

考题 Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A windows group must have been created with the WEEKEND_PLAN resource plan.

查看答案

考题 You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization named Company.com.All Company.com users make use of their Personal Archive. A new Company.com directive states hat messages be moved from the mail box of users to their Personal Archive after 60 days.What should you do？（）A、You should consider running the New Managed Content Settings wizard and creating a new managed folder mailbox policy.Thereafter the policy should be applied to all users.B、You should consider creating a managed custom folder.Then the New Managed Content Settings wizard should be run and a journal rule created.C、You should consider having a retention tag created.Then the retention tag should be assigned to a retention policy.Thereafter the retention policy should be applied to all users.D、You should consider having a retention tag created.Then the retention tag should be assigned to a retention policy. Thereafter a journal rule should be created.

查看答案

考题 You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messagingsolution.During the course of the business week you receive instruction from Company.com to have a set of cmdlets grouped for administrative delegation of duties.What should you do？（）A、You should consider having a new management role created.B、You should consider having a new role assignment policy created.C、You should consider having a managed folder mailbox policy created.D、You should consider having a new distribution group created.

查看答案

考题 You work as the Exchange administrator at Company.com.The Company.com network contains an Exchange Server 2010 Organization.Company.com has its headquarters in Stockholm where you are located.The Marketing department contains 5，000 employees that are members of a group named TKPRODUCTS.You receive an instruction from management to make sure that an informative message is shown when employees add TKPRODUCTS to the recipient list of e-mail messages.What should you do？（）A、You should consider having a transport rule created.B、You should consider having a Send connector created.C、You should consider having a MailTip configured.D、You should consider having an expansion server configured.

查看答案

考题 You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.Company.com has recently acquired a new Internet domain name from the Service Provider （SP）.During the course of the business week you receive instruction from Company.com to ensure that allthe network users are able to send and receive e-mail messages sent to the newly acquired domain name. What should you do？（）A、You should consider having an accepted domain created.B、You should consider having an e-mail address policy created.C、You should consider having the properties of the default Receive connector modified.D、You should consider having a sharing policy created.E、You should consider having a remote domain created.

查看答案

考题 You work as a network exchange administrator at company.com.the company.com network currently consists of a single active directory forest containing a single domain named company.com.the company.com organization makes use of microsoft exchange server 2010 as their messaging solution.company.com has recently acquired a new internet domain name from the internet service provider （isp）.during the course of the business week you receive instruction from company.com to ensure that all the network users are able to send and receive e-mail messages sent to the newly acquired domain name. What should you do？（）A、you should consider having an accepted domain and an e-mail address policy created.B、you should consider having the properties of the default receive connector modified.C、you should consider having an accepted domain and a sharing policy created.D、you should consider having a remote domain and an e-mail address policy created.

查看答案

考题 You are employed as the exchange administrator at Company.com.the Company.com network contains an exchange server 2010 organization.Company.com has its headquarters in chicago where you are located.The organization contains a single server named -ex01.you receive numerous complaints from users stating that they receive a vast amount of spam messages.management wants you to decrease the amount of spam users in the organization receive. What should you do？（）A、Your best option would be to have a Transport Protection Rule created.Thereafter a journal rule can be created.B、Your best option would be to run the Install-AntispamAgents.ps1 script.Thereafter the transport agents can be configured.C、Your best option would be to have a journal rule created.Thereafter an Outlook Protection Rule can be created.D、Your best option would be to run the AntispamCommon.ps1 script.Thereafter a Transport Protection Rule can be created.

查看答案

考题 You work as a network Exchange administrator at Company.com.Company.com has its headquarters located in Miami and branch office located in Toronto.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.Company.com has recently made the Toronto office administrators members of a custom management role group which is configured to allow members to manage recipients.During your routine maintenance you discover that Toronto office administrators are able to manage recipients in both offices.During the course of the business week you receive instruction from Company.com to ensure that the Toronto office administrators are able to manage recipients in the Toronto office only. What should you do？（）A、You should consider having a new linked role group created.You should then have the Toronto office administrators added to the role group.B、You should consider having a new role created.You should then have the management role entries added to the role.C、You should consider having a management scope created and associated to the role group.D、You should consider having a management role assignment policy created and associated to the role group.

查看答案

考题 You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.The Company.com network users have been configured by Company.com to have the @Company.com email address suffix.During the course of the business week you receive instruction from Company.com to configure a public folder named KingPublic for the Internet users to post content by sending e-mail to KingPublic@Company.com. What should you do？（）A、You should consider having a new mail contact created which has the e-mail address KingPublic@Company.com.You should then have a transport rule created.B、You should consider having a new mailbox created which has the e-mail address KingPublic@Company.com.You should then have a transport rule created.C、You should consider having mail enabled for KingPublic.D、You should consider having the author role assigned to Anonymous.

查看答案

考题 You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to make use of Role Based Access Control （RBAC） to provide a user named Rory Allen the ability to manage recipients in a specific organizational unit （OU）. What should you do？（）A、You should consider having a new management scope created.B、You should consider having the default management scope modified.C、You should consider having a new direct role assignment created.D、You should consider having a new management role assignment policy created.

查看答案

考题单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）A DBMS_SERVER_ALERTB DBMS_ADVISORC DBMS_RESOURCE_MANAGERD DBMS_REPAIR

查看答案

考题单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.

查看答案

考题单选题While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A A primary key must have been created.B A mapping table must have been created.C An overflow tablespace must have been specified.D The PCTTHRESHOLD option must have been specified.

查看答案

考题单选题While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A A primary key must have been created.B A mapping table must have been created.C An overflow tablespace must have been specified.D The PCTTHRESHOLD option must have been specified.

查看答案

考题单选题You are employed as the Exchange administrator at Company.com.The Company.com network contains an Exchange 2010 Organization.Company.com has its headquarters in Stockholm where you are located.During the course of the week you receive an instruction from the CIO to make sure those messages in the Inbox folder of a Company.com employee named Kara Lang is moved to a custom folder when it reaches 50 days. What should you do？（）A You should consider having a new mail folder created using Microsoft Office Outlook. Thereafter a journal rule should e created.B You should consider having a new mail folder created using Microsoft Office Outlook.Thereafter the Managed Content Settings wizard should be run from the Inbox manage default folder.C You should consider having a managed custom folder created. Thereafter a transport rule should be created.D You should consider having a managed custom folder created.Thereafter the Managed Content Settings wizard should be run from the Inbox managed default folder.

查看答案

考题单选题Which describes the default behavior when you create a table? （）A The table is accessible to all users.B Tables are created in the public schema.C Tables are created in your schema.D Tables are created in the DBA schema.E You must specify the schema when the table is created.

查看答案

考题单选题You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently， two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action？（）A Both the sessions will be killed， and no new sessions will be created using the SYSDBA or SYSOPER privilege.B Both the sessions will remain active， but no new sessions will be created using the SYSDBA or SYSOPER privilege.C Both the sessions will be killed， but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.D The database will crash， and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.

查看答案

考题单选题You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）A .SQL B .PLL C .PLDD .PRT

查看答案

考题单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?（）A A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand. B A policy should be created. The policy targets the name of the stored procedure that is evaluated on change. C A condition should be created. The condition targets the name of the stored procedure that is evaluated on change D A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：