What statement about Transit AS is true?()
第1题:
The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER 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.
第2题:
A. 0
B. 1
C. 0.00
D. An error statement
第3题:
The twentieth century saw great change. In your opinion, what is one change that should be remembered about the twentieth century? Write an essay of about 400 words to state your opinion.
In the first part of your essay you should present your thesis statement, and in the second part you should support the thesis statement with appropriate details. In the last part you should bring what you have written to a natural conclusion or a summary.
You should supply an appropriate title for your essay.
Marks will be awarded for content, organization, grammar and appropriateness. Failure to follow the above instructions may result in a loss of marks.
第4题:
A.A
B.B
C.C
D.D
第5题:
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupies by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第6题:
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.
第7题:
A. The SQL statement displays the desired results.
B. The column in the WHERE clause should be changed to display the desired results.
C. The operator in the WHERE clause should be changed to display the desired results.
D. The WHERE clause should be changed to use an outer join to display the desired results.
第8题:
Sometimes a personal statement can be perfectly well written in terms of language and grammar, but disastrous in lacking punch or impact and in being totally off the mark concerning what it chooses to present about the applicant.()
第9题:
what do you know about “SOPEP”?what is VRP , and what is VCP ?
第10题:
What is a sub-select statement?
A.a select statement that selects a subset of fields in a table
B.a select statement that returns a subset of the data in a table
C.a select statement that appears within another select statement
D.a select statement that returns a subset of the constraints on a field