Salel Al Sawarim

65 Questions | Total Attempts: 154

SettingsSettingsSettings
Please wait...
Salel Al Sawarim

.


Questions and Answers
  • 1. 
    Which two statements is true regarding the usage of tools in administering an Oracle database?
    • A. 

      Oracle Net Manager: configure a new or existing listener

    • B. 

      Data Pump: transfer of data from one database to another

    • C. 

      SQL*Loader: load data horn an Oracle database to an external file

    • D. 

      Database Upgrade Assistant: upgrade only single-instance databases

    • E. 

      Database configuration Assistant (DBCA): create new database user in an existing database

  • 2. 
    The DBA of your database informs you that the Oracle instance has started. What does this imply?
    • A. 

      Users can access the data in the database.

    • B. 

      Only the SGA has been allocated for the database.

    • C. 

      Only the background and user processes are running.

    • D. 

      Memory areas have been allocated and background processes have been started.

  • 3. 
    You issue the following command as a DBA:SQL>SHUTDOWNWhat would be the outcome of the above command?
    • A. 

      It causes the instance to abort.

    • B. 

      It waits for all sessions to disconnect.

    • C. 

      It rolls back the current transactions and disconnects a/I sessions.

    • D. 

      It waits for the current transaction in each session to complete before disconnecting the sessions.

  • 4. 
    View the exhibit.Which actions would be performed and in what sequence by clicking the Startup button?1) Control file is read.2) Memory is allocated.3) Background processes are started.4) Initialization parameter file is read.5) Redo log files and data files are opened.
    • A. 

      2, 3, 1

    • B. 

      4, 1, 5

    • C. 

      1, 5, 4, 2

    • D. 

      4, 2, 3, 1, 5

    • E. 

      3, 2, 4, 1,5

  • 5. 
    Which two statements are true regarding consistent backups? (Choose two)
    • A. 

      Database can be opened immediately after the restore operation.

    • B. 

      Database can be opened only after the restore and recovery operations.

    • C. 

      Consistent backups can be taken only when the instance is running and the database is closed.

    • D. 

      Consistent backups can be taken only when the instance is shut clown and the database is closed.

    • E. 

      Consistent backup are taken before the changes in the online redo log files haw been applied to the data files.

  • 6. 
    You are a performance-sensitive DBA, and you are nervous about gathering new statistics,since they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best course of action would be to:
    • A. 

      Refrains from collecting statistics

    • B. 

      Use Real Application Testing to capture the workload and the worked and then run the

    • C. 

      Use hints to create fixed plans for SQL statements

    • D. 

      Use deferred publishing of statistics to allow you to test execution plans before making the statistics public

    • E. 

      Use invisible indexes to dominate execution plans

  • 7. 
    Evaluate the following command:$sqlplus / nologIn which scenario would the above command execute successfully?
    • A. 

      Only from the server if the database instance is not up.

    • B. 

      Either from the server or client even if the database instance is not up.

    • C. 

      Either from a client or server only if the database instance is up and the command connects the session to the instance.

    • D. 

      Either from a client or server only if the database instance is up but the command does not connect the session to the instance.

  • 8. 
    Which statement is true regarding the management of tablespaces?
    • A. 

      AUTOEXTEND can be enabled only for new data files.

    • B. 

      Dictionary-managed tablespaces can be converted to locally managed tablespaces.

    • C. 

      Space usage alert thresholds can be modified only if the tablespace contains no data.

    • D. 

      Locally managed temporary tablespaces can be converted to permanent tablespaces.

  • 9. 
    You want to change your database by adding some new columns to a particular tale. These new columnsrepresent new data that is not accessed by the current application. Which approach would be the simplest inmaking these changes?
    • A. 

      Use edition-based redefinition to create a new version of the table.

    • B. 

      Add the columns to the table, since dependent objects will not be affected.

    • C. 

      Encompass all access to these columns in separate PL/SQL procedures to avoid dependency issues.

    • D. 

      Add the columns to a different table and create a view to access the joined result.

  • 10. 
    View the exhibit.You plan to load the customer information that has been brought from a non Oracle database in theCUSTOMERS table in your database using the "Enterprise Manager –Load Data From User File" option.Which files should you create before using this option?
    • A. 

      Only data file

    • B. 

      Data file and log file

    • C. 

      Data file and dump file

    • D. 

      Data file and control file

  • 11. 
    There are two listeners, LISTENER1 and LISTENER2, an done service name ORCL available for yourdatabase. The database is running and currently only LISTENERI has been started. You issue the followingcommand:$Isnrctl start listener2What would be the outcome?
    • A. 

      It would start the second listener without affecting the current sessions.

    • B. 

      It would start the second listener and terminate all the current sessions.

    • C. 

      It would give an error because multiple listeners cannot run simultaneously.

    • D. 

      It would give an error because multiple listeners can run simultaneously only if there are multiple net service names.

  • 12. 
    Which two statements are true regarding SQL*Plus? (Choose two.)
    • A. 

      It has commands to perform database administration operations.

    • B. 

      It can be used in interactive hut not batch mode for SQL commands.

    • C. 

      It has to be installed separately after the Oracle database install installation.

    • D. 

      Operating system commands can be executed from the SOL*Plus command prompt.

  • 13. 
    Which two statements are true regarding undo data records? (Choose two.)
    • A. 

      They are required to support Flashback features.

    • B. 

      They are not required if Flashback features are enabled.

    • C. 

      They are retained until the session making the changes ends.

    • D. 

      Undo records contain copies of data as It appears after a change is made.

    • E. 

      Undo records contain copies of data as it appears before a change is made.

  • 14. 
    In your database, the SQL Tuning Advisors running automatically during the system maintenance windowas a maintenance task. Which of its recommendations would be implemented automatically?
    • A. 

      Creation of new indexes

    • B. 

      Refreshing optimizer statistic

    • C. 

      Refreshing optimizer statistic

    • D. 

      Creation or modification of a SQL Profile

  • 15. 
    Which two statements we true regarding the index creation recommendations given by SQL TuningAdvisor and SQL Access Advisor?(Choose two.)
    • A. 

      SQL Tuning Advisor considers the impact of the indexes only queries.

    • B. 

      SQL Tuning Advisor considers the impact of the indexes on both queries and DML operations.

    • C. 

      SQL Tuning Advisor considers the impact of the new indexes on both queries and DML operations.

    • D. 

      SQL Tuning Advisor considers the impact of the indexes on only data manipulation language (DML) operations.

  • 16. 
    Which three statements about the Automatic Database Diagnostic Monitor (ADDM) are true?(Choose three).
    • A. 

      Requires the database to be open

    • B. 

      Analyses the performance of specified objects

    • C. 

      Implements all recommendations automatically

    • D. 

      Recommends solutions and quantifies expected benefits

    • E. 

      Retains snapshots in the SYSAUX tablespace until the database is restarted

    • F. 

      Analyzes the snapshots stored in the Automatic Workload Repository (AWR)

  • 17. 
    Which three statements is true regarding an Oracle instance? (Choose three)
    • A. 

      One instance is associated with only one database.

    • B. 

      Multiple database instances can run on one computer.

    • C. 

      Only one database instance can run on one computer

    • D. 

      One instance can be associated with multiple databases.

    • E. 

      A database instance is created based on the information in the control file.

    • F. 

      A database instance is created based on the information in the SPFILE file.

  • 18. 
    You have some operating system scripts on one server that need to run in response to certain changes indata in your Oracle Database. The most efficient way to implement this with Oracle Database 11g wouldbe:
    • A. 

      Write a PL/SQL routine that connects to the remote server and calls the script.

    • B. 

      Create a script on the database server to perform the remote action and that script from database trigger.

    • C. 

      Modify the script on the remote server to periodically chock for these data change in your Oracle database.

    • D. 

      Install an Oracle Scheduler Agent on the remote server and create job to be called from Oracle scheduler in response to a database server event.

  • 19. 
    Which mode of database shutdown requires an instance recovery at the time of the database startup?
    • A. 

      ABORT

    • B. 

      NORMAL

    • C. 

      IMMEDIATE

    • D. 

      TRANSACTIONAL

  • 20. 
    You want to Increase the number of SQL statements that are cached in memory. Which memory structuresize should be increased?
    • A. 

      Large pool

    • B. 

      Shared pool

    • C. 

      Buffer Cache

    • D. 

      Program Global Area

  • 21. 
    User HR has made some modifications to the data in the HR.EMPLOYEES table. You need to now restorethe data in the table to a previous version and use the Enterprise Manager. From which source dose theoperation flash back the table data to the specified time?
    • A. 

      Redo logs

    • B. 

      Undo tablespace

    • C. 

      Flash recovery area

    • D. 

      Temporary tablespace

  • 22. 
    Which two statements are true regarding point-in-time recovery? (Choose two.)
    • A. 

      It requires the SPFILE

    • B. 

      It requires the control file.

    • C. 

      It uses only online redo logs.

    • D. 

      It uses both archivelog and online redo logs.

  • 23. 
    Which two statements are true regarding the database control file? (Choose two.)
    • A. 

      Control files must be multiplexed on different disks.

    • B. 

      It is used to create the instance when the database is started.

    • C. 

      The locations of control files are stored in the initialization parameter files.

    • D. 

      It stores the current names and locations of the data files and redo log files.

  • 24. 
    Examine the structure of the PRODUCTS table.The PRODUCTS table contains 20 rows.In the data that has been entered, the PROD_ID column contains only single digit values,PROD_NAMK has a maximum of 5 characters, and RATE has 4 digit values for all rows.Which two statements are true regarding the modifications that can be performed to thestructure of the PRODUCTS table? (Choose two.)
    • A. 

      PROD_NAME size can be reduced from 10 to 5 characters.

    • B. 

      PROD_IP can be changed from CHAR to NUMBER data type.

    • C. 

      Now columns can be added only if they have NOT NULL constraint.

    • D. 

      PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2).

    • E. 

      None of the existing columns can be dropped because they contain data.

  • 25. 
    Which two statements are true regarding the structure of the redo logs? (Choose two.)
    • A. 

      Each group must have a minimum of two members

    • B. 

      Each group must have the same number of members.

    • C. 

      The redo log groups in a database are written to in a cyclic fashion.

    • D. 

      A minimum of two redo log groups is required for a database to open.

    • E. 

      The members within a redo log group are written to in a cyclic fashion.