网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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.
考题
ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?（）A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
考题
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their managers‘ last names and their department names. Which query would you use?（）A.SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN departments d ON (e.department_id = d.department_id);B.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);C.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);D.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);E.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);F.SELECT last_name, manager_id, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id) ;
考题
In which three cases would you use the USING clause?（）A、You want to create a nonequijoin.B、The tables to be joined have multiple NULL columns.C、The tables to be joined have columns of the same name and different data types.D、The tables to be joined have columns with the same name and compatible data types.E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
考题
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.
考题
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
考题
In which two cases would you use an outer join? （）A、The tables being joined have NOT NULL columns.B、The tables being joined have only matched data.C、The columns being joined have NULL values.D、The tables being joined have only unmatched data.E、The tables being joined have both matched and unmatched data.F、Only when the tables have a primary key-foreign key relationship.
考题
Which three are true regarding the use of outer joins? （）A、You cannot use IN operator in a condition that involves an outerjoin.B、You use (+) on both sides of the WHERE condition to perform an outerjoin.C、You use (*) on both sides of the WHERE condition to perform an outerjoin.D、You use an outerjoin to see only the rows that do not meet the join condition.E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
考题
以下哪两组联接关键字可以创建这样一个联接，该联接包括SELECT语句中指定的第一个表中的不匹配行？（）A、LEFT OUTER JOIN和FULL OUTER JOINB、RIGHTOUTERJOIN和LEFT OUTER JOINC、USING和HAVINGD、OUTER JOIN和USING
考题
Which command （without options） would you use to display how much space is available on all mounted partitions？（）
考题
Which of the following tools would be BEST to use to pry open the case of a laptop?（）A、Metal screwdriverB、Plastic wedgeC、Needle-nose pliersD、Extension magnet
考题
Which of the following commands would you run to add your machine to an NT4 domain？（）A、 net rpc join -S PDC -UAdministrator%passwordB、 net ads join -s PDC -UAdministrator%passwordC、 net rpc join -s PDC -UAdministrator%passwordD、 net ads join -W PDC -nAdministrator%password
考题
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 packageB、 use Oracle SchedulerC、 use DBMS_JOB packageD、 use Oracle Data Pump Export and Import
考题
In which case would you use the Flashback Database feature to perform a recovery？（）A、to recover a dropped tablespaceB、to recover data from a truncated tableC、to recover a data file that has been shrunkD、to recover a database to the state that existed before the RESETLOGS operation
考题
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A、B、ACCEPTC、PROMPTD、
考题
单选题You want the size of the tablespace to increase when it is full. Which option would you use？（）A
use automatic extent allocationB
disable threshold for the tablespaceC
use freelists to manage the free spaceD
use automatic segment space managementE
create the tablespace as a bigfile tablespaceF
use the RESIZE clause while creating the tablespaceG
enable AUTOEXTEND for at least one of the data files in the tablespace
考题
单选题Which of the following commands would you run to add your machine to an NT4 domain？（）A
net rpc join -S PDC -UAdministrator%passwordB
net ads join -s PDC -UAdministrator%passwordC
net rpc join -s PDC -UAdministrator%passwordD
net ads join -W PDC -nAdministrator%password
考题
单选题Which protocols would you want to use for secure VPN ？（）A
EAPB
ChapC
Ms-ChapD
PPTPE
PAPF
SPAP
考题
单选题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 packageB
use Oracle SchedulerC
use DBMS_JOB packageD
use Oracle Data Pump Export and Import
考题
多选题Which three are true regarding the use of outer joins? （）AYou cannot use IN operator in a condition that involves an outerjoin.BYou use (+) on both sides of the WHERE condition to perform an outerjoin.CYou use (*) on both sides of the WHERE condition to perform an outerjoin.DYou use an outerjoin to see only the rows that do not meet the join condition.EIn the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.FYou cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
考题
多选题In which three cases would you use the USING clause?（）AYou want to create a nonequijoin.BThe tables to be joined have multiple NULL columns.CThe tables to be joined have columns of the same name and different data types.DThe tables to be joined have columns with the same name and compatible data types.EYou want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
考题
单选题Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A
B
ACCEPTC
PROMPTD
考题
多选题In which two cases would you use an outer join? （）AThe tables being joined have NOT NULL columns.BThe tables being joined have only matched data.CThe columns being joined have NULL values.DThe tables being joined have only unmatched data.EThe tables being joined have both matched and unmatched data.FOnly when the tables have a primary key-foreign key relationship.
考题
单选题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.
考题
单选题Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）A
SELECT last_name, department_name FROM employees NATURAL JOIN departments;B
SELECT last_name, department_name FROM employees JOIN departments ;C
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);D
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);E
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);F
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
考题
单选题In which case would you use the Flashback Database feature to perform a recovery？（）A
to recover a dropped tablespaceB
to recover data from a truncated tableC
to recover a data file that has been shrunkD
to recover a database to the state that existed before the RESETLOGS operation
热门标签
最新试卷
