You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A、The command produces an error.B、The profile is dropped and current user sessions use the DEFAULT profile immediately.C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user； Which statement describes the result（）
- A、The command produces an error.
- B、The profile is dropped and current user sessions use the DEFAULT profile immediately.
- C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
- D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
相关考题：
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.
What must be done in order to automatically close the purchase requisition （PR） after one or more purchase orders （PO） have been created？ （）A、 All PR lines must be assigned to a PO.B、 The PR must be in the Approved status.C、 The PR must enter the workflow process.D、 All manual company input fields must be completed.
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 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？（）ADBMS_SERVER_ALERTBDBMS_ADVISORCDBMS_RESOURCE_MANAGERDDBMS_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？（）AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe 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？（）AYou should consider having a new mail folder created using Microsoft Office Outlook. Thereafter a journal rule should e created.BYou 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.CYou should consider having a managed custom folder created. Thereafter a transport rule should be created.DYou 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? （）AThe table is accessible to all users.BTables are created in the public schema.CTables are created in your schema.DTables are created in the DBA schema.EYou 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.CBoth 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 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?（）AA policy should be created. The policy targets the name of the stored procedure that is evaluated on demand. BA policy should be created. The policy targets the name of the stored procedure that is evaluated on change. CA condition should be created. The condition targets the name of the stored procedure that is evaluated on change DA condition should be created. The condition targets the name of stored procedure that is evaluated on demand.
单选题What must be done in order to automatically close the purchase requisition （PR） after one or more purchase orders （PO） have been created？ （）A All PR lines must be assigned to a PO.B The PR must be in the Approved status.C The PR must enter the workflow process.D All manual company input fields must be completed.