A.四环素
B.米诺环素
C.氯霉素
D.多西环素
E.链霉素
第1题
A. SUM(start_date)
B. AVG(start_date)
C. COUNT(start_date)
D. AVG(start_date, end_date)
E. MIN(start_date)
F. MAXIMUM(start_date)
第2题
A. Flashback logs are written sequentially, and are archived.
B. Flashback Database uses a restored control file to recover a database.
C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.
D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
F. Flashback logs are used to restore to the blocks‘ before images, and then the redo data may be used to roll forward to the desired flashback time.
第3题
A. SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name=‘Mating‘ AND ord _ date IN (‘18-JUL-2000‘,‘21-JUL-2000‘);
B. SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = ‘MARTIN‘));
C. SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = ‘Martin‘);
D. SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = ‘Martin‘);
第4题
A.toavoidroundtripstotheserverbyenablingcachingofqueryresultsinclientmemory
B.toimproveperformancebystoringacopyofthedatafromtheprivateSQLareaofthePGA
C.toenhancethequeryperformancebycreatingacacheintheclientmemoryforsortingoperations
D.toavoidthestoringofqueryplansandresultsintheserverbycreatingacacheintheclientmemory
第5题
A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!