You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）https://assets.asklib.com/images/image2/2018080110052310043.jpg

相似题目

• You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

  A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

  查看最佳答案

• You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）  

  A .  run { open script backup_database； run script backup_database } B .  run { engage script backup_database； } C .  run { run script backup_database； } D .  Run { execute script backup_database； } E .  The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

  查看最佳答案

• You want to create an RMAN recovery catalog in the RC01 database to help you manage the databases named DB01 and DB02. You need to create a recovery catalog owner in which of your databases？（）

  A . RCO1 only. B . DB01 only. C . DB02 only. D . DB01 and DB02 only. E . DB01，DB02，and RC01.

  查看最佳答案

• You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）

  A .  assign users to consumer groups B .  set the resource plan for the instance C .  configure a simple resource plan and specify plan directives D .  configure a complex resource plan and specify plan directive

  查看最佳答案

• In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）

  A . The CDB must be open. B . The CDB must be in the mount stage. C . The CDB must be in the nomount stage. D . Alt existing PDBs must be closed.

  查看最佳答案

• You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）

  A . More than one database is to be registered with the listener. B . The users will connect the database by using the host naming method. C . The Oracle Enterprise Manager is to be used to monitor an Oracle9i database. D . The database that is to be registered with the listener is configured in shared server mode. E . The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

  查看最佳答案

• You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）

  A . More than one database is to be registered with the listener. B . The users will connect the database by using the host naming method. C . The Oracle Enterprise Manager is to be used to monitor an Oracle9i database. D . The database that is to be registered with the listener is configured in shared server mode. E . The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

  A . Set the UNDO_RETENTION parameter to AUTO. B . Create an initial undo segment in undotablespace. C . Set the UNDO_RETENTION parameter to 900 or more D . Set the initialization parameter UNDO_MANAGEMENT to AUTO E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

  查看最佳答案

• You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

  A . BFILE  B . REF column  C . Object table  D . Column object  E . INSTEAD-OF trigger

  查看最佳答案

• View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

  A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

  查看最佳答案

• During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation？（）  

  A .  The installation terminates with an error. B .  The installation proceeds with the default value without warnings and errors. C .  The installation proceeds with the default value but it would not be an OFA-compliant database. D .  The installation proceeds with the default value but a message would be generated in the alert log file.

  查看最佳答案

• 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.

  查看最佳答案

• Your network contains two Exchange Server 2010 Mailbox servers.You create a database availability group （DAG）.You need to ensure that the Exchange servers can replicate mailbox databases.What should you do？（）

  A . Modify the membership list of the DAG B . Add the Network Load Balancing feature on both servers C . Add Active Directory Federation Services （AD FS） on both servers D . Enable Datacenter Activation Coordination （DAC） mode for the DAG

  查看最佳答案

• You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

  A . Shared pool  B . Control file  C . SGA  D . PGA

  查看最佳答案

• When performing a database duplication， which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location？（）  

  A .  log_file_name_convert B .  convert_log_file_name C .  file_name_convert_log D .  redo_log_file_name_convert E .  logfile_convert_directory

  查看最佳答案

• After you have restored and recovered a database to a new host by using a previously performed Recovery Manager （RMAN） backup， which is the best option you would consider for the new database？（）  

  A .  Opening the database in RESTRICTED mode B .  Opening the database with the RESETLOGS option C .  Setting a new DBID for the newly restored database D .  Restoring the server parameter file （SPFILE） to the new host

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）

  A . Information about each Oracle Net connection. B . Information about each entry in theLinstener.orafile C . Information about the changed done in the database D . Information about the different listeners in your system E . Information about all thenondatabasefiles required to operate the database

  查看最佳答案

• You create a Web application. You need to turn on Tracing for a page that is not performing well. You must store the trace information in a database for reporting and trending. Which two actions should you perform? （）

  A . Add a TraceContextEventHandler to the Trace.TraceFinished event to add the trace records into the database. B . Add a system.diagnostics section to the Web.config file. Then add a listener to the new section. C . Use the System.Diagnostics.Trace object to connect to a database. Then insert the trace records. D . In the Page_Load for the page, place the Trace.Write call into a SQL INSERT statement.

  查看最佳答案

• You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）

  A . SYSTEM B . SYSAUX C . EXAMPLE D . UNDO E . TEMP F . USERS

  查看最佳答案

• While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

  A . the CREATE TABLE .. command B . sorting of the SYSTEM tablespace’s data C . sorting of data required by recursive SQL statements D . the CREATE TABLE .. ORGANIZATION EXTERNAL .. command E . sorting of data if the users have not been allocated temporary tablespace explicitly F . sorting of data if the users have been allocated temporary tablespace explicitly

  查看最佳答案

• You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a class that implements the IHttpHandler interface. You implement the ProcessRequest method by using the following code segment. （）

  A．A B．B C．C D．D

  查看最佳答案

• You create a Windows client application by using Windows Presentation Foundation （WPF).The

  You create a Windows client application by using Windows Presentation Foundation (WPF).The application contains the following code fragment.You need to assign lbDetails to use the detail data template when btnDetails is clicked.Which code segment should you write for the click event handler for btnDetails？（） <img src='https://img2.soutiyun.com/shangxueba/ask/17127001-17130000/17129862/b303eb3bdcfa64c913a402ef5dff2a06.jpg' /> A.lbDetails.ItemsPanel.FindName(&quot;detail&quot;,lbDetails); B.var tmpl = (ControlTemplate)FindResource(&quot;detail&quot;); lbDetails.Template = tmpl; C.var tmpl = (DataTemplate)FindName(&quot;detail&quot;); lbDetails.ItemTemplate = tmpl; D.var tmpl = (DataTemplate)FindResource(&quot;detail&quot;); lbDetails.ItemTemplate=tmpl;

  查看最佳答案

• You create a new Automatic Database Diagnostic Monitor （ADDM) task: instance_analysis_mode

  You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this？（） <img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/f856003f497492b5fcd1516f347bc3b8.jpg' /> A. Add a finding directive for the ADDM task. B. Add a segment directive for the ADDM task. C. Add a parameter directive for the ADDM task. D. Disable the Segment Advisor from the Automatic Maintenance Task.

  查看最佳答案

• 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？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135882/b1559080aa448ecf1a5fe7380a121c8c.jpg' /> 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.

  查看最佳答案