网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）
A
SYS sessions, regardless of the roles that are set in the session
B
SYSTEM sessions, regardless of the roles that are set in the session
C
SCOTT sessions, only if the MGR role is set in the session
D
SCOTT sessions, only if the MGR role is granted to SCOTT
E
SCOTT sessions, because he is the owner of the table
F
SYSTEM session, only if the MGR role is set in the session
参考答案
参考解析
解析：
暂无解析
更多 “多选题A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）ASYS sessions, regardless of the roles that are set in the sessionBSYSTEM sessions, regardless of the roles that are set in the sessionCSCOTT sessions, only if the MGR role is set in the sessionDSCOTT sessions, only if the MGR role is granted to SCOTTESCOTT sessions, because he is the owner of the tableFSYSTEM session, only if the MGR role is set in the session” 相关考题
考题
A redaction policy was added to the SAL column of the SCOTT.EMP table:All users have their default set of system privileges.For which three situations will data not be redacted?()
A. SYS sessions, regardless of the roles that are set in the sessionB. SYSTEM sessions, regardless of the roles that are set in the sessionC. SCOTT sessions, only if the MGR role is set in the sessionD. SCOTT sessions, only if the MGR role is granted to SCOTTE. SCOTT sessions, because he is the owner of the tableF. SYSTEM session, only if the MGR role is set in the session
考题
A routing table contains static, RIP, and IGRP routes destined to the same network with each route set to its default administrative distance. Which route will be the preferred route?（）A、The RIP routeB、The static routeC、The IGRP routeD、All three will load balance.
考题
In the admin GUI, you navigate to "System" "Status" "Active Users". You see several buttons, including "Delete Session", "Delete All Sessions". "Refresh Roles", and "Disable All Users".Which two statements are true?（）A、To forcibly sign out a single user, you should select the check box next to that user's login name, then select "Delete Session".B、If you select "Delete All Sessions", all users are forcibly signed out and are unable to sign in again until "Enable All Users" is selected.C、Selecting "Disable All Users" prevents users from signing in and starting a new session, but does not forcibly sign out any users that already have an existing session.D、Selecting "Refresh Roles" re-evaluates authentication policies, role-mapping rules, and resource policies for all existing user sessions.
考题
A companys computer policy dictates that all users workstations must use the companys corporate web page as their default home page. Which of the following methods should an administrator use to BEST comply with this policy？（）A、 Configure a logon script to set the homepage at logon.B、 Set the default homepage to the corporate website in Group Policy.C、 Manually configure the homepage on all workstations and setup trace logs to ensure compliance.D、 Set the default homepage to the corporate website on the base computer image.
考题
Cer-tech .com runs Terminal services on an Active Directory domain. As an administrator of Cer-tech .com， you configure the main office printer as the default printer on Terminal server. Cer-tech .com has astringent security policy which states that all the remote client computers must meet the followingrequirements： * The default printer on client computers must be the main office printer * Users must also be able to access their local printers during a terminal session To meet the companypolicy，you have to set a Group Policy Object by using the Terminal Services Printer Redirection template. What should you do to achieve this objective？（）A、In a session options， set the ’Do not set default client printer’ to default printer Enabled. Apply GPO to the Terminal ServerB、Set the Terminal services option on print to default printer and disable Easy printer driver. Apply the GPO to the Terminal ServerC、Apply the GPO to all the client computers and configure their printer options to Set default printer for office printer and local printers as user printersD、Configure Easy Printer driver and disable the first option. Apply the GPO to the Terminal Server
考题
A System p administrator needs to set the default password length for all users to six characters. Which of the following files needs to be edited to accomplish this （）A、/etc/security/limitsB、/etc/security/mkuser.sysC、/etc/security/privD、/etc/security/user
考题
Which two statements complete a transaction?（）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVEPOINT C;D、GRANT SELECT ON employees TO SCOTT;E、ALTER TABLE employees SET UNUSED COLUMN sal;F、Select MAX(sal) FROM employees WHERE department_id = 20;
考题
All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated. SQL DELETE FROM persons WHERE exp=’Y’； 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands （）A、all sessions of the HR user onlyB、all sessions of the HR user and the SYS userC、the session of the HR user that executed the commandsD、all the sessions for which the database users have access privilege to the PERSONS table
考题
Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）A、REF B、TABLE C、CLOB D、VARRAY
考题
You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.C、Data is never redacted for the EMP_V.SAL column.D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
考题
You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A、 The statistics are stored in the pending statistics table in the data dictionary.B、 The statistics are treated as the current statistics by the optimizer for all sessions.C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
Which two statements complete a transaction? （）A、DELETE employees;B、DESCRIBE employees;C、ROLLBACK TO SAVE POINT C;D、GRANT SELECT ON employees TO SCOTHE、ALTER TABLE employees SET UNUSED COLUMN sal;F、Select MAX(sal) FROM employees WHERE department _ id 20;
考题
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）A、SYS sessions, regardless of the roles that are set in the sessionB、SYSTEM sessions, regardless of the roles that are set in the sessionC、SCOTT sessions, only if the MGR role is set in the sessionD、SCOTT sessions, only if the MGR role is granted to SCOTTE、SCOTT sessions, because he is the owner of the tableF、SYSTEM session, only if the MGR role is set in the session
考题
While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）A、the CREATE TABLE .. commandB、sorting of the SYSTEM tablespace’s dataC、sorting of data required by recursive SQL statementsD、the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE、sorting of data if the users have not been allocated temporary tablespace explicitlyF、sorting of data if the users have been allocated temporary tablespace explicitly
考题
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）A、grant CONNECT role to all of the three usersB、grant RESOURCE role to all of the three usersC、grant both CONNECT and RESOURCE role to all of the three usersD、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersE、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
考题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）A、LOCK TABLE emp IN SHARE MODE；B、LOCK TABLE emp IN EXCLUSIVE MODE；C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
考题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?（）A、UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = did WHERE employee _id IN (103,115);B、UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';C、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115);D、UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';E、UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = did WHERE employee_id IN (103,115);
考题
The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000); Which is true about your ALTER statement?（） A、Column definitions cannot be altered to add DEFAULT values.B、A change to the DEFAULT value affects only subsequent insertions to the table.C、Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.D、All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
考题
You work as the IT professional in an international company which is named Wiikigo. You are experiencedin implementing and administering a network operating system. You are specialized in deploying servers，configuring Windows Server 2008 Terminal services and network application services， and configuring aweb services infrastructure. There is an Active Directory domain in your company. The company runsTerminal Services. You have the head office printer configured as the default printer on the TerminalServer. According to the requirements of the company policy， all remote client computers must meet thefollowing requirements： Users must be able to access their local printers during a terminal session. The head office printer must bethe default printer of the client computers. A Group Policy object （GPO） needs to be created by using theTerminal Services Printer Redirection template to meet the company policy. What action should you perform？（）A、The Do not set default client printer should be set to be default printer in a session option to Enabled.The GPO should be applied to all the client computers.B、The Easy Print driver first option should be set to Disabled. The GPO should be applied to the Terminal Server.C、The Use Terminal Services Easy Print driver first option should be set to Disabled. The GPO should be applied to all the client computers.D、The Do not set default client printer should be set to be default printer in a session option to Enabled.The GPO should be applied to the Terminal Server.
考题
多选题Which two statements complete a transaction? （）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVEPOINT C;DGRANT SELECT ON employees TO SCOTT;EALTER TABLE employees SET UNUSED COLUMN sal;FSELECT MAX(sal) FROM employees WHERE department_id = 20;
考题
多选题You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.BData is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.CData is never redacted for the EMP_V.SAL column.DData is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.EData is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
考题
多选题Which two statements complete a transaction?（）ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVE POINT C;DGRANT SELECT ON employees TO SCOTHEALTER TABLE employees SET UNUSED COLUMN sal;FSelect MAX(sal) FROM employees WHERE department _ id 20;
考题
单选题All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）A
All sessions of the HR user onlyB
All sessions of the HR user and the SYS userC
The session of the HR user that executed the commandsD
All the sessions for which the database users have access privilege to the PERSONS table
考题
多选题In the admin GUI, you navigate to "System" "Status" "Active Users". You see several buttons, including "Delete Session", "Delete All Sessions". "Refresh Roles", and "Disable All Users".Which two statements are true?（）ATo forcibly sign out a single user, you should select the check box next to that user's login name, then select Delete Session.BIf you select Delete All Sessions, all users are forcibly signed out and are unable to sign in again until Enable All Users is selected.CSelecting Disable All Users prevents users from signing in and starting a new session, but does not forcibly sign out any users that already have an existing session.DSelecting Refresh Roles re-evaluates authentication policies, role-mapping rules, and resource policies for all existing user sessions.
考题
多选题A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）ASYS sessions, regardless of the roles that are set in the sessionBSYSTEM sessions, regardless of the roles that are set in the sessionCSCOTT sessions, only if the MGR role is set in the sessionDSCOTT sessions, only if the MGR role is granted to SCOTTESCOTT sessions, because he is the owner of the tableFSYSTEM session, only if the MGR role is set in the session
考题
单选题You executed the following commands： SQL ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）； Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）A
The statistics are stored in the pending statistics table in the data dictionary.B
The statistics are treated as the current statistics by the optimizer for all sessions.C
The statistics are treated as the current statistics by the optimizer for the current sessions only.D
The statistics are temporary and used by the optimizer for all sessions until this session terminates.
考题
多选题User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）ALOCK TABLE emp IN SHARE MODE；BLOCK TABLE emp IN EXCLUSIVE MODE；CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？DINSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
热门标签
最新试卷