The database user OPS$SKD will be able to administer the database.
The authentication detail for the database user OPS$SKD is recorded in the password file.
The local operating system user SKD will be able to access the database instance without specifying the username and password.
The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
第1题:
You work as a database administrator for Certkiller .com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()
第2题:
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()
第3题:
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?()
第4题:
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name. Which statement is true in this case()
第5题:
In your test database, you find that a user’s session is executing a lot of SQL statements, resulting in the generation of a large number of trace files. While investigating the reason, you find that SQL trace has been enabled at the instance level. You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data being generated.How do you achieve this objective?()
第6题:
by setting the SQL_TRACE parameter to FALSE in the parameter file
by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
第7题:
The database user OPS$SKD will be able to administer the database.
The authentication detail for the database user OPS$SKD is recorded in the password file.
The local operating system user SKD will be able to access the database instance without specifying theusername and password.
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
第8题:
You can conned as a common user by using the connect statement.
You can connect as a local user by using the connect statement.
You can connect by using easy connect.
You can connect by using OS authentication.
You can connect by using a Net Service name.
You can connect as a local user by using the SET CONTAINER statement.
第9题:
The ORACLE_BASE base parameter is not set.
The installation is being performed by the root user.
The operating system group that is specified should have the root user as its member.
The operating system group that is specified must have permission to write to the inventory directory
第10题:
no profiles
the default profile
same as the profile of SYS user
same as the profile of SYSTEM user
第11题:
The database user OPS$SKD will be able to administer the database.
The authentication detail for the database user OPS$SKD is recorded in the password file.
The local operating system user SKD will be able to access the database instance without specifying theusername and password.
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
第12题:
<%! int count = 0; %><% if ( request.getSession(false) == null ) count++; %>
<%@ int count = 0; %>. <% if ( request.getSession(false) == null ) count++; %>
<% int count = 0;. if ( request.getSession(false) == null ) count++; %>
<%@ int count = 0;. if ( request.getSession(false) == null ) count++; %>
<%! int count = 0;. if ( request.getSession(false) == null ) count++; %>
第13题:
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?()
第14题:
The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD, and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process()
第15题:
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?()
第16题:
You issued the following command at the UNIX environment: % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command?()
第17题:
to enable operating system authentication for a remote client
to restrict the scope of administration to identical operating systems
to allow the start up and shut down of the database from a remote client
to enable the administration of the operating system from a remote client
to disable the administration of the operating system from a remote client
第18题:
The ORACLE_BASE parameter is not set.
The installation is being performed by the root user.
The operating system group that will be specified should have root user as its member.
The installation is being performed without the Create Starter Database option selected.
The operating system group that will be specified must have permission to write to the inventory directory
第19题:
The operating system local time zone will be set for a user session using the operating system environment variable.
The database local time zone will be set for a user session using the operating system environment variable.
The operating system local time zone will be set for the database using the operating system environment
The database local time zone will be set for the database using the operating system environment variable.
第20题:
You must have started the database instance in restricted mode.
You must have started the database instance inNORMALmode.
You must have started the database instance with server parameter file.
You must have started the database instance but must not have mounted.
You must have started the database instance but must not have opened.
第21题:
The ORACLE_BASE parameter is not set.
The installation is being performed by the root user.
The operating system group that will be specified should have root user as its member.
The installation is being performed without the Create Starter Database option selected.
The operating system group that will be specified must have permission to write to the inventorydirectory.
第22题:
DELETE
CONTROL
DROP DATABASE
ALTER ANY DATASPACE
第23题:
The database user OPS$SKD will be able to administer the database.
The authentication detail for the database user OPS$SKD is recorded in the password file.
The local operating system user SKD will be able to access the database instance without specifying the username and password.
The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
第24题:
by granting a secure application role to the users
by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false
By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.
By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.