|
Question 1.
Which three utilities can be used to prepare for and create the central store? (Choose three.)
A. CTXDOMAINPREP
B. CTXSCHEMAPREP
C. CTXSERVERPREP
D. CTXFILESYNCPREP
E. CTXFILESYNCCLEAN
Answer: A, B, D
Question 2.
Scenario: The agent has just been installed. When the agent starts, the following error message is displayed:
Meta Frame Password Manager agent is unable to retrieve the License server location. Check to see if agent can connect to synchronization point. Agent is disabled.
Which action must you take to resolve this situation?
A. Open the Password Manager console and create a user configuration with the correct License
server for the affected user.
B. Open the License Management console and create a user configuration with the correct
License server for the affected user.
C. Open a command prompt on the affected machine and use the ping command to verify that
the agent can reach the License server.
D. Open a command prompt on the affected machine and use the NSLOOKUP command to
verify that the agent can resolve the hostname of the License server.
Answer: A
Question 3.
Which information is used as the basis for the credential encryption keys?
A. Client names
B. License types
C. Windows logon credentials
D. Application credential information
Answer: C
Question 4.
When configuring a web application that requires advanced matching to distinguish between web frames, which three criteria can be specified? (Choose three.)
A. Text
B. Rows
C. HTML
D. Attribute
E. Columns
Answer: A, C, D
Question 5.
Scenario: You are the administrator of a network that includes an implementation of Citrix Password Manager 4.0. You are planning to rebuild the server hosting the NTFS Shared Folder central store. You already copied your NTFS Shared Folder central store data to a new server.
Currently the Password Manager agents are still using the central store on the old server.
Currently the Password Manager agent is distributed through a Group Policy Object (GPO) in Active Directory at the domain level.
Which sequence of actions is the easiest way to configure the agents to point to the new central store?
A. Create a new Password Manager agent 4.0 administrative installation package that points to
the old central store location;
Create a new GPO to deploy this package at the domain level;
Delete the old GPO that points to the old central store;
In the console, configure all users to be redirected to the new central store.
B. Create a new Password Manager agent 4.0 administrative installation package that points to
the new central store location;
Create a new GPO to deploy this package at the domain level;
Delete the old GPO that points to the old central store;
In the console, configure all users to be redirected to the old central store.
C. Create a Password Manager agent 4.0 administrative installation package that points to the
old central store location;
Edit the existing GPO and delete the existing agent package;
Add the new agent package to this GPO;
Redeploy this package to all users;
In the console, configure all users to be redirected to the new central store.
D. Create a Password Manager agent 4.0 administrative installation package that points to the
new central store location;
Edit the existing GPO and delete the existing agent package;
Add the new agent package to this GPO;
Redeploy this package to all users;
In the console, configure all users to be redirected to the new central store
Answer: D
Question 6.
Where is the disconnected mode period for the licensing model configured?
A. In the User Configuration node of the Password Manager Console
B. In the User Configuration tab of the License Management Console
C. In the Licensing Provisioning node of the Password Manager Console
D. In the Licensing Provisioning tab of the License Management Console
Answer: A
Question 7.
When using the Password Manager Service Configuration Tool, what is the purpose of the user account with rights and privileges specific to data proxy?
A. It resets user passwords.
B. It connects to the data proxy.
C. It hosts the Citrix XTE Service.
D. It reads and writes data to the central store.
Answer: D
Question 8.
The Password Manager console user configuration wizard provides the ability to assign _____ and _____ to the users. (Fill in the blanks with the two correct options).
A. password policies
B. application definitions
C. identity verification questions
D. multiple question authentication
Answer: A, B
Question 9.
If you wish to enable data integrity on a central store that has pre-existing data that has never been signed, you must _____ before you _____. (Fill in the blanks with the correct pair of options.)
A. enable data integrity on the console; sign the data with the signing tool
B. sign the data with the signing tool; enable data integrity on the console
C. disable data integrity on the console; unsign the data with the signing tool
D. unsign the data with the signing tool; enable data integrity on the console
Answer: B
Question 10.
When configuring a host application, how can the administrator configure the definition to submit an "Enter" before submitting credentials to the host?
A. Type "@E" into the "Keys before" setting in the console
B. Type "Enter" into the "Keys before" setting in the console
C. Enable the "Use ENTER instead of TAB to move between fields on this form" setting in the
console
D. Disable the "Use ENTER instead of TAB to move between fields on this form" setting in the
console
Answer: A
Question 11.
Which three tasks need to be completed to enable self-service password reset in an existing Password Manager deployment? (Choose three.)
A. Enable multiple question authentications
B. Enable self-service password reset in Logon Manager
C. Enable the self-service password reset feature license
D. Enable self-service password reset for each user configuration
E. Redeploy the agent software with the self-service password reset feature enabled
Answer: A, D, E
Question 12.
Which three components are required on the server running Password Manager for a successful implementation of the smart card software? (Choose three.)
A. PC/SC software
B. Citrix Presentation Server
C. Microsoft Active Directory
D. Smart card reader software drivers
E. Cryptographic Service Provider software
Answer: A, D, E
Question 13.
If multiple Password Manager administrators are using the console simultaneously, how does Password Manager ensure that changes are not lost?
A. Password Manager restricts access to nodes already in use by other administrators.
B. Password Manager console dynamically updates data as it changes. Administrators see the
changes in real time.
C. Password Manager uses an internal algorithm for conflict resolution. No further intervention is
required by administrators.
D. Password Manager generates a warning at save time if changes have occurred since the
console was opened. Administrators are required to run discovery before saving.
Answer: D
Question 14.
Scenario: A user who logs on to two different workstations throughout the day reports that changes made to each of the workstations are not synchronized right away. You are required to resolve the user's problem and minimize the impact on network bandwidth.
Which user configuration setting would meet this requirement?
A. Disable the "Time between automatic synchronization requests"
B. Enable the "Time between automatic synchronization requests" and set the "Minutes" value to
1
C. Enable the "Synchronize every time the users launch recognized applications or Logon
Manager"
D. Disable the "Synchronize every time the users launch recognized applications or Logon
Manager"
Answer: C
Question 15.
Scenario: In an organization, 15 laptops are used by the remote workforce for field work. Password Manager is installed and named user licensing is implemented on the laptops. One laptop is lost and its named user license is checked out.
What must be done to reclaim this license?
A. Restart the license server.
B. Wait until the disconnected mode expires and the license will be checked in automatically.
C. Use the License Management Console license returns function and select the hostname of the
affected computer.
D. Use the LMCONFIG -r command on the License server and provide the hostname of the
affected computer as a parameter on the command line.
Answer: B
|
Question 1.
The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?
A. SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id = '%SA_';
B. SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id LIKE '%SA_';
C. SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id LIKE '%SA_' ESCAPE "\";
D. SELECT employee_id, last_name, job_id
FROM employees
WHERE job_id LIKE '%SA\_%' ESCAPE '\';
Answer: D
Explanation:
ESCAPE identifier to search for the actual % and _ symbol
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 2-13
Question 2.
You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
What happens when you execute this DELETE statement?
DELETE employees;
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. You get an error because the statement is not syntactically correct.
D. The data in the EMPLOYEES table is deleted but not the structure.
Answer: D
Explanation:
You can remove existing rows from a table by using the DELETE statement.
DELETE [FROM] table
[WHERE condition];
Question 3.
You need to create a table named ORDERS that contains four columns:
1. an ORDER_ID column of number data type
2. a CUSTOMER_ID column of number data type
3. an ORDER_STATUS column that contains a character data type
4. a DATE_ORDERED column to contain the date the order was placed
When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead.
Which statement accomplishes this?
A. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) DEFAULT 'PENDING',
date_ordered VARCHAR2 );
B. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) DEFAULT 'PENDING',
date_ordered DATE );
C. CREATE OR REPLACE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) DEFAULT 'PENDING',
date_ordered DATE );
D. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status NUMBER(10) DEFAULT 'PENDING',
date_ordered DATE );
E. CREATE OR REPLACE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) = 'PENDING',
date_ordered DATE );
F. CREATE TABLE orders (
order_id NUMBER(10),
customer_id NUMBER(8),
order_status VARCHAR2(10) = 'PENDING',
date_ordered DATE );
Answer: B
Explanation:
Requirement that Order_Status should be a character data type
Note: Order_status must be a character data type. There is also a syntax error.
Question 4.
Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMPLOYEES e, DEPARTMENTS d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?
A. selection, projection, join
B. selection, intersection, join
C. intersection, projection, join
D. difference, projection, product
E. difference, projection, join
Answer: A
Explanation:
Selection, projection and join capabilities of a SELECT statement are performed in this view.
Question 5.
Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)
A. INTERVAL YEAR TO MONTH
B. INTERVAL DAY TO SECOND
C. TIMESTAMP
D. INTERVAL MONTH TO DAY
E. TIMESTAMP WITH DATABASE TIMEZONE
Answer: A, B, C
Explanation:
TIMESTAMP, INTERVAL DAY TO SECOND and INTERVAL YEAR TO MONTH can be used to specify column definition.
Question 6.
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?
A. SELECT ename, salary*12 'Annual Salary'
FROM employees;
B. SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY")
FROM employees
C. SELECT ename, salary*12 "Annual Salary"
FROM employees;
D. SELECT ename, salary*12 AS Annual Salary
FROM employees;
Answer: C
Explanation:
This SQL statement provides correct syntax to generate the alias Annual Salary for the calculated column SALARY*12.
Question 7.
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
Which three statements insert a row into the table? (Choose three.)
A. INSERT INTO employees( first_name, last_name)
VALUES( 'John', 'Smith');
B. INSERT INTO employees
VALUES ( NULL, 'John', 'Smith');
C. INSERT INTO employees (employee_id, first_name, last_name)
VALUES ( 1000, 'John', ' ');
D. INSERT INTO employees (employee_id)
VALUES (1000);
E. INSERT INTO employees (first_name, last_name, employee_id)
VALUES ( 1000, 'John', 'Smith');
F. INSERT INTO employees
VALUES ( '1000', 'John', NULL);
Answer: C, D, F
Explanation:
EMPLOYEE_ID is a primary key.
Incorrect answer :
A EMPLOYEE_ID cannot be null
B EMPLOYEE_ID cannot be null
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-11
Question 8.
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?
A. SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy')
FROM dual;
B. SELECT DECODE(SUBSTR(SYSDATE, 8), 'year')
FROM dual;
C. SELECT TO_DATE(SYSDATE,'yyyy')
FROM dual;
D. SELECT TO_CHAR(SYSDATE,'yyyy')
FROM dual;
E. SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY')
FROM dual;
Answer: D
Explanation:
Function TO_CHAR(x, y) converts the value x to a character or converts a date to a character string using formatting conventions.
Question 9.
Which two statements about sequences are true? (Choose two.)
A. You use a CURRVAL pseudo column to generate a value from a sequence that would be used
for a specified database column.
B. You use a CURRVAL pseudo column to look at the current value just generated from a
sequence, without affecting the further values to be generated from the sequence.
C. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by
actually retrieving the value from the sequence.
D. You use a NEXTVAL pseudo column to look at the next possible value that would be
Generated from a sequence, without actually retrieving the value.
E. You use a REUSE clause when creating a sequence to restart the sequence once it generates
the maximum value defined for the sequence.
F. If a sequence starting from a value 100 and incremented by 1 is used by more than one
application, then all of these applications could have a value of 105 assigned to their column
whose value is being generated by the sequence.
Answer: B, C
Explanation:
You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
Incorrect Answers:
A: You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
D: You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
E: This statement is not correct. There is no limitation like that in Oracle.
F: You use CYCLE clause, not REUSE, when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 315-322Chapter 7: Creating Other Database Objects in Oracle
Question 10.
In which two cases would you use an outer join? (Choose two.)
A. Only when the tables have a primary key-foreign key relationship.
B. The tables being joined have NOT NULL columns.
C. The tables being joined have both matched and unmatched data.
D. The columns being joined have NULL values.
E. The tables being joined have only matched data.
F. The tables being joined have only unmatched data.
Answer: C, D
Explanation:
You use an outer join to also see rows that do not meet the join condition.
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 4-17
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.