Oracle OCA 1Z0-301

Oracle OCA 1Z0-301

1. Which two protocols are used to communicate directly to an OC4J instance that is deployed as part of
an Oracle9iAS instance? (Choose two.)
A. ORMI
B. HTTPS
C. HTTP
D. AJP12
E. AJP13
Answer: AE

2. An application developer provides you with the LoginServlet.class file and informs you that the servlet
needs to connect to your production database.
As a Web Administrator, you are responsible for configuring the appropriate data source. No data sources
have been configured up to now. Which three are true regarding enabling the servlet to connect to the
database? (Choose three.)
A. You can use the preinstalled data source and customize it appropriately for your needs.
B. To use the preinstalled data source you first need to delete the <data-source> entries.
C. If it is a global data source that applies to all applications, the data source is configured at the
application level for this application.
D. Global data sources are specified in the data-sources.xml file and applications can refer to that.
E. If it is a local data source that applies to only this application, the data source is configured at the
application level for this application.
F. Data sources are defined in the application.xml file and your application can know about those data
sources only if the data-sources.xml file knows about it.
Answer: ADE

3. Documents matching the following regular expression are defined as being cacheable in the
cacheability rules for your Web Cache:/.html?$
Your site has many .htm and .html files that are presented to Web visitors. Which file types will be
cached?
A. The .html files would be cached, but not the.htm files.
B. The .htm files would be cached, but not the .html files.
C. Both the .html files and the .htm files would be cached.
D. Neither the .html files nor the .htm files would be cached.
Answer: C

4. The machine hosting your Oracle9iAS Infrastructure has been stopped and the operating system has
been restarted. Which three steps do you need to take to get Oracle Internet Directory working? (Choose
three.)
A. Start Enterprise Manager daemon.
B. Start the Oracle9iAS metadata repository and the database listener.
C. Start Oracle Management Server in order to get connected to OEM Web site.
D. Navigate to the infrastructure homepage, select Oracle Internet Directory, and then click Start.
E. Navigate to the Farm page, select the Oracle9iAS Infrastructure instance, and click Start All to start
Oracle9iAS metadata repository and the database listener and all OID components.
F. Navigate to the Oracle Internet Directory home page and start the Distributed Administration Service.
Answer: ABD

5. The Web Cache Web site's invalidation messages can be sent to the target Web Cache's invalidation
port through which two methods? (Choose two.)
A. AJP
B. HTTP GET
C. HTTP POST
D. Oracle Net
E. HTTP GET WITH STRING
Answer: BC

Oracle 10gDBA 1Z0-040

Oracle 10gDBA 1Z0-040

1. You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M
TABLESPACE GROUP '';
Which statement regarding the above command is correct?
A.It will create the tablespace TEMP1 in group G1.
B.It will create the tablespace TEMP1 in group G3.
C.It will not add the tablespace TEMP1 to any group.
D.It will create the tablespace TEMP1 in the default group.
E.It will throw an error with message 'specified group is not available'.
F.It will create a new group with a system-generated name and add the tablespace TEMP1 to it.
Answer: C

2. You want to perform the database backup when user activity on your system is low, such as between
12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of the specified
duration?
A.RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE;
B.RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE;
C.RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE;
D.RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE;
Answer: A

3. Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?
(Choose two.)
A.You can find information about only active transactions from the view.
B.You can find information about read only transactions from the view.
C.You require the SELECT ANY TRANSACTION system privilege to access the view.
D.You can find information about both active and committed transactions from the view.
E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the
view.
Answer: CD

4. You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance.
At the end of the day, you execute the following command on the ASM instance to shut down:
SQL> shutdown immediate;
What is the result of executing this command?
A.All the instances, including the ASM instance, are shut down in the ABORT mode.
B.The ASM instance is shut down, but the other instances are still running.
C.The ASM instance is still functional, but the other instances are shut down.
D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is
shut down in the IMMEDIATE mode.
F.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is
shut down in the IMMEDIATE mode.
Answer: D

5. Which two statements regarding the Policy Framework in Enterprise Manager (EM) are correct?
(Choose two.)
A.Policy violations are prioritized as High, Medium, or Informational by category.
B.Policies can be disabled completely, or flagged as ignored, for the specified target.
C.Policies can be flagged as ignored, but never completely disabled, for the specified target.
D.Policy violations must be corrected, otherwise the database will shut down until corrective action
occurs.
Answer: AB

6. You plan to create an external table from the EMPLOYEES, DEPARTMENTS, and LOCATIONS
database tables. Which method or command should you use to create and populate the external table?
A.the expdp and impdp commands
B.conventional export and import
C.CREATE TABLE.. and SQL*Loader
D.CREATE TABLE.. and INSERT INTO.. SELECT.. FROM..
E.CREATE TABLE.. ORGANIZATION EXTERNAL ..AS SELECT.. FROM..
Answer: E

7. You need to ensure that the database users should be able to use the various flashback query features
in order to go back in time by four hours. What would you do to achieve this? (Choose two.)
A.set SQL_TRACE=True
B.set UNDO_RETENTION=14400
C.set FAST_START_MTTR_TARGET=240
D.set LOG_CHECKPOINT_INTERVAL=240
E.set DB_FLASHBACK_RETENTION_TARGET=14400
F.issue ALTER DATABASE FLASHBACK ON; command
G.set the RETENTION GUARANTEE clause for the undo tablespace
Answer: BG

8. You created a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs
DATAFILE 'data.dat' SIZE 1M REUSE
AUTOEXTEND ON MAXSIZE 100M;
The warning and critical tablespace usage threshold values are set to 85% and 97%, respectively. Which
two statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct?
(Choose two.)
A.A critical alert will be generated when 97 MB space is used.
B.A critical alert will be generated when 970 KB space is used.
C.A warning alert will be generated when 85 MB space is used.
D.A warning alert will be generated when 850 KB space is used.
E.A critical alert will be generated when 970 KB is left as free space.
F.A warning alert will be generated when 850 KB is left as free space.
G.No critical alert will be generated because it is a small file tablespace.
H.No warning alert will be generated because the tablespace is autoextensible.
Answer: AC

9. You are checking every 10 minutes for alerts regarding the violation of tablespace usage threshold.
Some of the tablespaces' fullness was not detected on time. As a result the transactions were aborted
before you had a chance to resolve the space issue. What would you do to avoid transaction failures?
A.use bigfile tablespaces (BFTs)
B.enable resumable space allocation
C.modify the background process PMON settings
D.modify the LOG_CHECKPOINT_TIMEOUT parameter
E.reduce the default tablespace usage threshold values for the database
Answer: B

10. You explicitly specified the tablespace usage threshold values while creating a tablespace. You need
to revert to the database-wide default tablespace usage threshold values for the tablespace. Which
PL/SQL package would you use?
A.DBMS_STATS
B.DBMS_ALERT
C.DBMS_SPACE
D.DBMS_MONITOR
E.DBMS_SERVER_ALERT
F.DBMS_SPACE_ADMIN
Answer: E

11. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace
threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the
TEST_TBS tablespace does not include autoextensible data files?
A.TEST_TBS is a small file tablespace.
B.TEST_TBS is a bigfile tablespace (BFT).
C.TEST_TBS is the default temporary tablespace.
D.TEST_TBS is a dictionary-managed tablespace.
E.Threshold values for the TEST_TBS tablespace are not explicitly specified.
Answer: D