可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The database administrator of your co


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?()

  • 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.
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、In your database,the 

In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the&...

2、Your database has the SRV1 service co

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple module...

3、Your database is open and the LISTENER

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWh...

4、The network administrator of the Orego

The network administrator of the Oregon router adds the follwing command to the router configuration: ip route 192.168.12.0 255.255.255.0 172.16...

5、In your database,the L

In your database,the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the us...

6、In your database, the flash recovery

In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure...