网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Where is the run date for an ‘at’ job located?（）
- A、Within the job environment set up
- B、Within the user data of the at job
- C、In the file name preceeded with a userid
- D、In a special file used by the cron daemon
参考答案
更多 “Where is the run date for an ‘at’ job located?（）A、Within the job environment set upB、Within the user data of the at jobC、In the file name preceeded with a useridD、In a special file used by the cron daemon” 相关考题
考题
查询所有目前年龄在35岁以上(不含35岁)的职工信息(姓名、性别和年龄)，正确的命令是（ ）。A) SELECT 姓名，性别，YEAR(DATE())-YEAR(出生日期) 年龄 FROM 职工; WHERE 年龄35 B) SELECT 姓名，性别，YEAR(DATE())-YEAR(出生日期) 年龄 FROM 职工; WHERE YEAR(出生日期)35 C) SELECT 姓名，性别，YEAR(DATE())-YEAR(出生日期) 年龄 FROM 职工; WHERE YEAR(DATE())-YEAR(出生日期)35 D) SELECT 姓名，性别,年龄=YEAR(DATE())-YEAR(出生日期)FROM 职工; WHERE YEAR(DATE())-YEAR(出生日期)35
考题
查向所有目前年龄在35以上(不含35岁)的职工信息(姓名、性别和年龄)的正确的命令是______。A．SELECT 姓名，性别，YEAR (DATE()) -YEAR(出生日期)年龄 FROM 职工； WHERE 年龄＞35B．SELECT 姓名，性别，YEAR (DATE()) -YEAR(出生日期)年龄 FROM 职工； WHERE YEAR (出生日期)＞35C．SELECT 姓名，性别，YEAR (DATE())- YEAR (出生日期)年龄 FROM 职工； WHERE YEAR (DATE())- YEAR(出生日期)＞35D．SELECT 姓名，性别，年龄＝YEAR(DATE())- YEAR(出生日期)FROM 职工； WHERE YEAR(DATE())-YEAR (出生日期)＞35
考题
The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
考题
Consider the query:Mysql＞ SET @run = 15;Mysql＞ EXPLAIN SELECT objective, stage, COUNT (stage)FROM iteminformationWHERE run=@run AND objective=’7.1’GROUP BY objective,stageORDER BY stage;The iteminformation table has the following indexes;Mysql＞ SHOW INDEXES FROM iteminformation:This query is run several times in an application with different values in the WHERE clause in a growing data set.What is the primary improvement that can be made for this scenario?（）A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexesB.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operationsC.Drop the run_2 index because it has caused a conflict in the choice of key for this queryD.Execute the run_2 index because it has caused a conflict in the choice of key for this queryE.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
考题
查询所有目前年龄在35岁以上(不含35岁)的职工信息(姓名、性别和年龄)，正确的命令是A．SELECT 姓名，性别，YEAR(DATE())-YEAR(出生日期)AS年龄FROM职工； WHERE年龄＞35B．SELECT 姓名，性别，YEAR(DATE())-YEAR(出生日期)AS年龄FROM 职工； WHERE YEAR(出生日期)＞35C．SELECT姓名，性别，YEAR(DATE())-YEAR(出生日期)AS年龄FROM 职工； WHEREYEAR(DATE())-YEAR(出生日期)＞35D．SELECT姓名，性别，年龄：YEAR(DATE())-YEAR(出生日期)FROM 职工； WHERE YEAR(DATE())-YEAR(出生日期)＞35
考题
设有职工表(部门号，职工号，姓名，性别，出生日期)，查询所有目前年龄在40岁以下(包含40岁)的职工信息(姓名、性别和年龄)，正确的命令是________。A．SELECT 姓名，性别,YEAR(DATE())-YEAR(出生日期) 年龄 FROM 职工 WHERE 年龄＜=40B．SELECT 姓名，性别,YEAR(DATE())-YEAR(出生日期) 年龄 FROM 职工 WHERE YEAR(出生日期)＜=40C．SELECT 姓名，性别,YEAR(DATE())-YEAR(出生日期) 年龄 FROM 职工 WHERE YEAR(DATE())-YEAR(出生日期)＜=40D．SELECT 姓名，性别，年龄=YEAR(DATE())-YEAR(出生日期) FROM 职工 WHERE YEAR(DATE())-YEAR(出生日期)＜=40
考题
Where is the run date for an ‘at’ job located?()
A.Within the job environment set upB.Within the user data of the at jobC.In the file name preceeded with a useridD.In a special file used by the cron daemon
考题
日期型变量rq已经被赋值，要在数据表users中查询在rq表示的日期值之后注册的用户，下面SQL语句正确的是（）。A、str="Select * From users Where reg_date# rq #B、str="Select * From users Where reg_date#" rq "#"C、str="Select * From users Where reg_date" "#" rq "#"D、str="Select * From users Where reg_date" # rq #
考题
Which of the following has NO effect on controlling the access permissions needed to run the "date" command on the remote machine "Earth" using the following syntax？rsh Earth date（）。A、The local file： /etc/.netrcB、The remote file： ~/ .rhostsC、The securetcpip commandD、The remote file： /etc/hosts.equiv
考题
Which of the following local files is used to run the date command on the remote machine "Earth" using the following rexec command without request for a password？ rexec Earth date（）。A、~/ .rhostsB、$HOME/.netrcC、/etc/hosts.equivD、/etc/security/user
考题
Where is the run date for an ’at’ job located？（）A、Within the job environment set upB、Within the user data of the at jobC、In the file name preceeded with a useridD、In a special file used by the cron daemon
考题
You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（） A、an error because the ROUND function specified is invalid B、an error because the WHERE condition specified is invalid C、number of days since the promo started based on the current Chicago date and time D、number of days since the promo started based on the current Singapore date and time
考题
单选题Which of the following has NO effect on controlling the access permissions needed to run the "date" command on the remote machine "Earth" using the following syntax？rsh Earth date（）。A
The local file： /etc/.netrcB
The remote file： ~/ .rhostsC
The securetcpip commandD
The remote file： /etc/hosts.equiv
考题
单选题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';
考题
单选题You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）A
SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date '21-JAN-2001' ORDER BY purchase_date;B
SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date '21-JAN-2001' ORDER BY purchase date ASC;C
SELECT book_title FROM books WHERE price 500 or 900 AND purchase_date '21-JAN-2001' ORDER BY purchase date DESC;D
SELECT book_title FROM books WHERE (price 500 OR price 900) AND purchase_date '21-JAN-2001' ORDER BY purchase date DESC;
考题
单选题The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A
SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B
SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C
SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D
SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
考题
单选题If the vessel does not arrive by the canceling date，and the Charterer（）expenses，these expenses can be claimed by him from the Shipowner where they are in the reasonable contemplation of the parties.A
occursB
incursC
discusD
recurs
考题
单选题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';
考题
单选题Which of the following local files is used to run the date command on the remote machine "Earth" using the following rexec command without request for a password？ rexec Earth date（）。A
~/ .rhostsB
$HOME/.netrcC
/etc/hosts.equivD
/etc/security/user
考题
单选题The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A
SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE 5;B
SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE 5;C
SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 5;D
SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 5;
考题
单选题Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 100 12-JAN-2000 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 104 25-JUN-2000 15 6000 105 18-JUL-2000 20 5000 106 18-JUL-2000 35 7000 107 21-JUL-2000 20 6500 04-AUG- 108 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Linda New York Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）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');
考题
单选题You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（）A
an error because the ROUND function specified is invalid B
an error because the WHERE condition specified is invalid C
number of days since the promo started based on the current Chicago date and time D
number of days since the promo started based on the current Singapore date and time
考题
单选题Where a charter-party specifies the estimated time of arrival of a vessel at the port of loading，there is（）obligation on the shipowners to sail to there on the date on which when proceeding with all convenient speed it would normally reach the port on or about the estimated date of arrival.A
an optionalB
a reasonableC
an absoluteD
rational
考题
单选题Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?（）A
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' 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 FROMorders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');
考题
单选题Where is the run date for an ‘at’ job located?（）A
Within the job environment set upB
Within the user data of the at jobC
In the file name preceeded with a useridD
In a special file used by the cron daemon
考题
单选题设借阅表的表结构为（读者编号，图书编号，借书日期，还书日期）。其中借书日期和还书日期的数据类型是日期类型，当还书日期为空值时，表示还没有归还。如果要查询尚未归还，且借阅天数已经超过60天的借阅信息时，应该使用的SQL语句是（ ）。A
SELECT * FROM借阅表WHERE（借书日期-DATE（））600R还书日期=NULLB
SELECT * FROM借阅表WHERE（DATE（）-借书日期）600R还书日期IS NULLC
SELECT * FROM借阅表WHERE（借书日期-DATE（））60 AND还书日期=NULLD
SELECT * FROM借阅表WHERE（DATE（）-借书日期）60 AND还书日期IS NULL
考题
单选题查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）A
select * from emp where hiredate='19820101';B
select * from emp where hiredate=to_char('19820101','YYYYMMDD');C
select * from emp where to_date(hiredate,'YYYYMMDD')='19820101';D
select * from emp where to_char(hiredate,'YYYYMMDD')='19820101';
热门标签
最新试卷
