更多"Which are DML statements? ()"的相关试题:
[多项选择]Which are DML statements?()
A. COMMIT
B. MERGE
C. UPDATE
D. DELETE
E. CREATE
F. DROP...
[多项选择]Examine these two statements:Which three are true about the MRKT tablespace?()
A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
B. The MRKT tablespace may be dropped if it has no contents.
C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
D. No more data files can be added to the tablespace.
E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
[单项选择]If p and q are statements, which of the following formulas is tautological ( )
A. ┐ (p→∧q
B. (p∨→p∧q
C. (q∧(p→)→p
D. ((p→∧→q
[多项选择]Which two statements regarding external authentication servers for firewall user authentication are true?() (Choose two.)
A. Up to three external authentication server types can be used simultaneously.
B. Only one external authentication server type can be used simultaneously.
C. If the local password database is not configured in the authentication order, and the configured authentication server bypassed.
D. If the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.
[多项选择]Which four statements correctly describe functions that are available in SQL?()
A. INSTR returns the numeric position of a named character.
B. NVL2 returns the first non-null expression in the expression list.
C. TRUNCATE rounds the column, expression, or value to n decimal places.
D. DECODE translates an expression after comparing it to each search value.
E. TRIM trims the heading of trailing characters (or both) from a character string.
F. NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.
G. NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.
[多项选择]Which three statements about performance analysis by SQL Performance Analyzer are true? ()
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
[多项选择]Which two statements regarding JUNOS architecture are correct?()
A. The Routing Engine handles all exception traffic.
B. The Routing Engine synchronizes the route table with the PFE
C. The Routing Engine is hot-pluggable.
D. The Routing Engine controls the PFE
[多项选择]Which two statements correctly identify considerations to take into account when deciding on Campus QoS Design elements?()
A. Voice needs to be assigned to the hardware priority queue.
B. Voice needs to be assigned to the software priority queue.
C. Call signaling must have guaranteed bandwidth service.
D. Strict-priority queuing should be limited to 50 percent of the capacity of the link.
E. At least 33 percent of the link bandwidth should be reserved for default best-effort class.
[多项选择]Which three statements are typical characteristics of VLAN arrangements?()
A. A new switch has no VLANs configured.
B. Connectivity between VLANs requires a Layer 3 device.
C. VLANs typically decrease the number of collision domains.
D. Each VLAN uses a separate address space.
E. A switch maintains a separate bridging table for each VLAN.
F. VLANs cannot span multiple switches.
[单项选择]Which of these statements is true ( )