In which case would you use a FULL OUTER JOIN?（）A、Both tables have NULL values.B、You want all unmatched data from one table.C、You want all matched data from both tables.D、You want all unmatched data from both tables.E、One of the tables has more data than

题目

In which case would you use a FULL OUTER JOIN?（）

A、Both tables have NULL values.
B、You want all unmatched data from one table.
C、You want all matched data from both tables.
D、You want all unmatched data from both tables.
E、One of the tables has more data than the other.
F、You want all matched and unmatched data from only one table.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Which two commands would you use to discard a candidate configuration?()

A. rollback

B. delete

C. delete 0

D. rollback 0

参考答案：A, D

第2题：

You want the size of the tablespace to increase when it is full. Which option would you use？（）

A、use automatic extent allocation
B、disable threshold for the tablespace
C、use freelists to manage the free space
D、use automatic segment space management
E、create the tablespace as a bigfile tablespace
F、use the RESIZE clause while creating the tablespace
G、enable AUTOEXTEND for at least one of the data files in the tablespace

正确答案:G

第3题：

Which substitution variable would you use if you want to reuse the variable without prompting the user each time? ()

A. &

B. ACCEPT

C. PROMPT

D. &&

参考答案：D

第4题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）

A、Hot backup
B、Online backup
C、consistent backup
D、incremental backup
E、inconsistent backup

正确答案:C

第5题：

Which of the following tools would be BEST to use to pry open the case of a laptop?（）

A、Metal screwdriver
B、Plastic wedge
C、Needle-nose pliers
D、Extension magnet

正确答案:B

第6题：

Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

A、SMON would automatically restore the lost file.
B、You would need to restore the whole database from the last backup.
C、You would need to restore the file from the last full database backup.
D、You would need to use flashback technology to restore the lost redo log member.
E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.
F、You would need to restore the missing log file by copying one of the remaining files from the same group.

正确答案:F

第7题：

Which command （without options） would you use to display how much space is available on all mounted partitions？（）

正确答案:/BIN/DF

第8题：

In which case would you use a FULL OUTER JOIN? ()

A. Both tables have NULL values.

B. You want all unmatched data from one table.

C. You want all matched data from both tables.

D. You want all unmatched data from both tables.

E. One of the tables has more data than the other.

F. You want all matched and unmatched data from only one table.

参考答案：D

第9题：

Which version of a view would you use if you just want a quick， easy view within your XPage？（）

A、Data Table Control
B、View Control
C、Repeat Control
D、Filter by category View Control

正确答案:B

第10题：

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

A、 use DBMS_IJOB package
B、 use Oracle Scheduler
C、 use DBMS_JOB package
D、 use Oracle Data Pump Export and Import

正确答案:B

In which case would you use a FU

题目

相似问题和答案

更多相关问题

相关内容