Exam (elaborations)
D330 WGU DATA SYSTEMS ADMINISTRATION - (ALL QUESTIONS FROM CHAPTER 8-10, 12-15, AND 17)
- Course
- Institution
D330 WGU DATA SYSTEMS ADMINISTRATION - (ALL QUESTIONS FROM CHAPTER 8-10, 12-15, AND 17)
[Show more]
Content preview
D330 WGU DATA SYSTEMS ADMINISTRATION - (ALLQUESTIONS FROM CHAPTER 8-10, 12-15, AND 17)
Which parameter can an administrator enable without restarting a database?
A. Compatible
B. Db_domain
C. Sga_target
D. Undo_management - answers- c. Sga_target
Which view displays database parameters and values modified using the scope=spfile
clause?
A. V$spparameter
B. V$nls_parameter
C. V$hs_parameter
D. V$parameter - answers- a. V$spparameter
Where is the listener.ora file located by default?
A. $oracle_home/rdbms
B. $oracle_home/network/admin
C. $oracle_home/database/admin
D. $oracle_home/dbs/admin - answers- b. $oracle_home/network/admin
Which type of connection uses the oracle listener to communicate?
A. Client with database server
B. Browser with application server
C. Two application servers
D. Client with backup tool - answers- a. Client with database server
What does the server=dedicated element in a tnsnames.ora file associate with each
client connection?
A. A committed server process
B. A shared server process
C. A pooled server process
D. A dispatched server process - answers- a. A committed server process
Which net service naming method requires the client to use a fixed port number?
A. Local
B. External
,C. Host
D. Directory - answers- c. Host
A database link named wgu2021 has been created to link to a remote object in the test
database. The object is named employee and is owned by scott.
Which reference resolves to the remote object?
A. Scott.employee@wgu2021
B. Scott.employee
C. Employee
D. Scott.employee@test - answers- a. Scott.employee@wgu2021
Which information from a remote database is included in the configuration of a database
link?
A. User name
B. Data files
C. Tables
D. Views - answers- a. User name
Which command performs a clean shutdown without waiting for clients to disconnect?
A. Shutdown abort
B. Shutdown normal
C. Shutdown transactional
D. Shutdown immediate - answers- d. Shutdown immediate
Which area is a member of the system global area (sga)?
A. Java pool
B. Log writer
C. Database writer
D. Process monitor - answers- a. Java pool
Which types of events are recorded in an alert log?
A. Package creation
B. User creation
C. Role creation
D. Tablespace creation - answers- d. Tablespace creation
Which initialization parameter sets the location of the alert log?
A. Audit_file_dest
B. Log_archive_dest
,C. Diagnostic_dest
D. Core_dump_dest - answers- c. Diagnostic_dest
Which object can be added to an existing bigfile tablespace?
A. Datafiletemp table
B. Table data
C. Tablespacedictionary table
D. Undo data - answers- b. Table data
What is the purpose of the undo tablespace?
A. To manage space for sort operations
B. To facilitate the rollback of transactions
C. To allocate space for sql cursors
D. To maintain the automatic workload repository - answers- b. To facilitate the rollback
of transactions
Which dictionary view is available in the database to view segment advisor results?
A. Dba_advisor_tasks
B. Dba_advisor_templates
C. Dba_advisor_objects
D. Dba_advisor_usage - answers- c. Dba_advisor_objects
A database administrator needs to recover unused space from a tablespace while
preventing data loss.
What should the administrator use?
A. The shrink option
B. The drop command
C. The flashback command
D. The offline clause - answers- a. The shrink option
Which package should an administrator use to configure local extent management for
tablespaces?
A. Dbms_space_admin
B. Dbms_audit_mgmt
C. Dbms_transform
D. Dbms_metadata - answers- a. Dbms_space_admin
What should an administrator use to identify tables that are fragmented?
A. Segment advisor
, B. Automatic database diagnostic monitor
C. Dbms_space
D. Dbms_repair - answers- a. Segment advisor
Which parameter determines how long information should be kept before it is
overwritten in an undo tablespace?
A. Undo_retention
B. Dba_flashback_retention_target
C. Sort_area_retained_size
D. Undo_management - answers- a. Undo_retention
How is undo tablespace storage allocated?
A. Segments are assigned dynamically each time a change is made.
B. Segments are static and are configured by the database administrator.
C. Each transaction specifies how many segments are required for the transaction.
D. Each transaction uses segments that are released from prior transactions. -
answers- a. Segments are assigned dynamically each time a change is made.
Given the following transactions and sessions named session1 and session2:
At 8:00, session1 issues the statement: update policy set lob= '16' where status='bound'
and lob_cat='cancel';
At 8:05, session1 commits the update transaction.
At 8:05, session2 issues the statement: update policy set lob= '16' where
status='submitted' and lob_cat='cancel';
At 8:15, session1 issues the statement: update policy set lob= '81' where status='bound'
and lob_cat='cancel';
At 8:30, session2 issues the statement: update policy set lob= '16' where status='bound'
and lob_cat='cancel';
What happens after session2 issues the statement at 8:30?
A. A deadlock occurs, and the database cancels session2.
B. The database is updated by the second transaction from session2.
C. A deadlock occurs, and the database cancels session1.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GEEKA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79223 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now