网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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 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 NamingB Easy ConnectC External NamingD 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?()A
control fileB
password fileC
listener controller fileD
control 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?()A
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D
When 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?()A
TNSLSNRB
LISTENERC
LOCAL_LISTENERD
DEFAULT_LSRN
考题
单选题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.
考题
多选题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.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 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?()A
use the external table populationB
use the Oracle Data Pump export and import utilityC
use the conventional path data load of SQL*Loader utilityD
use 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?()A
Local NamingB
Easy ConnectC
External NamingD
Directory 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.
热门标签
最新试卷