To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（） To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）..

第1题

[单选题] The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?（）

A、GRANT select ON dept TO ALL_ USER; B、GRANT select ON dept TO ALL; C、GRANT QUERY ON dept TO ALL_USERS D、GRANT select ON dept TO PUBLIC;

点击查看答案

第2题

[单选题] The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）

A、GRANT select ON dept TO ALL_ USER; B、GRANT select ON dept TO ALL; C、GRANT QUERY ON dept TO ALL_USERS D、GRANT select ON dept TO PUBLIC;

点击查看答案

第3题

[单选题] You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）

A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3 B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3 C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3 D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3; E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

点击查看答案

第4题

[单选题] You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）

A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3 B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3 C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3 D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3; E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

点击查看答案

第5题

[多选题] You want to restrict access to a role based on the client machine from which the user is accessing the network.Which two role restrictions accomplish this goal? （）

A、user name B、password length C、certificate D、Host Checker

点击查看答案

第6题

[单选题] You would like to configure your PC's IP address of 10.10.0.156 as an FTP host with a username of user and a password of mypass.Which configuration command accomplishes this goal?（）

A、host user pc 10.10.0.156 ftp user mypass B、host user pc 10.10.0.156 tftp user mypass C、host name user pc 10.10.0.156 ftp user mypass D、host name user pc 10.10.0.156 tftp user mypass

点击查看答案

第7题

[单选题] You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users 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 SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4 D、By Implementing Fine-Grained Auditing (FGA) and setting the 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.

点击查看答案

第8题

[单选题] A user wants to be permanently added to the dba group. Which of the following commands or processes can be used to accomplish this（）

A、chgrp B、chuser C、edit /etc/user D、edit /etc/security/group

点击查看答案

第9题

[单选题] Your corporate security policy requires that a user performing attacks must have limited network access and activities until an administrator can investigate.In the admin GUI, which sensor event policy action must you configure in "Configuration" > "Sensors" > "Sensor Event Policies" > [rule name] to accomplish this?（）

A、Ignore B、Replace users role C、Terminate user session D、Disable user account

点击查看答案

请使用微信扫码支付