CSC454 Oracle11g HW

Name: CSC454 Oracle11g HW
Brand: DePaul University
Price: 2 USD
Availability: InStock
Author: Lucy Gray

Homework focusing on database management with Oracle11g.

Lucy Gray

Contributor

4.5

about 1 month ago

Preview (3 of 7)

1
CSC454 Oracle11g HW Name:_______________________
30 points
1. Lisa granted the CREATE TABLE privilege WITH ADMIN OPTION to Sharon. Sharon granted the
privilege to Bob. If Lisa’s privileges are revoked, who else will lose their privileges?
A. Only Bob
B. Only Sharon
C. Both Bob and Sharon
D. No one else will lose their privileges
Answer:-C. both bob and sharon
2. Which of the following is not a SQL*Loader file?
A. Bad file
B. Control file
C. Discard file
D. Good file
E. Log file
Answer:-D. Good file
3. Which SQL*Loader load keyword deletes data in table before loading?
A. APPEND
B. DELETE
C. SUBSTITUTE
D. REPLACE
Answer:- D. Replace
4. You need to insert a large amount of data through the HR_EMP_HIST table. You are concerned about
the amount of time the data load may take. Although you will only be using one processor to load the data,
you would like to make the load as quick as possible. You are NOT concerned about the available storage
space or data integrity. Which SQL*Loader data loading method should you use?
A. Parallel conventional
B. Parallel direct
C. Serial conventional
D. Serial direct
Answer:- C. serial conventional
5. Which of the following commands is a key step in multiplexing control files using an SPFILE?
A. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,
‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=MEMORY
B. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,
‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=BOTH
C. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,
‘D:/oracle/oradata/INST1/control02.ctl’
D. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,
‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=SPFILE
Answer:- B. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,
‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=BOTH
6. If you have two redo log groups with four members each, what’s the optimal number of disks you need to provide
appropriate protection on the redo log files?
A. Eight
B. Four
C. Two
D. One
E. Operating system dependent
Answer:-
E. Operating system dependent
7. When is the redo log buffer written to the redo log file?
A. A transaction changes data.
B. The redo log buffer becomes one-third full.
C. A redo log group is archived.
D. The database starts up.
Answer:- A. A transaction changes data.

2
8. You have two redo log groups. Each group has three members that are 150 MB in size. The members
reside on the E, F, and G drives. You issue this command:
ALTER DATABASE ADD LOGFILE MEMBER ‘G:\app\oradata\INST1\redo04.log’ SIZE 200M TO GROUP 1;
The statement will fail because:
A. All redo log groups must have the same number of members.
B. The size cannot be specified in this command.
C. You cannot add a member to a redo log group.
D. The size is incorrect.
Answer:- D. The size is incorrect.
9. What is the correct method for moving a control file (assume you use PFILE)?
A. Issue the ALTER DATABASE RENAME FILE command.
B. Shut down the database; move the control file; modify the CONTROL_FILES parameter in PFILE; and
start up the database using PFILE.
C. Copy the control file to a new location; shut down the database; modify the CONTROL_FILES
parameter; and start up the database.
D. Shut down the database; delete the control file; start up the database in NOMOUNT mode; issue the
CREATE CONTROL FILE command; and start up the database.
Answer:- B. Shut down the database; move the control file; modify the CONTROL_FILES parameter in
PFILE; and start up the database using PFILE.
10. Which statement will add a member C:\app\oradata\INST1\redo2A.log to log file group 2?
A. ALTER DATABASE ADD LOGFILE ‘C:\app\oradata\INST1\redo2A.log’ TO GROUP 2;
B. ALTER DATABASE ADD LOGFILE MEMBER ‘C:\app\oradata\INST1\redo2A.log’ TO GROUP 2;
C. ALTER DATABASE ADD MEMBER ‘C:\app\oradata\INST1\redo2A.log’ TO GROUP 2;
D. ALTER DATABASE ADD LOGFILE ‘C:\app\oradata\INST1\redo2A.log’;
Answer:- D. ALTER DATABASE ADD LOGFILE ‘C:\app\oradata\INST1\redo2A.log’;
11. Which statement is false about block size?
A. It can be set at the tablespace level
B. It can be set at the database level
C. Settings at the database level take precedence over settings at the tablespace level
D. Settings at the tablespace level take precedence over settings at the database level
Answer:- D. Settings at the tablespace level take precedence over settings at the database level
12. You are using Data Pump to upload rows into a table, and you wish to use the direct path. Which of the
following statements is correct?
A. You must include the “DIRECT” keyword in the Data Pump control file.
B. You must enable insert triggers on the table first.
C. You have no control over this; Data Pump will use the direct path automatically if it can.
D. Direct path is not available in Data Pump.
Answer :- A. You must include the “DIRECT” keyword in the Data Pump control file.
B. You must enable insert triggers on the table first.
C. You have no control over this; Data Pump will use the direct path automatically if it can.
Or you can choose any one of the three statements.
13. Which of the following is not a Data Pump file type?
A. Dump file
B. Log file
C. Control file
D. SQL file
Answer:-C. control file
14. You have decided to implement automatic undo management. Which of these steps is optional?
A. Set the parameter UNDO_MANAGEMENT.
B. Create an undo tablespace.
C. Set the parameter UNDO_RETENTION.
D. Restart the instance
Answer:- B. Create an undo tablespace
15. You want to add a control file copy. Which of these sequences is correct and sufficient?

Preview Mode

100%

Study Now!

XY-Copilot AI

Unlimited Access

Secure Payment

Instant Access

24/7 Support

Document Chat

Document Details

University

DePaul University

Subject

Information Technology

CSC454 Oracle11g HW

Study Now!

Document Details

Related Documents

Practice Questions

Lab Create a Home Wireless Network

Network Configuration and Troubleshooting Practice

Post Test AntiTerrorism

Master Machine Learning Concepts

761541663-Wordly-Wise-Book-8-Answer-Key

Level 1 Anti-terrorism Awareness Training

Understanding Machine Instructions Elements, Types

MGBA-325QRWorkforceAssociation

DAT 375 Module 3-1 Assignment

Company

Explore

Study Tools