单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?()ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
单选题
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?()
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)
参考解析
解析:
暂无解析
相关考题:
You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?() A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.
下面不属于同一函数模板的是()。A.template t1 max(t1 a,t1 b) {…}template 下面不属于同一函数模板的是( )。A.template<class t1> t1 max(t1 a,t1 b) {…}template<class t2> t2 max(t2 a,t2 b) {…}B.template<class t1>t1 max(t1 a,t1 b){…}template<class t2>t2 max(t2 a,t2 b){…}C.template<class t1> t1 max(t1 * a,t1 * b) {…} template<class t2> t2 max(t2 a,t2 b) {…}D.template<class t1>t1 max(t1 a,t1 b){…}template<class t2>t2 max(t2 a,t2 b,t2 c){…}
在下列查询语句中,与SELECT TABl*FROM,TABl WHERE InStr([简历],”篮球”)o功能相同的语句是( )。A.SELECT TABl.*FROM TABl WHERE TABl.简历Like”篮球”B.SELECT TABl.*FROM TABl WHERE TABl.简历Like”*篮球”C.SELECT TABl.*FROM TABl WHERE TABl.简历Like”*篮球*”D.SELECT TABl.*FROM TABl WHERE TABl.简历Like”篮球*”
Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?() 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)
Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?() A.REVOKE DROP ON t1 FROM PUBLICB.REVOKE UPDATE ON t1 FROM PUBLICC.REVOKE DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC
The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()A.4B.3C.1D.0
Given the following tables: CONTINENTS ID NAME COUNTRIES1 Antarctica 02 Africa 533 Asia 474 Australia 145 Europe 436 North America 237 South America 12REGION ID LOCATION 1 East 2 WestHow many rows would be returned using the following statement? SELECT location FROM continents, region()A.2B.7C.9D.14
已知:DataSet data=new DataSet();则删除数据集data中person数据表的第5行数据的方法为()A、 data.Tables["person "].Rows[5].Delete();B、 data.Tables["person "].Rows.Delete(5);C、 data.Tables["person "].Rows[4].Delete();D、 data.Tables["person "].Rows[].Delete(4);
Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region()A、2B、7C、9D、14
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?()A、SELECT * FROM T1 MINUS SELECT * FROM T2B、SELECT * FROM T1 EXCEPT SELECT * FROM T2C、SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D、SELECT * FROM T1 NOT EXISTS SELECT * 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)
单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?()ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?()AMERGEBSELECT …CROSS JOINCINSERT ALL …SELECTDCREATE VIEW …CONSTRAINT
单选题The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?()ATemporary tables BIndex-organized tables CCluster tables DStandard Oracle tables
单选题已知:DataSet data=new DataSet();则删除数据集data中person数据表的第5行数据的方法为()A data.Tables[person ].Rows[5].Delete();B data.Tables[person ].Rows.Delete(5);C data.Tables[person ].Rows[4].Delete();D data.Tables[person ].Rows[].Delete(4);
单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()AREVOKE DROP ON t1 FROM PUBLICBREVOKE UPDATE ON t1 FROM PUBLICCREVOKE DELETE ON t1 FROM PUBLICDREVOKE CONTROL ON t1 FROM PUBLIC
单选题Consider this syntax: MERGE INTO t1 USING t2 ON (join predicate)….. What does the MERGE syntax do?()AIt performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. BIt creates a natural join of tables T1 and T2 for all columns that have the same name. CIt creates a Cartesian product of table T1 and table T2 for all columns that have the same name. DFor each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
单选题The following statements: CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, 'a'), (1, 'b'), (2,'c'); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300); How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()A4B3C1D0
单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region()A2B7C9D14
单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region()A2B7C9D14