Oracle认证考试
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
题目
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.
相似问题和答案
第1题：
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.
第2题：
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.
正确答案:B
第3题：
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.
第4题：
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、 .PLD
- D、 .PRT
正确答案:B
第5题：
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.
正确答案:D
第6题：
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.
第7题：
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.
正确答案:B
第8题：
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.
第9题：
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.
正确答案:A
第10题：
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.
正确答案:B