|
Question 1.
Which of the following GUI interfaces are used for save set recovery in Microsoft Windows and UNIX?
A. winworkr in Microsoft Windows and nwadmin in UNIX
B. no save set recovery in Microsoft Windows and nwrecover in UNIX
C. nwadmin in both Microsoft Windows and UNIX
D. nwadmin in Microsoft Windows and nwrecover in UNIX
E. winworkr in Microsoft Windows and nwrecover in UNIX
Answer: A
Question 2.
You work as a network administrator at ITCertKeys.com. ITCertKeys.com has a Net Worker server with one tape drive that is used to back up one client.
You want to prevent multiplexing of the backed up data. What can you do?
A. Set parallelism on the Net Worker server to 1.
B. Disable multiplexing in the Client resource.
C. Set target sessions to 1 in the Tape Drive resource.
D. Set parallelism to 1 in the Device resource.
Answer: A
Question 3.
Which two of the following UNIX interfaces can you use to monitor backup device throughput? (Choose two.)
A. nwrecover
B. nwadmin
C. rmon
D. nsrmon
E. nsrwatch
F. nwbackup
Answer: B, E
Question 4.
Which three of the following statements are TRUE? (Choose three.)
A. Cloning a volume may require that multiple volumes be read.
B. Cloning a volume may result in multiple volumes being written to.
C. Clone data can only be directed to volumes in clone pools.
D. Clone data can only be written to media of the same type as the original volume.
E. Clone data can only be written to the same pool that it is being read from.
Answer: A, B, C
Question 5.
You work as a network administrator at ITCertKeys.com. You need to recover a Net Worker server.
Which three of the following would you need? (Choose three.)
A. backup of the media database and resource files
B. Client File Index (CFI)
C. ASR
D. bootstrap report(s)
E. storage node nsr.res
Answer: A, B, D
Question 6.
You work as a network administrator at ITCertKeys.com. You want to clone a volume.
Which of the following save sets will be cloned?
A. All save sets with data on the volume.
B. Only save sets beginning and ending on the volume.
C. All save sets beginning on the volume.
D. All save sets ending on the volume.
Answer: C
Question 7.
Which two of the following represent the benefits of using a nsrstage resource? (Choose two.)
A. It can be used to manually stage save sets specified by their save set ID.
B. It monitors selected file and advfile type devices to automatically move save sets based on
configured criteria.
C. It uses a high watermark to designate when staging should start.
D. It monitors selected tape drives to automatically move save sets based on configured criteria.
Answer: B, C
Question 8.
You work as a network administrator at ITCertKeys.com. You want to install a new Net Worker 7.x server and two storage nodes.
Which three of the following should you verify BEFORE proceeding with the installation?
(Choose three.)
A. network connectivity
B. that tape libraries are fully populated with volumes
C. that all system files are available
D. platform compatibility
E. disk space requirements using the 7.x Installation Guide
Answer: A, D, E
Question 9.
You work as a system administrator at ITCertKeys.com. You want to back up data from a UNIX client machine.
Which two of the following commands can you use to accomplish this task? (Choose two.)
A. The nsrsave command.
B. The save command.
C. backup from nwbackup GUI.
D. The savegrp command.
E. The savefs command.
Answer: B, C
Question 10.
You work as a network administrator at ITCertKeys.com. ITCertKeys.com has a tape library with two tape drives. The tape library is connected to a Net Worker server with each tape drive on its own SCSI bus. When you use nsrjb utility to load a tape into the first tape drive, the tape is placed into the second tape drive.
Which of the following is the MOST probable cause of this problem?
A. The wrong device type was assigned to the two tape devices during the jbconfig process.
B. The SCSI buses between each tape drive and its SCSI port on the server are not properly
terminated.
C. An inventory of the tape library has not yet been done so Net Worker does not know where
tapes should be located.
D. The logical device files are assigned to the wrong physical devices during the jbconfig process.
Answer: D
Question 11.
After executing nwrecover on a Solaris server, on which three operating systems you can browse client indexes? (Choose three.)
A. UNIX
B. Microsoft Windows 2000
C. Mac OSX
D. NetWare
E. Solaris
Answer: B, C, E
Question 12.
You work as a network administrator at ITCertKeys.com. You want to prevent client initiated backups.
Which of the following Net Worker server attribute should you set to disabled?
A. Archive Services
B. Client-side Saves
C. Public Archives
D. Manual Saves
E. Client Saves
Answer: D
Question 13.
What is the purpose of the Net Worker Staging resource?
A. Maintain free space on file/advfile type devices by automatically moving save sets when
parameters are met.
B. Configure Net Worker HSM functionality to allow clients to transparently archive and stage
data based on access time.
C. Repack tape volumes containing deleted or expired save sets as well as demultiplexes the
remaining save sets.
D. Configure the disk space used on the Net Worker Server for advfile type devices.
Answer: A
Question 14.
You work as a network administrator at ITCertKeys.com. You want to set the retention time of the save set for a manual save.
Which of the following commands would you use?
A. save -s drum -E 03/24/09 C:\\data
B. save -s drum -v 03/24/09 C:\\data
C. save -s drum -N 03/24/09 C:\\data
D. save -s drum -y 03/24/09 C:\\data
E. save -s drum -w 03/24/09 C:\\data
Answer: D
Question 15.
You work as a network administrator at ITCertKeys.com. ITCertKeys.com has a file system contains millions of small files.
Which of the following is the recommended way to back up this file system for the best performance?
A. An incremental backup.
B. A scheduled online backup.
C. A differential backup.
D. A manual backup.
E. A Power Snap backup.
Answer: E
Question 16.
When the Net Worker Stage resource is used to automatically stage a save set what pool is used?
A. The save set is matched to a pool by Net Worker using the save set's attributes as matching
criteria.
B. A backup clone pool.
C. The pool defined as an attribute for that Net Worker Stage resource's configuration.
D. The same pool as the save set's current volume.
Answer: C
Question 17.
Which two of the following statements are TRUE? (Choose two.)
A. Net Worker will wait for another appropriate volume when a file type device becomes full.
B. Net Worker will re-label the volume when a file type device becomes full.
C. Net Worker will suspend the save set and attempts to free up space on the volume when a file
type device becomes full.
D. Net Worker will span the save set to another available volume when a file type device
becomes full.
Answer: A, D
Question 18.
Which of the following are stored in the Client File Index (CFI)? (Choose two.)
A. The browse expiration date for the file.
B. The File or Directory attribute information.
C. The save set ID (SSID) containing the file.
D. The file or directory backup time.
Answer: B, D
Question 19.
Which two of the following commands can you use to modify a Jukebox resource? (Choose two.)
A. nsrjb -HEv
B. nsrjb -U 5 -S 1
C. nsrjb -r -d /dev/rmt/0hbn
D. jbedit
E. nsrjb -X
Answer: B, D
Question 20.
You work as a network administrator at ITCertKeys.com. You need to identify the volumes required to support a recovery. How would allow you to accomplish this task? (Choose three.)
A. Use mmlocate to identify the volumes.
B. Use the volumes command with recover.
C. Select the files in nwrecover and view the volumes needed.
D. Use the autodetect option of jbconfig.
E. Use nsrinfo to identify the volumes.
F. Use mminfo to identify the volumes.
Answer: B, C, E
Question 21.
You work as a database administrator at ITCertKeys.com. You want to configure a scheduled backup of an Oracle database on a client computer.
Which of the following Backup Command attributes in the client configuration can you use to accomplish this task?
A. save -n ora
B. nsrndmpsave
C. RMAN script name
D. nsrnmo script name
E. ebu
Answer: D
Question 22.
You work as a network administrator at ITCertKeys.com. ITCertKeys.com has a Net Worker data zone that contains a library connected to a Microsoft Windows 2000 Net Worker server. A native component on the Microsoft Windows machine is responsible for controlling the auto changer, tape drives, and cleaning.
Which library type does ITCertKeys.com have?
A. Removable Storage library (RSM)
B. dynamically shared library
C. shared auto changer
D. silo library
E. NDMP library
Answer: B
Question 23.
Which of the following Net Worker databases tracks information for each file in a save set?
A. media database
B. save group completion report
C. The /nsr/index/* files on the Net Worker client that created the save set
D. Client File Index (CFI)
E. resource database
Answer: D
Question 24.
You work as a network administrator at ITCertKeys.com. You have added a Windows 2000 computer with three partitions to a Net Worker server's daily backup schedule. The computer's Save Set Client attribute is set to all.
How many save sets will be created each time this computer is backed up?
A. 6
B. 4
C. 3
D. 2
E. 1
Answer: A
Question 25.
You work as a network administrator at ITCertKeys.com. You need to check if users are making changes to the Net Worker resource database.
How can you accomplish this goal?
A. Regularly check the Net Worker Administrator GUI and copy any changes made to a text file
for further investigation.
B. Access the Event Viewer Application log and search for any Net Worker informational or
warning events.
C. Edit the Administrators Group resource and remove the Configure Net Worker privilege from
the other administrators.
D. Enable Monitor RAP on the Server resource and regularly monitor the RAP.log file.
Answer: D
|
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.