StudyXY
RegisterLog in

CSC454 Oracle11g HW

Homework focusing on database management with Oracle11g.

Lucy Gray
Contributor
4.1
39
6 months ago
Preview (3 of 7 Pages)
100%
Purchase to unlock

Page 1

CSC454 Oracle11g HW - Page 1 preview image

Loading page ...

1CSC454Oracle11gHWName:_______________________30 points1.Lisa granted the CREATE TABLE privilege WITH ADMIN OPTION to Sharon. Sharon granted theprivilege to Bob.If Lisa’s privileges are revoked, who else will lose their privileges?A. Only BobB. Only SharonC. Both Bob and SharonD. No one else will lose their privilegesAnswer:-C. both bob and sharon2.Which of the following is not a SQL*Loader file?A. Bad fileB. ControlfileC. Discard fileD. Good fileE. LogfileAnswer:-D. Good file3.Which SQL*Loader load keyword deletes data in table before loading?A. APPENDB. DELETEC. SUBSTITUTED. REPLACEAnswer:-D. Replace4.You need to insert a large amount of data through the HR_EMP_HIST table. You are concerned aboutthe 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 storagespace or data integrity. Which SQL*Loader data loading method should you use?A. Parallel conventionalB. Parallel directC. Serial conventionalD. Serial directAnswer:-C. serial conventional5.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=MEMORYB. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=BOTHC. 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=SPFILEAnswer:-B. ALTER SYSTEM SET CONTROL_FILES= ‘C:/app/product/11.2.0/oradata/INST1/control01.ctl’,‘D:/oracle/oradata/INST1/control02.ctl’, SCOPE=BOTH6.If you have two redo log groups with four members each, what’s the optimal number of disks you need to provideappropriate protection on the redo log files?A. EightB. FourC. TwoD. OneE. Operating system dependentAnswer:-E. Operating system dependent7.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.

Page 2

Page 3

Preview Mode

This document has 7 pages. Sign in to access the full document!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

University
DePaul University
Course
CSC 454
Subject
Information Technology

Related Documents

View all
Class Notes

DevOps and Its Importance Study Notes

DevOps Overview – Covers culture, performance metrics, CI/CD, CALMS model, automation, continuous testing, and frameworks like Agile, SAFe, and SRE. Ideal for modern IT and DevOps foundation learning.

Past Exams

Veeam Certified Engineer VMCE-V12

Veeam Backup Q&A – Covers Scale-out Backup Repositories, Oracle RMAN plug-in, agent-supported OS, and retention policies. Ideal for IT pros preparing for Veeam certification or data protection roles.

Past Exams

Modules 1 - 3 Basic Network Connectivity and Commu

Modules 1–3: ITN v7.0 Exam Answers on Basic Network Connectivity and Communications. Covers OSI model, IP addressing, protocols, and network devices. Ideal for CCNA exam prep.

Class Notes

Notes CCNA

Set boot file and recover from crash on Cisco switches. Use boot system commands, mode button, and boot loader steps to restore functionality after power loss or software issues.

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 20

Configure and secure NTP for accurate time across your network. Learn NTP design, troubleshooting, clock settings, and timestamps with configuration examples to support SLAs and log accuracy.

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 22

Manage traffic using ACLs: Learn to create, apply, and verify standard, extended, named, and IPv6 ACLs. Includes tips, keywords, sequence numbers, and configuration examples.

Class Notes

CCNA 200-301 Portable Command Guide 5th Edition 36

Learn how to subnet IPv4 addresses using binary math, including Class B and C subnetting, binary ANDing, and shortcuts—essential skills for mastering the CCNA 200-301 exam.

Class Notes

Foundations of Novell Networking Section 26

Learn how web servers work and explore installing and configuring the NetWare Enterprise Web Server in NetWare 6, including support for iFolder and iPrint.

Class Presentation

Modulo 7 DHCPv4

Aprende a configurar DHCPv4 para asignar IPs dinámicamente. Ideal para redes grandes o pequeñas, usando servidores dedicados o routers Cisco con IOS como servidor DHCP eficiente.

Class Notes

Build and troubleshooting Integration Challenge

Networking Practice Exam: Configura y soluciona redes con routers y VLANs. Incluye direccionamiento IP detallado, subredes, interfaces y pruebas de conectividad para integración de sistemas.