CMS专题
单选题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
题目
Synonyms can be created only for a table
Synonyms are used to reference only those tables that are owned by another user
A public synonym and a private synonym can exist with the same name for the same table
The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
参考答案和解析
相似问题和答案
第1题：
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.
第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题：
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.
第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题：
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
第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题：
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
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.