Examine these statements:System altered.SESSIONS_PER_USER 3FAILED LOGIN ATTEMPTS 3Profile altered.User altered.A) User HR is permitted to create more than three concurrent sessions.C) Password complexity checking is enforced for user HR.E) The HR account will be loc...【阅读全文】
30、choose oneWhich 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 pro...【阅读全文】
28、Which four account management capabilities can be configured using Oracle profiles? (Choose four.)A. the number of hours for which an account is locked after the configured number of login attempts has been reachedB. the number of days for which an account may be inactive before it i...【阅读全文】
26、Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)A. Column positions must be used in the ORDER BY clauseB. Only column names from the first SELECT statement in the compound query are recognize...【阅读全文】
25、Which three instance situations are possible with the Oracle Database server without multi-tenant?(Choose three.)A. two or more instances on separate servers all associated with one databaseB. one instance on one server associated with one databaseC. one instance on one server as...【阅读全文】
24、Evaluate these commands which execute successfully:CREATE SEQUENCE ord_seqINCREMENT BY 1START WITH 1MAXVALUE 100000CYCLECACHE 5000;CREATE TABLE ord_items(ord_no NUMBER(4) DEFAULT ord_seq.NEXTVALUE NOT NULL,item_no NUMBER(3),qty NUMBER(3),expiry_date ...【阅读全文】