网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 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 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?（）A
The SGA Tuning AdvisorB
The SQL Access AdvisorC
The SQL Tuning AdvisorD
The 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?（）A
System imageB
Incremental backupC
System state restoreD
Differential backup
考题
单选题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 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？（）A
INDEXESB
SKIP_INDEXES_MAINTENANCEC
SKIP_UNUSABLE_INDEXESD
RESUMABLEE
INDEXES_UNUSABLE
热门标签
最新试卷