Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? ()
A、SELECT student_ id, marks, ROWNUM Rank FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;
B、SELECT student_id, marks, ROWID Rank FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;
C、SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;
D、SELECT student_id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;
E、SELECT student id, marks, ROWNUM Rank FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';
在以下针对“客户机/服务器”计算模式的描述中,哪个选项是错误的()
A、综合了分时共享和资源共享模式的优点
B、数据具有独立性,易于管理和维护
C、客户机负责处理用户界面和用户交互
D、所有工作负载由客户机负担,减少了服务器的工作量
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?()
A、WHERE lower(country_address) = france
B、WHERE lower(country_address) = 'france'
C、WHERE lower(country_address) IS 'france'
D、WHERE lower(country_address) = '%france%'
E、WHERE lower(country_address) LIKE %france%
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is trueabout the output of the command()
A、 The backup piece is expired as the new backup is available.
B、 The backup piece is expired because the operating-system file was not found.
C、 The backup piece is expired because the retention period for the backup has expired.
D、 The backup piece is expired because the backup set to which it belongs is not complete
以下网络技术中不能用于城域网的是()。
A、FDDI
B、Ethernet
C、DQDB
D、ISDN
Which of the following is needed to perform an ASR restore in Windows XP?()
A、Operating system CD
B、Recovery console
C、Vendor recovery CD
D、ERD disk