Oracle User Productivity Kit 11 Technical Consultant Essentials
Question No: 31
You are tasked with installing the Knowledge Center Database using the scripts that are stored on the G drive. Your company currently uses SQL Server 2008.
What are the commands used to build the database using the scripts?
Sqlcmd – I -S”mysqlserver” – i ” G:\Setup\db scripts\MSSQL\knowledgwCenter\createDBObjects.sql ” – n DBOwner =” KUser
password = “password” – v DBName = “KMASTER” – v DBPath = “C: \ database”
Sqlcmd – E – S”mysqlserver” – i ” G:\Setup\db scripts\MSSQL\knowledgwCenter\createDBObjects.sql ” – n DBOwner =” KUser password = “password” – v DBName = “KMASTER” – v DBPath = “C: \ database”
Sqlcmd – E – s “mysqlserver” – e ” G:\Setup\db scripts\MSSQL\knowledgwCenter\createDBObjects.sql ” – n DBOwner =” KUser password = “password” – v DBName = “KMASTER” – v DBPath = “C: \ database”
Sqlplus – s system/password@xe @ “E:\Setup\db scripts\ORACLE\KnowledgeCenter\CreatesSchememaObjects.sql.sql” KUser password KMaster
“C: \ app \ oradata \ orcl \ KMaster.DBF” KMaster_TEMP “C: \app\oradata \ orcl \ KMaster_TMP.DBF”
Explanation: Use Sqlcmd – E – S”mysqlserver” – ietc.
To create the database using the CreateDB.sql script, enter the following at the command prompt:
sqlcmd – The command line application for the Microsoft Sequel server.
-E – Use a trusted connection to the Microsoft Sequel server. To use a login and password, use the -U lt;LOGINIDgt; -P lt;passwordgt; parameters.
-S lt;servernamegt; – The name of the Microsoft SQL server.
-i quot;lt;scriptfilegt;quot; – The path to the script file and the name of the script file.
-v DBName=quot;lt;database namegt;quot; – The name of the database to be created.
-v DBPath=quot;lt;database file locationquot;gt; – The path to the location where you want to create the database.
Statement with generic parameters:
sqlcmd -E -S lt;servernamegt; -i lt;scriptfilegt; -v DBName=quot;lt;VALUE1gt;quot; -v DBPath=quot;lt;Value2gt;quot;
Example with default install parameters:
sqlcmd -E -S quot;mysqlserverquot; -i quot;CreateDB.sqlquot; -v DBName=quot;KMASTERquot; -v DBPath=quot;C:\databasequot;
Question No: 32
Select the two UPK printed documentation outputs that incorporate all items of the published outline.
Business Process Document
Explanation: Training Guide: A printout of the full content of all Topics for a published Outline. This is suitable for use as a handout for trainees.
Instructor Manual: A printout of the full content of all Topics for a published Outline, including brief instructor notes. This is suitable for use as a quot;teacher#39;s editionquot; of a Training Guide, for use by an instructor during classroom training.
Question No: 33
The customer#39;s IT department will not allow anyone outside the department to create a database on its database servers. Identify two considerations to keep in mind while setting up the developer server in this kind of environment.
The IT department can download sample databases from Oracle#39;s website that can be used as the developer database.
The IT department can run a quot;Database-onlyquot; installation or use the scripts provided in the media pack to create the database on its server manually.
The developer server application must be installed before the database is created on the database server by the IT department.
The database must be created on the database server by the IT department before the developer server application is installed.
The developer server application and database must be on the same machine, so the IT department will have to install the developer server at the time it creates the database.
Question No: 34
When installing the multi-user UPK Developer server, you can deploy on either a nonsecure website or a secure website with secure sockets layer (SSL). Your client asks you why installing on a secure website is the preferred method. Which four reasons would you give the client?
encrypts authentication data soit is not transported in clear text across networks
encrypts sensitive data
authenticates that the web server is being accessed by users who are who they say they are
protects data that should be accessed by certain users, and not accessed by others
enables quicker publishing of content for deployment
disables direct publishing to a live Knowledge Center environment
Question No: 35
Identify the mandatory requirement when planning to record an unattended installation.
license file available to all users and accessible on the same path
response file in the same folder from where the installation runs
users have write permission to the folder where setup.exe resides
users have the same mapped network drives that you do
Explanation: Run the Executable Silently
Once you have recorded a parameter file, you can use the /s parameter to run the setup silently. By default, the installation process will look for the response file (.iss) in the same directory as the setup.exe. You use the /f1 parameter to specify a different location of the iss file.
You can use Push technology to distribute executable files for the setup to user desktops.
You record response files which contain the pre-determined default settings, and then you can run the executable silently. If you deploy executable files in this manner, no interaction is necessary on the part of the user. The administrator can control the installation.
You can record response files for any of the setup executables.
Record the Parameter File
To create a parameter file, you use the /r parameter to run the setup executable in record mode. This generates a response file (.iss) that contains the settings you chose while recording. These become the default settings.
The setup.iss file is stored automatically in the Windows folder. You can use the /f1 option to specify a different location in which to create the response file.
Reference: Oracle User Productivity Kit, Installation And Administration Release 11.0, Run the Executable Silently
Question No: 36
Although you can manually customize the logo in each publishing style, such as the player, the Presentation, and the document formats, you can also globally change the logo in all publishing styles and languages for a specific category in the library.
Which menu in the KPK Developer do you use to complete this task?
Explanation: To globally customize logos for a category of publishing styles:
On the Tools menu, choose Customize Logo.
Select a category or accept the default.
Browse to the location of the image file and select it.
Click OK to process the changes. When the process is complete, you can view the activity to determine the changes that were made.
Click OK to close the Update dialog box.
Reference: Oracle User Productivity, Content Development, Use the Customize Logo Tool
Question No: 37
When the Knowledge Center is configured for single sign-on (SSO), the SSO policies on the SSO server needs to be configured to authenticate and authorize the virtual directories. Select the Virtual directories that should be configured as quot;SSO Authenticate and authorizequot; in the SSO policies.
KCenter and KData
KCenter and KContent
KCenter, KData, and KContent
Explanation: Configure the SSO Policies on the SSO Server to authenticate and authorize the following virtual directories.
KCenter – SSO Authenticate and authorize KContent – SSO Authenticate and authorize KContent/ContentTools – anonymous KData – anonymous
Question No: 38
Your customer wants separate content roots for separate project. Identify the correct setup and publication processes to support this requirement.
Additional content roots are set up with UPK setup.exe. UPK content can be published directly to a choice of content roots from the UPK developer.
Additional content roots are set up via setup.exe. UPK content can be imported as a title to a choice of content roots using a drop-down list.
Additional content roots are set up via the Knowledge Center (Content Roots tab). UPK content can be imported as a title to a choice of content roots using a drop-down list.
Additional content roots are set up via the Knowledge Center (Content Roots tab). UPK content can be published directly to a choice of content roots from the UPK developer.
Explanation: To install the Content root with an Oracle database, launch the Setup.exe file located in the root folder in the software installation files. If a Security Warning appears, click Run. You are then prompted to choose the language for the Installer, and the Install Wizard appears. During installation, you will proceed through these screens in the Install Wizard.
Note:A content root is the directory on the server where content files for installed titles are stored. The content root is created and configured during the installation process.
It is possible to have more than one content root; however, you cannot create a content root in the Manager. You create a new content root by running the installation program.
Reference:UPK Master Documentation Library,Install the Content Root (available only in the Professional Edition)
Question No: 39
You have just implemented a multi-user installation of UPK. An author has created content and discovers that the published documents do not reflect the latest changes made by the author. Identify the reason.
The author has created the changes in a library that he or she is not assigned to.
There is an issue in the way the server software has been installed.
Server-side documents are published and local version changes have not been checked in.
Client-side documents are published and server version has not been checked out.
Explanation: The content has been created locally, but have not been checked in.
Question No: 40
Your training coordinator has asked you to review and update three topics in a large outline, which is maintained by a group of authors. You plan to review while traveling, but you will not have access to the server.
Select the process that enables you to review while traveling without access to the server.
Check out the outline and all related documents so you have access to the full outline and all its related documents while you are offline.
Do not check out any files because the system has local data storage and after you connect to the server, the changed files will be synchronized.
Check out the topics that you need to review and get any other documents you might need.
Check out the topics and related documents that you need to review and use the Get command for any other documents you might need.
Explanation: If you plan to explicitly work offline, you should always check out documents that you need to edit before going
offline. You may also want to use the Get command from the Document menu to ensure that you have local copies of
the most recent documents that you want to view in addition to those that you want to edit.
If you go offline and do not
have copies of some documents in your local cache, those documents will be unavailable to you. To remedy this, you
will need to go back online and quot;getquot; the documents that you need.
If you are working online you do not need to perform a “get” operation.
Reference:functional best practices
Oracle user productivity kit,multi-user: get vs. Checkout
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|