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 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
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database()

  • A、Use the database link.
  • B、Use the SQL*Loader utility.
  • C、Use the Oracle Data Pump utility.
  • D、Create an external table and leave the data in the flat file

正确答案:D

第2题:

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 Files
  • B、Oracle Grid Architecture
  • C、Optimal Flexible Architecture
  • D、Oracle database architecture

正确答案:C

第3题:

ou need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.  Which statement is true regarding the ACL created?()

  • A、 It is a list of remote database links stored in the XML file that are available to the users of the database.
  • B、 It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
  • C、 It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
  • D、 It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.

正确答案:B

第4题:

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file?()

  • A、Restore all the data files and open the database
  • B、Create the data file and performtablespacerecovery
  • C、No need to restore any file, just recover the database
  • D、Restore only the system data file and recover the database
  • E、Restore only lost date file and performtablespacerecovery

正确答案:A

第5题:

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups.  Which two backups would you be able to perform when the database is being accessed by users?()

  • A、backup of offline tablespaces
  • B、backup of read­only tablespaces
  • C、backup of system­critical tablespaces
  • D、backup of online, locally managed tablespaces
  • E、backup of read/write dictionary­managed tablespaces

正确答案:A,B

第6题:

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 Assistant
  • B、 Recovery Manager (RMAN)
  • C、 Oracle Data Pump Export and Import
  • D、 conventional Oracle Export and Import
  • E、 operating system utilities to copy the files to the ASM instance

正确答案:B

第7题:

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()

  • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
  • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
  • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
  • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
  • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

正确答案:D

第8题:

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

正确答案:C

第9题:

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 Assistant
  • B、Recovery Manager (RMAN)
  • C、Oracle Data Pump Export and Import
  • D、conventional Oracle Export and Import
  • E、operating system utilities to copy the files to the ASM instance

正确答案:B

第10题:

You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()

  • A、The trace file
  • B、The fixed views
  • C、The data dictionary views
  • D、The operating system log fields
  • E、The dynamic performance views.

正确答案:E

更多相关问题