The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? （）
- A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
- B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
- C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
- D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;
- E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
- F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
相关考题：
Which two statements correctly describe the relation between a data file and the logical databasestructures（）A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
In a database with the database character set of US7ASCII and a national character set of UTF-8， which datatypes would be capable of storing Unicode data by default？（）A、 VARCHAR2B、 CHARC、 NVARCHAR2D、 CLOBE、 LONG
Which statement can be an inference from the output?（）A、The FRA disk group has an asynchronous I/O bottleneckB、The least number of I/Os are performed on the last data file in the listC、The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the listD、The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group
Which three SELECT statements display 2000 in the format "$2,000.00"? （）A、SELECT TO_CHAR(2000, '$#,###.##') FROM dual;B、SELECT TO_CHAR(2000, '$0,000.00') FROM dual;C、SELECT TO_CHAR(2000, '$9,999.00') FROM dual;D、SELECT TO_CHAR(2000, '$9,999.99') FROM dual;E、SELECT TO_CHAR(2000, '$2,000.00') FROM dual;F、SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
You configured the default backup device type as disk for RMAN backups. In your database，because of business requirements，you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this？（） A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
Using the LIST command in Recovery Manager （RMAN），which two pieces of information in the RMAN repository can be listed？（） A、 stored scripts in the recovery catalogB、 backups that can be deleted from diskC、 backup sets and image copies are obsoleteD、 backups that do not have the AVAILABLE status in the RMAN repository
Which three statements are true about windows?（）A、Only one window can be open at any given timeB、Consumer groups are associated with windowsC、Windows work with job classes to control resource allocationD、The database service name must be provided during windows creationE、Windows can automatically start job or change resource allocation among jobs for various time periods.
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility
SQL语句的编译和执行是在SGA的哪一部分中进行的（）A、Database Buffer CacheB、Redo Log BufferC、Shared PoolD、Large PoolE、Java Pool
Which two statements are true regarding ownership of shared entities? （）(Choose two.)A、Customers is owned by Oracle Human Resources whereas Locations is owned by Oracle Receivables.B、Items is owned by Oracle Purchasing whereas Locations is owned by Oracle Receivables.C、Sales Force is owned by Oracle Order Management whereas Employees is owned by Oracle Human Resources.D、Set of books is owned by Oracle General Ledger whereas Locations is owned by Oracle Human Resources.E、Suppliers is owned by Oracle Purchasing whereas Units of Measure is owned by Oracle Inventory.