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

题目

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.
相似考题

1.Which of the following is not responsibility of DBA(Data Base Administrator)?A．Database management system designB．Database schema definitionC．Database schema modificationD．Integrity constraint specification

2.当舞台照明采用可控硅调光设备时，其电源变压器宜采用的接线方式为（）。A、Δ/ΔB、Yo/YoC、Yo/ΔD、Δ/Yo

3.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 dataB、Clear the WebSphere Commerce cacheC、Enable WebSphere Commerce AcceleratorD、Reindex the database tablesE、Run Performance Monitor to monitor SQL statements

4.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] interfaceB. show ip ospf neighborC. show ip ospf [process - id]D. show ip ospf [process - id area - id] database

更多“The database administrator of yo”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You need to define an authentication system for the main office database administrators. The setup should require the minimum amount of administrative effort. The authentication environment must fulfill the company’s security requirements.What should you do？（）

    • A、Create a SQL Server login with Windows Authentication for each main office database administrator.Add all of these logins to the db_owner role in each database.
    • B、Create a SQL Server login with SQL Server Authentication for each main office database administrator.Add all of these logins to the sysadmin role.
    • C、Create a Windows global group named DBAdmins. Add each main office database administrator’s Windows user account to the Windows DBAdmins group.Create a SQL Server login with Windows Authentication for the group.Add the group to the serveradmin fixed server role.
    • D、Add each main office database administrator’s Windows user account to the Windows SQLManagersgroup.

    正确答案:D

  • 第5题：

    我国现在常见的变压器接线组别的连接方式为（）。

    • A、Yo/△-11；Y/Y-12；Y/△-11
    • B、Yo/△-11；Y/Yo-12；Y/△-11
    • C、Y/△-11；Yo/Y-12；Y/Y-12
    • D、Y/△-11；Y/Y-12；Y/Yo-12

    正确答案:B

  • 第6题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a Linked Server connection should be configured to the application database.

    B

    To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.

    C

    To achieve the goal， a Remote Server connection to the application database should be configured.

    D

    To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.


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

  • 第9题：

    多选题
    You work as a database administrator for Certkiller .com. 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， Certkiller， 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.


    正确答案： F,A
    解析： 暂无解析

  • 第10题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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.


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

  • 第12题：

    单选题
    You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.  Which command would you execute to proceed further？（）
    A

    RECOVER LOFIEL BLOCK GROUP 2；

    B

    ALTER DATABASE DROP LOGFILE GROUP 2；

    C

    ALTER DATABASE CLEAR LOGFILE GROUP 2；

    D

    ALTER DATABASE RECOVER LOGFILE GROUP 2；

    E

    ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；


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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    国家对三相双绕组变压器规定的五种标准连接组别为（）。

    • A、YN·yno、YN·dll、YN·yo、Y·yo、y·dll
    • B、Y·yno、YN·d5、YN·yo、Y·yo、y·dll
    • C、Y·yno、YN·dll、YN·yo、Y·yo、y·dll
    • D、Y·yno、YN·dll、YN·yo、Y·yo、y·d5

    正确答案:C

  • 第18题：

    多选题
    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


    正确答案： E,B
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    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


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

  • 第21题：

    多选题
    You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）
    A

    Execute the ALTER DATABASE ARCHIVELOG statement

    B

    Select ARCHIVELOG option in the database control and restart the database to apply the changes.

    C

    Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

    D

    Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.


    正确答案： C,D
    解析： 暂无解析

  • 第22题：

    单选题
    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 the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases.  Which action should be performed to achieve the goal？（）
    A

    To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.

    B

    To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.

    C

    To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.

    D

    To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第24题：

    多选题
    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


    正确答案： D,C
    解析： 暂无解析

相关内容