Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-497

Free Oracle 1Z0-497 Exam Braindumps (page: 11)

Page 6 of 31
PDF with 150 Questions

Your database instance is down because there was a user-initiated shutdown.
Which option represents the actions performed, in the correct order, if you start up the instance? a - The control file is read.
b - Memory is allocated.
c - Background processes pre started.

d -The initialization parameter file is read,
e- Redo log files and data files are opened.

  1. b, c, a
  2. d, a, e
  3. a, e, d, b
  4. d, b, c, a, e
  5. c, b, d, a, e

Answer(s): D

Explanation:

https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM1005



Which three components are always part of System Global Area?

  1. Database Buffer Cache
  2. Undo Log Buffer
  3. Shared Pool
  4. Small Pool
  5. Java Pool
  6. Private SQL Area

Answer(s): A,C,E


Reference:

http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT802



Which two statements about Database Express are true?

  1. It uses internal infrastructure components, such as XDB and SQL*Net.
  2. It can perform actions outside the database.
  3. It has background tasks and processes that periodically collect information via FTP.
  4. It has two new features: Performance Hub and Composite Active Reports.
  5. It is not supported on Standard Edition (SE) and Express Edition (XE).

Answer(s): A,D


Reference:

http://www.oracle.com/technetwork/database/manageability/emx-intro-1970113.html



Which three operations can the PUBLIC user with the SYSOPER privilege perform?

  1. STARTUP
  2. SHUTDOWN
  3. CREATE DATABASE
  4. DROP DATABASE
  5. ALTER DATABASE RECOVER

Answer(s): A,B,E


Reference:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba006.htm#ADMIN11049



To revoke unnecessary and unused privileges, you can use Privilege Analysis.
Which sequence should you follow?
1 -Start the analysis.
2 - Set up the analysis policy type (database, role, context).
3 - Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.
5 - Stop the analysis.

  1. 1, 2, 3, 4, 5
  2. 2, 1, 5, 3, 4
  3. 5, 1, 2, 3, 4
  4. 2, 3, I, 5, 4
  5. 1, 2, 4, 5, 2

Answer(s): B

Explanation:

https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM1005



Viewing page 11 of 31
Viewing questions 51 - 55 out of 150 questions



Post your Comments and Discuss Oracle 1Z0-497 exam prep with other Community members:

1Z0-497 Exam Discussions & Posts