单选题 The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee. Which query can be used?

A、 SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;

B、 SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;

C、 SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

D、 SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

由4l***gn提供分享举报纠错

相关试题

单选题 choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp
SET UNUSED (mgr_id);
Which statement is true regarding the effect of the above SQL statement?

A、Any views created on the EMP table that include the MGR_ID column would be automatically modified and remain valid.

B、Any constraints defined on the MGR_ID column would be removed by the above command.

C、Any synonym existing on the EMP table would have to be re-created.

D、Any index created on the MGR in column would continue to exist until the DROP UNUSED COLUMNS command is executed.

查看答案

单选题 You are administering a database and you receive a requirement to apply t he following restrictions:
1A connection must be terminated after four unsuccessful login attempts by user.
2A user should not be able to create more than four simultaneous sessions.
3User session must be terminated after 15 minutes of inactivity.
4Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

A、by granting a secure application role to the users

B、by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE

C、By creating and assigning a profile to the users and setting the FAILED_LOGIN_ATTEMPTS parameter to 4

D、By Implementing Fine-Grained Auditing (FGA) REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

E、By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

查看答案

单选题 choose one
Which statement is true about the DEFAULT profile?

A、It can be dropped and recreated.

B、It must be explicitly assigned to a user.

C、The values assigned to the resource limits and password parameters in the default profile can be altered.

D、A different DEFAULT profile can be created for each user in a database.

查看答案

单选题 A user establishes a connection to a database instance by using an Oracle
Net
Connection. You want to ensure the following:
1The user account must be locked after five unsuccessful login attempts.
2Data read per session must be limited for the user.
3The user cannot have more than three simultaneous sessions.
4The user must have a maximum of 10 minutes session idle time
Before being logged off automatically.
How would you accomplish this?

A、 by granting a secure application role to the user

B、 by implementing Database Resource Manager

C、 by using Oracle Label Security options

D、 by assigning a profile to the user

查看答案

单选题 choose one
Which statement is true about profiles?

A、Resource limits specified in a profile assigned to a user are always enabled.

B、A profile can be assigned only to one user.

C、A user can exist without any profile.

D、Password management using profiles is always enabled.

查看答案

单选题 Evaluate the following ALTER TABLE statement:
ALTER TABLE orders SET UNUSED (order_date);
Which statement is true?

A、After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.

B、The ORDER_DATE column should be empty for the ALTER TABLE command to execute succsessfully.

C、ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.

D、The DESCRIBE command would still display the ORDER_DATE column.

查看答案

单选题 Examine the description of the SALES1 table:
SALES2 is a table with the same description as
SALES1. Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

A、INTERSECT

B、UNION ALL

C、UNION

D、SUBTRACT

E、MINUS

查看答案

单选题 In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?

A、Setting a metric threshold

B、Implementing Database Resource Manager

C、Enabling resumable timeout for user sessions

D、Decreasing the value of t he IDLE_TIME resource limit in t he default profile

查看答案