Which statement is true regarding synonyms?()

题目
单选题
Which statement is true regarding synonyms?()
A

Synonyms can be created only for a table 

B

Synonyms are used to reference only those tables that are owned by another user 

C

A public synonym and a private synonym can exist with the same name for the same table 

D

The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

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

第1题:

Which statement is true regarding IPsec VPNs?()

A. There are five phases of IKE negotiation.

B. There are two phases of IKE negotiation.

C. IPsec VPN tunnels are not supported on SRX Series devices.

D. IPsec VPNs require a tunnel PIC in SRX Series devices.


参考答案:D

第2题:

Which statement is true regarding the forwarding plane?()

  • A、The forwarding plane is contained within the Routing Engine (RE)
  • B、The forwarding plane processes and evaluates exception traffic
  • C、The forwarding plane contains the Packet Forwarding Engine (PFE)
  • D、The forwarding plane is not present on all platforms running the Junos OS

正确答案:C

第3题:

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

A. You cannot roll back this statement.

B. All pending transactions are committed.

C. All views based on the DEPT table are deleted.

D. All indexes based on the DEPT table are dropped.

E. All data in the table is deleted, and the table structure is also deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. All synonyms based on the DEPT table are deleted.


参考答案:A, B, D, E

第4题:

Which statement is true regarding Flashback Version Query? ()

  • A、 It returns versions of rows only within a transaction.
  • B、 It can be used in subqueries contained only in a SELECT statement.
  • C、 It will return an error if the undo retention time is less than the lower bound time or SCN specified.
  • D、 It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

正确答案:D

第5题:

Identify the true statement regarding Temporary Coherence cluster members()

  • A、 it should have "localstorage" set to TRUE
  • B、 it should be configured so as to not trigger re-partitioning 
  • C、 both A and B are TRUE
  • D、 Neither A and B are TRUE

正确答案:B

第6题:

Which statement is true regarding Backup tasks in Cisco UCS?()

  • A、 They are created automatically and stored on the FI
  • B、 They are created manually and exported to a remote server
  • C、 They are automatically scheduled to run every 24 hours
  • D、 They are manually scheduled and stored on the FI

正确答案:B

第7题:

Which statement is true regarding syslog on Junos devices?()

  • A、No logging is enabled by default
  • B、By default the information is stored in all file named events
  • C、Only the message severity level must be configured
  • D、You can configure the router to send log messages to the console

正确答案:D

第8题:

Which statement is true regarding virtual private catalogs?()

A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.

B. The virtual private catalog owner cannot create and modify the stored scripts.

C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database


参考答案:D

第9题:

Which two statements are true regarding the ORDER BY clause? ()

  • A、It is executed first in the query execution 
  • B、It must be the last clause in the SELECT statement 
  • C、It cannot be used in a SELECT statement containing a HAVING clause
  • D、You cannot specify a column name followed by an expression in this clause 
  • E、You can specify a combination of numeric positions and column names in this clause

正确答案:B,E

第10题:

单选题
Evaluate the following statement:   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?()
A

 They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B

 They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

C

 They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

D

 The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.


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

更多相关问题