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

相似题目

• You are connecting to an Oracle database server from a client by using the following connect string：  SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb  Which naming method is being used in this case？（）

  A . Local Naming B . Easy Connect C . External Naming D . Directory Naming

  查看最佳答案

• In which scenarios would you rebuild an index？（）

  A .  when you need to disable the index usage B .  when you need to change storage options C .  when you need to enable index monitoring D .  when you need to move the index to another 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.

  查看最佳答案

• Identify three situations in which you would NOT be able to drop a tablespace. （）

  A . when the tablespace is online B . when the tablespace has segments with data in it C . when the tablespace is a default permanent tablespace for the database D . when the tablespace contains a table that is currently being used by transactions E . when the tablespace contains undo data that is needed to rollback an uncommitted transactio

  查看最佳答案

• In which situation would you use the Oracle Shared Server configuration？（）

  A . when performing export and import using Oracle Data Pump B . when performing backup and recovery operations using Oracle Recovery Manager C . when performing batch processing and bulk loading operation in a data warehouse environment  D . in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

  查看最佳答案

• In which two cases would you perform only consistent backup？（）

  A . You are working on a database where downtime is not tolerated. B . You are working on a database where downtime can be tolerated. C . You are working on a database that operates in ARCHIVELOG mode. D . You are working on a database that operates in NOARCHIVELOG mode. E . You are working on a database where all the tablespaces are locally managed. F . You are working on a database where control files and redo log files are multiplexed. G . You are working on a database where control files and redo log files are not multiplexed.

  查看最佳答案

• What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）

  A . roll back of large transactions B . roll forward to redo a transaction C . data concurrency for large updates D . read consistency for long-running transactio

  查看最佳答案

• You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）

  A .  backup pieces B .  copies of all the parameter files C .  trace file generated using BACKUP CONTROLFILE TO TRACE D .  control file autobacku

  查看最佳答案

• In which situation would you use static database registration for a listener（）

  A . when multiple databases are to be registered with the listener B . when DBAs need to connect remotely to start up the database instance C . when users need to connect the database instance using the host naming method D . when the database instance that is to be registered with the listener is configured in shared server mode

  查看最佳答案

• Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based recovery？（）

  A . You find that one of the redo log members in each redo log group is lost. B . You find that a data file that belongs to the USERS tablespace is damaged. C . You find that a data file that belongs to the SYSTEM tablespace is damaged. D . You find that the current redo log group is damaged and is not available for recovery. E . You realized while performing a recovery that an archived redo log file needed for recovery is lost.

  查看最佳答案

• You are connecting to an Oracle database server from a client by using the following connect string：   SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb   Which naming method is being used in this case？（）

  A . Local Naming B . Easy Connect C . External Naming D . Directory Naming

  查看最佳答案

• You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

  A . backup pieces B . control file autobackups C . copies of all the parameter files D . trace file generated using BACKUP CONTROLFILE TO TRACE

  查看最佳答案

• Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts？（）  

  A .  NLS_SORT = BINARY B .  NLS_SORT = BINARY_AI C .  NLS_SORT = BINARY_CI D .  NLS_SORT = BINARY_AI_CI E .  Binary sorts are case insensitive and accent insensitive by default

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. 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 backu

  查看最佳答案

• In which case would you use the Flashback Database feature to perform a recovery？（）

  A . to recover a dropped tablespace B . to recover data from a truncated table C . to recover a data file that has been shrunk D . to recover a database to the state that existed before the RESETLOGS operatio

  查看最佳答案

• 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 backu

  查看最佳答案

• Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）

  A . NLS_SORT = BINARY B . NLS_SORT = BINARY_AI C . NLS_SORT = BINARY_CI D . NLS_SORT = BINARY_AI_CI E . Binary sorts are case insensitive and accent insensitive by default.

  查看最佳答案

• Would you like to ______us in our discussion.

  查看最佳答案

• We should be graceful if you would give us a completen refound for tje defective goods which were delivered.

  查看最佳答案

• In which of the following situations would you prefer to be making a loan?

  查看最佳答案

• It might fall down in case of turbulence and hurt someone. Would you place it somewhere else? 遇到气流时它可能会掉下来并且伤到人，你能把它放到别处吗？

  查看最佳答案

• In the US, if you have certain years of working experience and return to university to do your graduate degrees, people would think that ( ).

  查看最佳答案

• In which case mentioned in the passage would an automatic language translator be helpful？

  A．A medical emergency. B．Police action. C．Traveling. D．All of the above.

  查看最佳答案

• In which of the following cases do you have to maintain GR/IR clearing accounts in Logistics Invoice Verification？ Please choose the correct answer.（)

  A.The vendor has invoiced a price lower than the purchase order price B.The vendor has invoiced a price higher than the purchase order price C.For an item that has been delivered, a higher quantity was invoiced than delivered D.You have posted an invoice incorrectly and cancelled it afterwards

  查看最佳答案