Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 31:

  What happens if you execute these SQL statements? SQL> show con_name CON_NAME CDB$ROOT SQL> create user 1_freed identified by y container=current;

  A. A common user is created in the root container.
  B. A local user is created in the root container.
  C. A local user is created in all the PDBs.
  D. The second SQL statement fails because a local user cannot be created in the root container.
  B. A local user is created in the root container.

• Question 32:

  Which two statements about Automatic Data Optimization (ADO) are true?

  A. ADO policies can automatically compress data when it qualifies.
  B. ADO policies can automatically move segments when necessary.
  C. ADO is not dependent on Heat Map, and works even if Heat Map is disabled.
  D. You cannot compress at block level, but you can compress at segment level.
  E. You can compress at row level only for QUERY LOW.
  D. You cannot compress at block level, but you can compress at segment level.
  E. You can compress at row level only for QUERY LOW.

• Question 33:

  Your database is down. You log in as the SYS user and issue this command: SQL> STARTUP

  What happens after the instance is started?

  A. Nothing else happens.
  B. The database is mounted but not opened.
  C. The database is mounted and finally opened.
  D. The database is opened and finally mounted.
  C. The database is mounted and finally opened.

  ---

  Reference: http://docs.oracle.com/cd/E17781_01/server.112/e18804/startup.htm

• Question 34:

  Which three events signal a database writer (DWR) to write buffers to disk?

  A. The database advances a checkpoint.
  B. A client process commits a transaction.
  C. The redo log buffer becomes full.
  D. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
  E. A tablespace is changed to read-only status.
  F. The database is shut down in immediate mode.
  A. The database advances a checkpoint.
  D. A server process cannot find non-dirty blocks after scanning a threshold number of buffers.
  E. A tablespace is changed to read-only status.

  ---

  AE: When tablespace is changed to read only status it will issue a Partial checkpoint. During db shutdown a checkpoint is also issued. DWR writes when there is a checkpoint.

• Question 35:

  Which database feature can be used for organizing data when there is a very large amount of data?

  A. Index
  B. Partitioning
  C. Triggers
  D. Row-level security
  E. Database vault
  B. Partitioning

  ---

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT999 (see very large databases)

• Question 36:

  Real-Time ADDM detects a high-load performance issue within the database. Which condition triggered it?

  A. The average active sessions were more than three times the number of CPU cores.
  B. Active sessions were more than 10% of total load and CPU utilization was more than 50%.
  C. Memory allocations were more than 95% of physical memory.
  D. Hung sessions were more than 10% of total sessions.
  E. A deadlock was detected.
  F. The session limit was close to 100%.
  A. The average active sessions were more than three times the number of CPU cores.

  ---

  Reference: http://docs.oracle.com/cd/E16655_01/server.121/e15857/pfgrf_diag.htm#TGDBA95369 (table 7-1)

• Question 37:

  Which type of file system is NOT valid for storing data files, online redo log files, and control files for a pluggable database?

  A. Automatic Storage Management (ASM)
  B. OS file system
  C. logical volume (LVM)
  D. clustered file system
  E. RAW
  E. RAW

• Question 38:

  

  Which two statements are true about this common user?

  A. SQL> conn c##usr/pwd@pdb1 You are connected to PDB1 successfully.
  B. SQL> conn c##usr/pwd@pdb2 You are connected to PDB2 successfully.
  C. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You first need to sync PDB2 by executing: SQL> conn / as sysdba SQL>exec DBMS_PDB.SYNC_PDB;
  D. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing: SQL>conn system/pwd@pdb2 SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT; Now you are able to connect as common user c##usr to PDB2.
  A. SQL> conn c##usr/pwd@pdb1 You are connected to PDB1 successfully.
  D. SQL> conn c##usr/pwd@pdb2 You are unable to create a connection. You need to create the common user c# #usr explicitly in PDB2 by executing: SQL>conn system/pwd@pdb2 SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT; Now you are able to connect as common user c##usr to PDB2.

• Question 39:

  As part of your Oracle Database 12c post-installation tasks, you run these commands:

  Cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb

  What does this do?

  A. It enables the Oracle Data Mining option in your Oracle binary files.
  B. It creates the Fast Recovery Area disk group.
  C. It generates Client Static Library.
  D. It configures one of the Oracle user accounts.
  E. It configures Oracle Net Services.
  F. It configures Oracle Messaging Gateway.
  A. It enables the Oracle Data Mining option in your Oracle binary files.

  ---

  Reference: http://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see 4.4)

• Question 40:

  Which two statements are true about the B-tree Index?

  A. The leaf blocks in the index are doubly linked.
  B. The leaf node stores a bitmap for each key value.
  C. Rows with a NULL value in key columns also have entries in the Index.
  D. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.
  B. The leaf node stores a bitmap for each key value.
  D. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

  ---

  Reference: http://www.siue.edu/~dbock/cmis565/module12-indexes.htm