单选题You are connecting to an Oracle database server from a client by using the following connect string:  SQL CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb  Which naming method is being used in this case?()ALocal NamingBEasy ConnectCExternal NamingDDirectory Naming

单选题
You are connecting to an Oracle database server from a client by using the following connect string:  SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb  Which naming method is being used in this case?()
A

Local Naming

B

Easy Connect

C

External Naming

D

Directory Naming


参考解析

解析: 暂无解析

相关考题:

You have a DHCP server that runs windows server 2008. You need to reduce the size of the DHCP database. What should you do?() A.From the DHCP snap-in, reconcile the database.B.From the folder that contains the DHCP database, run jetpack.exe dhcp.db temp.mdb.C.From the properties of the dhcp.mdb file, enabled the file is ready for archiving attribute.D.From the properties of the dhcp.mdb file, enable the compress contents to save diskspace attribute.

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL@utlu111i.sqlWhich statement about the execution of this script is true?()A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Which correctly describes the tiers of the Oracle Workflow architecture?() A. Oracle Database tier and Application server tier onlyB. Oracle Database tier, Application server tier, and End-user client tier onlyC. Oracle Database tier, Application server tier, and Development client tier onlyD. Oracle Database tier, Application server tier, Development client tier, and End-user client tier

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?() A. Effectively implements role separationB. Enables you to take advantage of Oracle Managed Files.C. Automatically registers the database with Oracle Restart.D. Helps you to easily upgrade the database from a prior release.E. Enables the Installation of Grid Infrastructure files on block or raw devices.

You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?A.Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.B.Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.C.Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.D.Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create reports on the SQL Server computer by using the minimum amount of disk space.What should you do?A.Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.B.Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.C.Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.D.Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

Integration between ()with "multi data sources" and() is defined as Gridlink for RAC (Real Application Clusters)A、 Oracle Weblogic Server; Oracle DatabaseB、 Oracle Weblogic Server clusters; Oracle DatabaseC、 Oracle Weblogic Server clusters; Oracle Database RACD、 Oracle OC4J; Oracle Database RAC

You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()A、Database ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()A、Application Server ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

Integration between () multidata sources and () is defined as the Grid Link for RAC.A、Oracle WebLogic Server; Oracle DatabaseB、Oracle WebLogic Server clusters; Oracle DatabaseC、Oracle WebLogic Server clusters; Oracle Database RACD、Oracle OC4J; Oracle Database RACE、Oracle WebLogic Server; Oracle OC4J

You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()A、The Oracle kernel will be placed in this location.B、The Oracle software will be placed in this location.C、The server parameter file (SPFILE) will be placed in this location.D、The database files will be placed in this location, if not specified explicitly.E、The location will be considered for the base of Oracle Managed Files (OMF).F、The location will be considered for the base of Optimal Flexible Architecture (OFA).

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? ()A、On the Oracle server. B、Locally in each form module. C、In an attached PL/SQL library D、On your file network server.

In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance?()A、Oracle Migration AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification.  Whichschema object enables the user to access the information from the remote database()A、ClusterB、Database linkC、Mapping tableD、Materialized view

You have an Exchange Server 2010 that contains a DAG named DAG1.Contains 3 Mailbox Servers including a server named Server 1. Server 1 fails.You restore Server 1.You need to ensure that Server 1 can replicate Mailbox Databases from DAG1. What should you do first?()A、Modify the GUID for Server 1B、Remove the object for Server 1 from DAG1C、Remove the default Mailbox Database from Server 1D、Disable log truncation for the Mailbox database in DAG1

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.

单选题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()A Oracle Migration AssistantB Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance

单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?()Acontrol fileBpassword fileClistener controller fileDcontrol file and password file

单选题Integration between ()with "multi data sources" and() is defined as Gridlink for RAC (Real Application Clusters)A Oracle Weblogic Server; Oracle DatabaseB Oracle Weblogic Server clusters; Oracle DatabaseC Oracle Weblogic Server clusters; Oracle Database RACD Oracle OC4J; Oracle Database RAC

单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()AWhen you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.BWhen a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.CWhen a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.DWhen you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

单选题You have just run this syntax to start the listener from the Listener Control utility:   LSNRCTLSTART   Starting /mstgelai/oracle/bin/tnslsnr: please wait…  System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to…  The command completed successfully   What is the name of the Listener you started?()ATNSLSNRBLISTENERCLOCAL_LISTENERDDEFAULT_LSRN

单选题You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? ()AOn the Oracle server. BLocally in each form module. CIn an attached PL/SQL library DOn your file network server.

多选题What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?()AEffectively implements role separationBEnables you to take advantage of Oracle Managed Files.CAutomatically registers the database with Oracle Restart.DHelps you to easily upgrade the database from a prior release.EEnables the Installation of Grid Infrastructure files on block or raw devices.

单选题Integration between () multidata sources and () is defined as the Grid Link for RAC.AOracle WebLogic Server; Oracle DatabaseBOracle WebLogic Server clusters; Oracle DatabaseCOracle WebLogic Server clusters; Oracle Database RACDOracle OC4J; Oracle Database RACEOracle WebLogic Server; Oracle OC4J

单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility

单选题You are connecting to an Oracle database server from a client by using the following connect string:  SQL CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb  Which naming method is being used in this case?()ALocal NamingBEasy ConnectCExternal NamingDDirectory Naming

单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script:   SQL@utlu111i.sql   Which statement about the execution of this script is true?()A It must be executed from the Oracle Database 11g environment.B It must be executed only after the SYSAUX tablespace has been created.C It must be executed from the environment of the database that is being upgraded.D It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.