You observe that the senior database administrator always us

题目
单选题
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()
A

 RMAN would use the current operating system location to place the backup.

B

 RMAN would use the control file of the target database to maintain the backup.

C

 RMAN would use the recovery catalog of the target database to maintain the backup.

D

 RMAN would use the control file of the target database to maintain the backup metadata.

E

 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

参考答案和解析
正确答案: B
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()

  • A、Use a flashback query to retrieve the rows that were deleted
  • B、Useconventialincremental export and then import the affected object
  • C、Shutdown the database inNORMALmode and restart the database instance
  • D、Use DBMS_META package to reconstruct the object using undo segments
  • E、UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the data
  • F、Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

正确答案:B,E

第2题:

You observe that in your PROD database, customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task?()

  • A、functions
  • B、packages
  • C、procedures
  • D、database triggers
  • E、anonymous PL/SQL block

正确答案:D

第3题:

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 Control
  • B、Management Server
  • C、Management Repository
  • D、Application Server Control
  • E、Oracle Management Agent

正确答案:E

第4题:

单选题
The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective? ()
A

set the SESSIONS to 1 in the parameter file

B

grant SINGLE SESSION privilege to all of the users

C

set the SESSIONS_PER_USER to 1 in the users’ profile

D

grant RESTRICTED SESSION privilege to all of the database users

E

create a role with SINGLE SESSION privilege and assign the role to the users


正确答案: B
解析: 暂无解析

第5题:

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP:Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified.  From the flowing four options, which one is the most possible cause of the problem?()

  • A、The sp_executesql batches are not being recovered from the procedure cache.
  • B、A database administrator executed UPDATE STATISTICS statements on all tables, and the most common stored procedures reference all the tables.
  • C、One new stored procedure is created by a database administrator.
  • D、Ad hoc batches are not being recovered from the procedure cache.

正确答案:B

第6题:

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings, you find that the following parameter has been set in the parameter file of the database:  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?()

  • A、to enable operating system authentication for a remote client
  • B、to restrict the scope of administration to identical operating systems
  • C、to allow the start up and shut down of the database from a remote client
  • D、to enable the administration of the operating system from a remote client
  • E、to disable the administration of the operating system from a remote client

正确答案:A

第7题:

You work as a senior administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. All servers on the ABC.com network have Windows Server 2012 R2 installed, and all workstations have Windows 8 installed. You are running a training exercise for junior administrators.You are currently discussing the Always Offline Mode.  Which of the following is TRUE with regards to the Always Offline Mode?()

  • A、It allows for swifter access to cached files and redirected folders.
  • B、To enable Always Offline Mode,you have to satisfy the forest and domain functional-level requirements, as well as schema requirements.
  • C、It allows for lower bandwidth usage due to users are always working offline.
  • D、To enable Always Offline Mode, you must have workstations running Windows 7 or Windows Server 2008 R2.

正确答案:A,C

第8题:

The database users are connecting to the PROD database from different  applications, thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective?()

  • A、set the SESSIONS to 1 in the parameter file
  • B、grant SINGLE SESSION privilege to all of the users
  • C、set the SESSIONS_PER_USER to 1 in the users’ profile
  • D、grant RESTRICTED SESSION privilege to all of the database users
  • E、create a role with SINGLE SESSION privilege and assign the role to the users

正确答案:C

第9题:

单选题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings, you find that the following parameter has been set in the parameter file of the database:  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE?()
A

to enable operating system authentication for a remote client

B

to restrict the scope of administration to identical operating systems

C

to allow the start up and shut down of the database from a remote client

D

to enable the administration of the operating system from a remote client

E

to disable the administration of the operating system from a remote client


正确答案: B
解析: 暂无解析

第10题:

单选题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?()
A

For the database, you should turn on the TRUSTWORTHY database option

B

For the database, the PAGE_VERIFY database option should be set to CHECKSUM

C

For the database, the database compatibility level option should be set to 10

D

For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 


正确答案: A
解析: 暂无解析

更多相关问题