网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
Which one of the following statements about the TNSPING utility is correct?()
A
It helps you to determine whether or not the Oracle database is running.
B
It requires the username and password to check the connectivity of the service.
C
It does not require the username and password to check the connectivity of the service.
D
It establishes a session with the database and checks the connectivity of the service.
参考答案
参考解析
解析:
暂无解析
更多 “单选题Which one of the following statements about the TNSPING utility is correct?()A It helps you to determine whether or not the Oracle database is running.B It requires the username and password to check the connectivity of the service.C It does not require the username and password to check the connectivity of the service.D It establishes a session with the database and checks the connectivity of the service.” 相关考题
考题
Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA.ⅠonlyB.Ⅱ onlyC.Ⅰ and ⅡD.none of the above
考题
Among the following post-listening activities, which one helps the teacher determine whether or not students have got the gist of what they have listened to?()
A.summaryB.discussionC.role playD.simulation
考题
You are an experienced network administrator in an international corporation. One of your clients asks you to configure a network for a financial trading center which requires multiple high-value transactions.And the transactions are very important to the client. In such a situation, which two of the following are basic and most important requirements concerning the configuration? ()(Choose two.)A. no single point of failureB. determine which protocol to useC. trading database server locationD. deterministic response to all failures
考题
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?() A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.
考题
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data
考题
You are an experienced network administrator in an international corporation. One of your clients asks you to configure a network for a financial trading center which requires multiple high-value transactions. And the transactions are very important to the client. In such a situation, which two of the following are basic and most important requirements concerning the configuration? ()(Choose two.)A、no single point of failureB、determine which protocol to useC、trading database server locationD、deterministic response to all failures
考题
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()A、Oracle Net ManagerB、Listener Control utilityC、Database Configuration AssistantD、Oracle Net Configuration Assistant
考题
You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?()A、It records the usernames and passwords of users when granted the DBA role.B、It contains the usernames and passwords of users for whom auditing is enabled.C、Is used by Oracle to authenticate users for remote database administration.D、It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.E、It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
考题
You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?()A、Corrupted blocks, if any, are repaired.B、Checks are performed for physical corruptions.C、Checks are performed for logical corruptions.D、Checks are performed to confirm whether all database files exist in correct locationsE、Backup sets containing both data files and archive logs are created.
考题
While planning to manage more than one database in your system, you perform the following activities: 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you?()A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture
考题
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data.
考题
You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct regarding the connection string?()A、mydb is a service name.B、test.us.oracle.com is a database name.C、1521 is the listener port number.D、mydb is a host name.E、test.us.oracle.com is a net service name.F、hr is a username.G、test.us.oracle.com is an instance name.
考题
Which one of the following statements about the TNSPING utility is correct?()A、It helps you to determine whether or not the Oracle database is running.B、It requires the username and password to check the connectivity of the service.C、It does not require the username and password to check the connectivity of the service.D、It establishes a session with the database and checks the connectivity of the service.
考题
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
考题
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()A、SYSTEM B、OUTLN C、INTERNAL D、SYS
考题
You create 200 new user accounts. The users are located in six different sites. New users report that they receive the following error message when they try to log on: "The username or password is incorrect." You confirm that the user accounts exist and are enabled. You also confirm that the user name and password information supplied are correct. You need to identify the cause of the failure. You also need to ensure that the new users are able to log on Which utility should you run()A、RsdiagB、RstoolsC、RepadminD、Active Directory Domains and Trusts
考题
多选题You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?()AIt records the usernames and passwords of users when granted the DBA role.BIt contains the usernames and passwords of users for whom auditing is enabled.CIs used by Oracle to authenticate users for remote database administration.DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
考题
多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command: RESTORE CONTROLFILE FROM AUTOBACKUP; Which of the following statements is true?()AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
考题
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?()A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
考题
单选题You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database()A
Use the external table population.B
Use the Oracle Data Pump export and import utility.C
Use the conventional path data load of the SQL*Loader utility.D
Use the INSERT INTO...SELECT command to load the data.
考题
单选题You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data, you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database()A
Use the external table population.B
Use the Oracle Data Pump export and import utility.C
Use the conventional path data load of the SQL*Loader utility.D
Use the INSERT INTO...SELECT command to load the data
考题
单选题You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()A
Library cache B
Row cacheC
Dictionary cache D
Large area E
Buffer cache
考题
单选题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 connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct regarding the connection string?()Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.
考题
单选题Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()A
V$DATABASEB
V$UNDOSTATC
V$FLASHBACK_DATABASE_LOGD
V$FLASHBACK_DATABASE_STAT
考题
单选题You create 200 new user accounts. The users are located in six different sites. New users report that they receive the following error message when they try to log on: "The username or password is incorrect." You confirm that the user accounts exist and are enabled. You also confirm that the user name and password information supplied are correct. You need to identify the cause of the failure. You also need to ensure that the new users are able to log on. Which utility should you run()A
RsdiagB
RstoolsC
RepadminD
Active Directory Domains and Trusts
考题
单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()A
SYSTEM B
OUTLN C
INTERNAL D
SYS
热门标签
最新试卷