〈select name=*〉…〈/select〉标记的作用是（ )。

相似题目

• Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them? （）

  A . The two statements produce identical results. B . The second statement returns a syntax error. C . There is no need to specify DESC because the results are sorted in descending order by default. D . The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

  查看最佳答案

• Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

  A . Selection, projection, join B . Difference, projection, join C . Selection, intersection, join D . Intersection, projection, join E . Difference, projection, product

  查看最佳答案

• Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?（）

  A . SORT BY age ASC, last_name B . SORT BY age DESC, last_name C . ORDER BY age DESC, last_name D . ORDER BY age ASC, last_name

  查看最佳答案

• Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）  

  A .  FREE_SPACE indicates only the space that is currently unallocated. B .  ALLOCATED_SPACE indicates only the space currently allocated and in use. C .  FREE_SPACE indicates only the space that is currently allocated and available for reuse. D .  ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse. E .  FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

  查看最佳答案

• Examine the following output： SQL> SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）

  A . It is ignored by the query optimizer. B . It is not used while the index is being rebuilt. C . The index cannot be rebuilt， and has to be re-created. D . The index is automatically rebuilt when used the next time

  查看最佳答案

• 执行如下两个查询，结果为（） Select ename name，sal salary from emp order by salary Select ename name，sal“salary”from emp order by sal asc

  A . 两个查询结果完全相同 B . 第一个查询正确，第二个查询错误 C . 两个查询结构不同 D . 第二个查询正确，第一个查询错误

  查看最佳答案

• Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?（）

  A . remove the ORDER BY clause B . remove the table alias prefix from the WHERE clause C . remove the table alias from the SELECT clause D . prefix the column in the USING clause with the table alias E . prefix the column in the ORDER BY clause with the table alias F . replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40&quot

  查看最佳答案

• Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMPLOYEES e, DEPARTMENTS d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

  A . selection, projection, join B . difference, projection, join C . selection, intersection, join D . intersection, projection, join E . difference, projection, product

  查看最佳答案

• Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按（）排序。

  A . emp_id B . emp_name C . sex D . wage

  查看最佳答案

• The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）

  A . The results are not sorted. B . The results are sorted numerically. C . The results are sorted alphabetically. D . The results are sorted numerically and then alphabetically.

  查看最佳答案

• You executed the following query：  SELECT operation， undo_sql， table_name  FROM flashback_transaction_query;  Which statement is correct regarding the query output？（）

  A . It would return information regarding only the last committed transaction. B . It would return only the active transactions in all the undo segments in the database. C . It would return only the committed transactions in all the undo segments in the database.  D . It would return both active and committed transactions in all the undo segments in the database. E . It would return information regarding the transactions that began and were committed in the last 30 minutes.

  查看最佳答案

• You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

  A .  It would return information regarding only the last committed transaction. B .  It would return only the active transactions in all the undo segments in the database. C .  It would return only the committed transactions in all the undo segments in the database. D .  It would return both active and committed transactions in all the undo segments in the database. E .  It would return information regarding the transactions that began and were committed in the last 30 minutes.

  查看最佳答案

• You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query；  Which statement is correct regarding the query output？（） 

  A . It would return information regarding only the last committed transaction. B . It would return only the active transactions in all the undo segments in the database. C . It would return only the committed transactions in all the undo segments in the database. D . It would return both active and committed transactions in all the undo segments in the database. E . It would return information regarding the transactions that began and were committed in the last 30 minutes.

  查看最佳答案

• HTML 代码 <select> </select> 的作用是什么？（ ）

  查看最佳答案

• 语句SELECT name，sex，birthday FROM human返回（）列。

  查看最佳答案

• BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password)查询Customer表中所有客户的信息，要求显示CustomerCode、Name、Hometown和Telephone字段信息。SQL语句：SELECT _________ FROM Customer

  查看最佳答案

• When booking a flight, you can use your another name, which is different from the name on your selected ID.

  查看最佳答案

• 查询结果集ResultSet对象是以统一的行列形式组织数据的，执行ResultSet rs = stmt.executeQuery ('select bid,name,author,publish,price from book');语句，得到的结果集rs的列数为（ ）

  查看最佳答案

• 对于基本表S(S，Name，Sex，Birthday)和SC(S，C，Grade)，其中S、Name、Sex、Birthday、C和G rade分别表示学号、姓名、性别、生日、课程号和成绩。与下列SQL语句等价的关系代数式是______。 SELECT S，Name FROM S WHERE S NOT IN (SELECT S FROM SC WHERE C='c102')。

  A．πS,Name(σC≠'c102'(S<img src='https://img2.soutiyun.com/ask/uploadfile/1341001-1344000/323a4ae71591ced9c23849d07bd3a76b.jpg' />SC)) B．πS,Name(S)-πS,Name(σC≠'c102'(S<img src='https://img2.soutiyun.com/ask/uploadfile/1341001-1344000/323a4ae71591ced9c23849d07bd3a76b.jpg' />SC)) C．πS,Nmne(S<img src='https://img2.soutiyun.com/ask/uploadfile/1341001-1344000/323a4ae71591ced9c23849d07bd3a76b.jpg' />σC≠'c102'(SC)) D．πS,Name(S<img src='https://img2.soutiyun.com/ask/uploadfile/1341001-1344000/3fc30a9ef68a99730b1bdc9d3e7b5749.jpg' />(SC))

  查看最佳答案

• 在SQL语言中，一个SELECT-FROM-WHERE语句称为一个（)。将一个SELECT查询块嵌入另一个SELECT查询

  在SQL语言中，一个SELECT-FROM-WHERE语句称为一个()。将一个SELECT查询块嵌入另一个SELECT查询块的WHERE子句或HAVING短语的条件中的查询称为()。

  查看最佳答案

• SELECT cust_name FROM Customers WHERE cust_name IN （'IL','IN','MI')的输出可以是如下选项中的哪些（)？

  A．IL B．MI C．INN D．MII

  查看最佳答案

• 【判断题】BookStore数据库中有图书表 Book（BookCode, BookName, Author, PublisherCode, PublishTime，BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询图书名称（BookName）含有“程序”的图书信息。SQL语句: SELECT BookCode,BookName,Author,Price,Discount FROM Book WHERE Name=“%程序%”

  A．Y.是 B．N.否

  查看最佳答案

• 查询：对于大学中所有讲授过课程的教师，找出他们的姓名及其所讲授课程的ID。 该查询可以写成： select name, course id from instructor natural join teaches;

  查看最佳答案

• 将各个系教师的平均工资定义为视图average_salary. create view average_salary as select dept_name,max（salary) from instructor; group by dept_name;

  查看最佳答案