违法和不良信息举报 联系客服
免费注册 登录

The database administrator of yo

题目

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）

  • A、You obtain the results retrieved from the public synonym HR created by the database administrator.
  • B、You obtain the results retrieved from the HR table that belongs to your schema.
  • C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
  • D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
  • E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
参考答案和解析
正确答案:B
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

当舞台照明采用可控硅调光设备时，其电源变压器宜采用的接线方式为（）。

  • A、Δ/Δ
  • B、Yo/Yo
  • C、Yo/Δ
  • D、Δ/Yo

正确答案:D

第2题：

An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）

  • A、odmget
  • B、odmadd
  • C、odmshow
  • D、odmcreate

正确答案:A

第3题：

Which of the following is not responsibility of DBA(Data Base Administrator)?

A．Database management system design

B．Database schema definition

C．Database schema modification

D．Integrity constraint specification


正确答案：A

第4题：

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

第5题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）

  • A、Hot backup
  • B、Online backup
  • C、consistent backup
  • D、incremental backup
  • E、inconsistent backup

正确答案:C

第6题：

An administrator determines that performance has degraded for a WebSphere Commerce database.  Which of the following steps should be performed to correct this problem？（）

  • A、Cleanup obsolete data
  • B、Clear the WebSphere Commerce cache
  • C、Enable WebSphere Commerce Accelerator
  • D、Reindex the database tables
  • E、Run Performance Monitor to monitor SQL statements

正确答案:A,D

第7题：

A system administrator needs to provision storage for a 200GB database. The database must have extremely low seek time. Which of the following is the BEST solution？（）

  • A、A JBOD
  • B、A RAID 50 array
  • C、A NAS
  • D、A single SSD

正确答案:D

第8题：

The administrator wants to verify the current state of the OSPF database loading process. Which show command should the administrator use?()

A. show ip ospf [process - id] interface

B. show ip ospf neighbor

C. show ip ospf [process - id]

D. show ip ospf [process - id area - id] database


参考答案：B

第9题：

A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）  

  • A、 Do nothing.
  • B、 Restart the database.
  • C、 Perform recovery on the database.
  • D、 Restore the alert log from the last backup.

正确答案:A

第10题：

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database？（）  

  • A、 Yes， if the database is in ARCHIVELOG mode
  • B、 Yes， if the database is in NOARCHIVELOG mode
  • C、 No， the backup is not usable in any way
  • D、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

正确答案:C

更多相关问题
相关内容