A. True
B. False
Answer: A
2.When the R13 update task aborts with an Oracle error ORA1653 - failure to allocate an extent for a
table in a specific tablespace - what action needs to be taken?
A. The tablespace should be reorganized.
B. The tablespace size should be increased by adding a new data file.
C. The table should be reorganized.
D. The storage parameter MAXEXTENTS must be increased.
E. After the cause of the error has been removed, the R13 update task must be reactivated.
Answer: B, E
3.Name the standard Database users created n Oracle. Note! More than one answer is correct. Please
click on the buttons next to the correct answers
A. SIDADM
B. ORASID
C. SYS
D. SAP
E. SYSTEM
Answer: C, E
4.Which files must be restored from tape to allow a full database restore and recovery?
A. Database control file, tablespace data files, and the database alert log.
B. Tablespace data files, database control file, and all archived database transaction logs created
since the last full backup.
C. $ORACLE_HOME, Oracle parameter file, tablespace data files.
D. Database control file, tablespace data files, R13 Syslog, R13 Transport directory.
E. Oracle parameter file, tablespace data files, and the Oracle control file.
Answer: B
5.Which of the following parameters influences the behavior of the Oracle cost based optimizer
A. TUNE_OPTIMIZER
B. OPTIMIZER MODE
C. CBO_ULTRA_WARP
D. DB_FILE_MULTIBLOCK_READ_COUNT
E. dba/ora/use_hint
Answer: B, D, E
6.The SAP installation creates just one additional role called____________.
A. SAPDBA
Answer: A
7.What is the purpose of the Oracle ° OPS$connec¡± f unct i o
A. OPS$connect authorization allows an operating system user to connect to the database without
being prompted for a password.
B. OPS$connect is an Oracle command enabling whoever executes it to administer the database
without using sqldba.
C. OPS$connect is used n Oracle Parallel Server installations to enable remote database connections
over a LAN.
D. OPS$connect authorization is required of all database users and is required for connection to the
database.
E. OPS$connect enables the R13 System saposcol process to communicate and exchange data with
the database.
Answer: A
8.The Oracle tool to test the connection to the database with SID C11 ON HOST twdfO5O5 is Click on
the button next to the right answer.
A. TNSLISTENER
B. lsnrctl start
C. tnspingC11
D. CONNECT
E. BRCONNECT
Answer: C
9.An Instance error occurs when I or more Oracle background processes become corrupted. What
actions should the database administrator take to correct the problem?
A. This is a serious error. Call the Oracle hotline.
B. Shutdown the operating system and reinstall the Oracle software.
C. Shutdown abort and startup open. The SMON process will use the current redo log files and
checkpoint information from the control files to execute an automatic instance recovery upon
database startup.
D. Shutdown the operating system and turn all hardware off. After the hardware cools off start
everything up again and execute Orainst using the repair option.
E. Restore all missing files, apply the offline redo logs, update the control files, and execute the
startup open command.
Answer: C
10.Which of the following user types can be used for dialog free communication within the system?
A. Dialog
B. System
C. Service
D. Communication
E. Reference
Answer: B, D
11.Which of the following is true for the SQL statement highlighted on the ° Shar ed SQ¡± scr ee
Please choose the correct answer.
A. The statement is an expensive statement, because t is on top of the list.
B. The statement is an expensive statement, because it shows more than one million buffer gets.
C. The statement is an expensive statement, because the buffer gets in this statement exceed 5% of
the total buffer gets (reads) in this system.
D. The statement isan expensive statement, because the buffer gets n this statement exceed 5% of
the physical reads (disk reads) in this system.
E. The statement is not an expensive statement.
Answer: C
12.Mention two (2) OS users created each in UNIX and windows platform during the installation of SAP
on Oracle.
A. Windows: adm and SAPService UNIX: ora and adm
Answer: A
13.Based on SAP configuration guidelines for data security and performance, which of the following
statements is correct regarding the configuration revealed by this screen?
Please choose the correct answer.
A. This configuration meets SAP data security standards. The distribution of system components is
reasonable in terms of performance.
B. A significant performance improvement could be achieved by installing origlogA and mirrlogB on
the same disk, and origlogB and mirrlogA together on another disk.
C. The installation of the °sapr eor ¡± di r ectory on t he s ame di sk as mi rr l ogA and mi rr l ogB r epr esen
a potential data security problem.
D. OriglogA and origlogB may increase in size exponentially, and should not be installed on the same
disk as the $ORACLE_HOME directory.
E. Installing the components sapdatal to sapdata6 on disks of 4 GB is a waste of hardware because
these components never increase in size.
Answer: A
14.The SYSDBA and SYSOPER system privilege allow access to a database instance when the
database is
not open.
A. True
B. False
Answer: A
15.Which statement is true of online Oracle database backups?
A. Users may only read data and may not enter data until after the backup is done.
B. Database transaction logs (online redo logs) are not written during online backups.
C. The tablespace data files and control file comprise the complete online backup and are all that is
necessary for restoring the database to a consistent status.
D. The database must be running in archivelog mode.
E. Online database backups are not supported by Oracle.
Answer: D
No comments:
Post a Comment