Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 41:

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

  A. STARTUP
  B. SHUTDOWN
  C. CREATE DATABASE
  D. DROP DATABASE
  E. ALTER DATABASE RECOVER
  A. STARTUP
  B. SHUTDOWN
  E. ALTER DATABASE RECOVER

  ---

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

• Question 42:

  There are two listeners, LISTENER1 arid LISTENER2, and one service name ORCL available for your database. The database is running and currently, only LISIENER1 is started. You issue the command:

  lsnrctl start listener2

  What would be the outcome?

  A. It starts the second listener without affecting current sessions.
  B. It starts the second listener and terminates all current sessions.
  C. It gives an error because multiple listeners cannot run simultaneously.
  D. It gives an error because multiple listeners can run simultaneously only if there are multiple net service names.
  A. It starts the second listener without affecting current sessions.

  ---

  Reference: https://blogs.oracle.com/rtsai/entry/how_to_configure_multiple_oracle

• Question 43:

  You have two database servers EMP and EXP. A user of the database from the EXP server wants to extract some information from the database in the EMP server for cross-verification. Which schema object enables the user to access the information from the remote database?

  A. cluster
  B. database link
  C. mapping table
  D. materialized view
  B. database link

  ---

  Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm

• Question 44:

  Which two statements about multi section backup are true?

  A. It is available only for full backups.
  B. It supports incremental backups and image copies.
  C. Backup for each data file is divided into sections and is backed up in parallel. However, for image copies, sections are backed up sequentially.
  D. For image copies, sections are backed up in parallel and recomposed at the end.
  B. It supports incremental backups and image copies.
  D. For image copies, sections are backed up in parallel and recomposed at the end.

  ---

  B (Not A): Starting with Oracle Database 12c Release 1 (12.1), RMAN supports multisection incremental backups

  D (not C): Starting with Oracle Database 12c Release 1 (12.1), you can create multisection full backups that are stored as image copies. While the image copy is being created, multiple channels are used to write files sections. However, the output of this operation is one copy for each data file. Reference: Specifying Multisection Incremental Backups Making Multisection Backups Using Image Copies

• Question 45:

  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.

  A. 1, 2, 3, 4, 5
  B. 2, 1, 5, 3, 4
  C. 5, 1, 2, 3, 4
  D. 2, 3, I, 5, 4
  E. 1, 2, 4, 5, 2
  A. 1, 2, 3, 4, 5

• Question 46:

  Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

  A. the CDB as the ROOT user
  B. the CDB as the CDBADMIN user
  C. the PDB as the ROOT user
  D. the PDB as the PDB Admin user
  A. the CDB as the ROOT user

• Question 47:

  Which two statements are true regarding SQL*Plus?

  A. It has commands for performing database administration operations.
  B. It can be used in interactive but not batch mode for SQL commands.
  C. It has to be installed separately after the Oracle Database 12c installation.
  D. Operating system commands can be executed from the SQL*Plus command prompt.
  A. It has commands for performing database administration operations.
  C. It has to be installed separately after the Oracle Database 12c installation.

  ---

  C: how to start SQL*Plus:

  1- Make sure that SQL*Plus has been installed on your computer.

  2.

  Log on to the operating system (if required).

  3.

  Enter the command, SQLPLUS, and press Return.

  Etc.

  Not B: In SQL*Plus command-line, the use of an external editor in combination with the @, @@ or START commands is an effective method of creating and executing generic scripts. You can write scripts which contain SQL*Plus, SQL and PL/SQL commands, which you can retrieve and edit. This is especially useful for storing complex commands or frequently used reports.

  Reference: http://docs.oracle.com/cd/B14117_01/server.101/b12170/qstart.htm

• Question 48:

  In which situation would you use static database registration for a listener?

  A. when multiple databases are to be registered with the listener
  B. when DBAs need to connect remotely to start up the database instance
  C. when users need to connect the database instance by using the host naming method
  D. when the database instance to be registered with the listener is configured in shared server mode
  C. when users need to connect the database instance by using the host naming method

• Question 49:

  Which two statements about the Process Monitor (PMON) process are true?

  A. PMON performs process recovery when a client process fails.
  B. During instance startup, PMON takes care of instance recovery.
  C. PMON performs listener registration.
  D. PMON restarts background and dispatcher processes when they fail.
  E. PMON resolves failures of distributed transactions.
  A. PMON performs process recovery when a client process fails.
  C. PMON performs listener registration.

• Question 50:

  Which normalization level is adopted in real-world database systems?

  A. 1NF
  B. 2NF
  C. 3NF
  D. BCNF
  A. 1NF