单项选择题

Consider this syntax： MERGE INTO t1 USING t2 ON （join p……

Consider this syntax：
MERGE INTO t1
USING t2 ON （join predicate）…..
What does the MERGE syntax do？（）

A.It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table.
B.It creates a natural join of tables T1 and T2 for all columns that have the same name.
C.It creates a Cartesian product of table T1 and table T2 for all columns that have the same name.
D.For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.

<上一题目录下一题>

热门试题

多项选择题WhichtwodatatypescanbeconvertedtoLOBsusinganALTERTABLE…MODIFYcommand？（）

A.RAW
B.LONG
C.VARCHAR
D.LONG RAW

多项选择题Onlineindexrebuildfunctionalityhasbeenextendedtoincludewhichfourindexstructures？（）

A.Bitmap indexes.
B.Reverse key indexes.
C.Function-based indexes.
D.Key-compressed indexes on regular tables.
E.Key-compressed indexes on IOT （including secondary indexes）

多项选择题WhenperformingincompleterecoveryusingUNTILSEQUENCEwithRMAN，whichtwopiecesofinformationarerequired？（）

A.Thread number.
B.Log Sequence number.
C.Control file sequence number.
D.Name of the last archived log.

单项选择题Whichbackgroundprocessreadstheredologbufferandwritesittoafile？（）

A.ARCn
B.DBWn
C.CKPT
D.LGWR
E.PMON
F.SMON

单项选择题You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. Which action should you take to enable archiving at instance startup？（）

A.A
B.B
C.C
D.D