Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）A、SELECT * FROM t1 UNION SELECT * FROM t2B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C、SELECT * FROM t1 INTERSECT SELECT * FROM t2D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）
- A、SELECT * FROM t1 UNION SELECT * FROM t2
- B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
- C、SELECT * FROM t1 INTERSECT SELECT * FROM t2
- D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
相关考题：
Which of the following advisors is run in every maintenance window by the auto－task system?() A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access Advisor
Which of the following allows an administrator to recover the MOST data?() A. System imageB. Incremental backupC. System state restoreD. Differential backup
Which of the following database objects is considered executable using SQL?() A.ViewB.TableC.RoutineD.Package
Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A、UDTB、TriggerC、PackageD、Access plan
Which of the following is used to periodically multicast by DIS on a LAN to ensure IS-IS link state databaseaccuracy？（）A、CSNPB、LSPC、ISHD、HelloE、IIHF、PSNP
Which of the following routing protocols is a link state and uses a backbone called area 0？（）A、OSPFB、EIGRPC、BGPD、IS-IS
Which of the following servers would execute SQL？（）A、 Database ServerB、 DNS ServerC、 NAS ServerD、 Web Server
Which of the following are considered link state protocols?（）A、RIPv2 and EIGRPB、EGP and IGPC、OSPF and IS-ISD、RIP and BGP
Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package
A System x administrator is considering new storage subsystems. Which of the following is a benefit of SAS over Solid State? （）A、Higher transfer speeds B、Increased power consumption with Solid State C、Increased bandwidth D、Cost per MB
Which of the following commands is used to observe the current state of the routing table？（）A、routeB、lsattrC、netstatD、ifconfig
Which of the following commands indicates the available state of a physical adapter？（）A、lscfgB、lsdevC、netstatD、ifconfig
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（） A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor
You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）A、SQL Repair AdvisorB、SQL OptimizerC、SQL Access AdvisorD、SQL Tuning Advisor
When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）A、 Filter versionsB、 Filter loadsC、 Filter tasksD、 Filter options
Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)A、A single SQL statement provided by a userB、An existing SQL Tuning Set (STS)C、A preprocessed Database Replay workloadD、A schema nameE、SQL statement identified in EM as using excessive resources
Which of the following advisors is run in every maintenance window by the auto-task system?（）A、The Memory AdvisorB、The SQL Tuning AdvisorC、The Undo AdvisorD、The SQL Access Advisor
Which of the following cannot be used as input to the SQL Tuning Advisor？（）A、 A single SQL statement provided by a userB、 An existing SQL Tuning Set （STS）C、 A preprocessed Database Replay workloadD、 A schema nameE、 SQL statement identified in EM as using excessive resources
多选题You plan to execute the following command to perform a Flashback Database operation in your database: SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）AThe database must have multiplexed redo log filesBThe database must be in the MOUNT state to execute the commandCThe database must be in the NOMOUNT state to execute the commandDThe database must be opened in RESTRICTED mode before this operationEThe database must be opened with the RESETLOGS option after the flashback operation
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor
单选题Which of the following servers would execute SQL？（）A Database ServerB DNS ServerC NAS ServerD Web Server
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor
单选题Which of the following allows an administrator to recover the MOST data?（）ASystem imageBIncremental backupCSystem state restoreDDifferential backup
单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）ASQL Repair AdvisorBSQL OptimizerCSQL Access AdvisorDSQL Tuning Advisor SQL
单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor
单选题Which of the following allows an administrator to recover the MOST data？（）A System imageB Incremental backupC System state restoreD Differential backup
单选题Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）AINDEXESBSKIP_INDEXES_MAINTENANCECSKIP_UNUSABLE_INDEXESDRESUMABLEEINDEXES_UNUSABLE