单选题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?（）Aby granting a secure application role to the usersBby creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to falseCBy creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4DBy Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.EBy implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）AOracle Data Pump.BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.DOnline Table Redefinition.EEdition-Based Table Redefinition.
多选题Which three functions are performed by the SQL Tuning Advisor?（）ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending the restructuring of SQL queries that are using bad plans
多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.BUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.CUse the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.DUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.EUse the MD_RESTORE command to restore both the metadata and data for the failed disk group.FUse the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
多选题On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $ sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.BIt fails because no SQL *Loader data file location is specified.CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.DIt fails because no SQL *Loader control file location is specified.
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）AAll database operations performed by the impdp command are logged.BOnly CREATE INDEX and CREATE TABLE statements generated by the import are logged.COnly CREATE TABLE and ALTER TABLE statements generated by the import are logged.DNone of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.