Salel Al Sawarim

65 Questions | Attempts: 202
Share

SettingsSettingsSettings
Salel Al Sawarim - Quiz

.


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

    Correct Answer(s)
    A. Oracle Net Manager: configure a new or existing listener
    B. Data Pump: transfer of data from one database to another
  • 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.

    Correct Answer
    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.

    Correct Answer
    B. It waits for all sessions to disconnect.
  • 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

    Correct Answer
    D. 4, 2, 3, 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.

    Correct Answer(s)
    A. Database can be opened immediately after the restore operation.
    D. Consistent backups can be taken only when the instance is shut clown and the database is closed.
  • 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

    Correct Answer
    D. Use deferred publishing of statistics to allow you to test execution plans before making the statistics public
  • 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.

    Correct Answer
    B. Either from the server or client even if the database instance is not up.
  • 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.

    Correct Answer
    B. Dictionary-managed tablespaces can be converted to locally managed 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.

    Correct Answer
    A. Use edition-based redefinition to create a new version of the table.
  • 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

    Correct Answer
    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.

    Correct Answer
    A. It would start the second listener without affecting the current sessions.
  • 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.

    Correct Answer(s)
    A. It has commands to perform database administration operations.
    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.

    Correct Answer(s)
    A. They are required to support Flashback features.
    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

    Correct Answer
    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.

    Correct Answer(s)
    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.
  • 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)

    Correct Answer(s)
    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.

    Correct Answer(s)
    A. One instance is associated with only one database.
    B. Multiple database instances can run on one computer.
    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.

    Correct Answer
    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

    Correct Answer
    A. ABORT
  • 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

    Correct Answer
    B. Shared pool
  • 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

    Correct Answer
    C. Flash recovery area
  • 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.

    Correct Answer(s)
    B. It requires the control file.
    C. It uses only 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.

    Correct Answer(s)
    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.

    Correct Answer(s)
    A. PROD_NAME size can be reduced from 10 to 5 characters.
    D. PROD_RATE size can be changed from NUMBER (4) to NUMBER (6, 2).
  • 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.

    Correct Answer(s)
    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.
  • 26. 

    Which three statements are true regarding inconsistent backup? (Choose three)

    • A.

      It can be used only for incomplete recovery.

    • B.

      It can be taken only when the database is open.

    • C.

      It can be taken only when the database is closed.

    • D.

      It can be used for complete and incomplete recovery.

    • E.

      The archived redo logs changes must be applied to the data files before the backup.

    • F.

      Both online and archived redo logs can have changes that have not been applied before the backup.

    Correct Answer(s)
    B. It can be taken only when the database is open.
    D. It can be used for complete and incomplete recovery.
    F. Both online and archived redo logs can have changes that have not been applied before the backup.
  • 27. 

    Customer is looking to upgrade to Oracle Database 11g Release 2 when they bring in a new databaseserver. Which two features of the release can the customer use to ensure that the performance of their newOracle Database is maintained through the upgrade?

    • A.

      Using Database Replay to capture the work load on the existing server, to be used in testing the new server environment

    • B.

      Adding 20% more memory to the new server to handle the increased requirements of Oracle Database 11g Release 2

    • C.

      Reproducing the current client environment on the new server to ensure that the new environment can deliver the same results with the same workload

    • D.

      Using SQL Performance Analyzer to compare the performance of SQL statements in the new and old server Environments.

    • E.

      Running both systems in parallel during production usage

    Correct Answer(s)
    A. Using Database Replay to capture the work load on the existing server, to be used in testing the new server environment
    C. Reproducing the current client environment on the new server to ensure that the new environment can deliver the same results with the same workload
  • 28. 

    Which statement is true regarding accessing the Enterprise Manager Database Control?

    • A.

      It can be accessed through a Web browser or command line.

    • B.

      It can be accessed only it the default preset port number 1158 is available.

    • C.

      It can be accessed irrespective of whether the database instance shut down or running.

    • D.

      It can be accessed only it the Net service names have been configured in the server thsnames.ora file.

    Correct Answer
    C. It can be accessed irrespective of whether the database instance shut down or running.
  • 29. 

    Which three statements are true regarding database recovery operations? (Choose three.)

    • A.

      Complete recovery involves only rolling forward operations

    • B.

      Database recovery is not required after an instance recovery.

    • C.

      Incomplete recovery applies changed only from archived redo logs.

    • D.

      Complete database recovery must be performed after an instance recovery.

    • E.

      Complete recovery involves both rolling forward and rolling backward operations.

    • F.

      Incomplete recovery can apply changes from both online and archived redo logs.

    Correct Answer(s)
    B. Database recovery is not required after an instance recovery.
    E. Complete recovery involves both rolling forward and rolling backward operations.
    F. Incomplete recovery can apply changes from both online and archived redo logs.
  • 30. 

    Which statement describes the function of the Segment Advisor?

    • A.

      It advises on the usage frequency of the database objects

    • B.

      It advises on the currently validity status of the database

    • C.

      It identifies database objects that have unused space that can be reclaimed

    • D.

      It identifies the space requirements for the database objects based on their usage and growth statistics.

    Correct Answer
    C. It identifies database objects that have unused space that can be reclaimed
  • 31. 

    Which three options correctly map SQL commands with their categories?(Choose three)

    • A.

      SELECT: transaction control

    • B.

      DROP: data control language

    • C.

      ROLLBACK: transaction control

    • D.

      REVOKE: Data control language

    • E.

      ALTER: Data manipulation language

    • F.

      MERGE: Data manipulation language

    Correct Answer(s)
    C. ROLLBACK: transaction control
    D. REVOKE: Data control language
    F. MERGE: Data manipulation language
  • 32. 

    You create an index, EMP_IDX, on the ENAME column in the EMP table. Identify the three operations inwhich FMP_IDX would be used? (Choose three.)

    • A.

      Addition of new data to the EMP table

    • B.

      Deletion of existing row from the EMP table

    • C.

      Modification of data in any column in the EMP table

    • D.

      All queries that display data from the ENAME column

    • E.

      Queries that search for data based on a condition on the ENAME column

    Correct Answer(s)
    A. Addition of new data to the EMP table
    B. Deletion of existing row from the EMP table
    E. Queries that search for data based on a condition on the ENAME column
  • 33. 

    Which two statements are true regarding the segment shrink operation? (Choose two.)

    • A.

      It compacts data within the segment.

    • B.

      It decreases I he size of the tablespace.

    • C.

      It can be performed only on an offline tablespace.

    • D.

      It reclaims unused space and retains it within the tablespace.

    Correct Answer(s)
    A. It compacts data within the segment.
    D. It reclaims unused space and retains it within the tablespace.
  • 34. 

    Which two statements are true regarding the Undo Retention Settings? (Choose two.)

    • A.

      Enabling Retenting Guarantee ensures that only long-running Queries do not fail.

    • B.

      Undo Retention Indicates the time period for which committed transaction data is retained.

    • C.

      Enabling Retention Guarantee ensures that long running queries and transactions do not fail.

    • D.

      Undo Retention indicates the time period or which uncommitted transaction data is retained.

    Correct Answer(s)
    B. Undo Retention Indicates the time period for which committed transaction data is retained.
    C. Enabling Retention Guarantee ensures that long running queries and transactions do not fail.
  • 35. 

    Which two statements are true regarding views? (Choose two)

    • A.

      Views contain no data

    • B.

      Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table

    • C.

      Views can be created only on tables in the same schema.

    • D.

      Views on one or more tables can be used to update the columns specified in the views.

    Correct Answer(s)
    A. Views contain no data
    B. Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table
  • 36. 

    Listed below are the database resident program units and their descriptions in random order.1. Package a. stored subprogram that is associated with a database table, view or event2. Procedure b. standalone program that must return a value3. Function c. structure that contains program definitions and PL/SQL code4. Trigger d. stand-alone program that may or may not return a value which optionspecifies the correct definition for each program unit?

    • A.

      1-c, 2-d, 3-b, 4-a

    • B.

      L-c, 2 b, 3-d, 4-a

    • C.

      L-a, 2-b, 3-d, 4-c

    • D.

      L-a, 2-d, 3-b, 4-c

    Correct Answer
    A. 1-c, 2-d, 3-b, 4-a
  • 37. 

    Your database instance in running.db01 is a net service name. You issue a connection request using thefollowing command:SQL>CONNECT scott/[email protected] component receives the request and establishes the appropriate connection?

    • A.

      Listener

    • B.

      User process

    • C.

      Service name

    • D.

      Server process

    Correct Answer
    A. Listener
  • 38. 

    You added the Following code in the tnsnames.ora file in the client PC:Sales=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=salesdatA (PORT=1521))(SRVICE_NAME=sales.acme))Which statement is true regarding the above code with respect to creating a new connectidentifier?

    • A.

      It gets created for a database, SALE, in the not work domain ACME on the SALESDATA server.

    • B.

      It generates an error because the server configuration mode-(-dedicated or shared is not specified.

    • C.

      It generates an error because the conned identifier name cannot be a part of the SERVICE_NAME.

    • D.

      It gets created for a database, SALESDATA, on the server SALES in the network domain called.

    Correct Answer
    C. It generates an error because the conned identifier name cannot be a part of the SERVICE_NAME.
  • 39. 

    You want to use the automatic management of backup and recovery operations feature for your database.Which configuration must you set?

    • A.

      Enable the flash recovery area and specify it as the archived redo log destination

    • B.

      Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    • C.

      Enable the flash recovery area but do not specify it as the archived redo log destination.

    • D.

      Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

    Correct Answer
    A. Enable the flash recovery area and specify it as the archived redo log destination
  • 40. 

    Which statement is true regarding the Oracle Universal Installer (OUI)?

    • A.

      OUI supports the installation of several of several active Oracle homes on the same host.

    • B.

      Operating system environment variables need to be set before running the OUI.

    • C.

      OUI can be used to uninstall only the complete Oracle software and not specific products.

    • D.

      OUI enables configuring of listener as part of the installation process but not the creation of Net.

    Correct Answer
    A. OUI supports the installation of several of several active Oracle homes on the same host.
  • 41. 

    Which three statements are true about database storage structures? (Choose three.)

    • A.

      A data file can span across tablespaces.

    • B.

      An extent contains one or more segments.

    • C.

      Table spaces contain one or more data files.

    • D.

      Data objects are stored as segments in tablespaces.

    • E.

      Segments can span across data files within a tablespace.

    Correct Answer(s)
    C. Table spaces contain one or more data files.
    D. Data objects are stored as segments in tablespaces.
    E. Segments can span across data files within a tablespace.
  • 42. 

    A customer recently had a security audit, when they were told that their test and development environmentcontained test data, which was the copy of production data, yet was not properly protected. Whattechnology should be used to quickly bring these environments into compliance?

    • A.

      Advanced Security Option

    • B.

      Audit Vault

    • C.

      Database Vault

    • D.

      Data Masking Pack or Enterprise Manager

    • E.

      Label Security

    Correct Answer
    C. Database Vault
  • 43. 

    Which two options describe the features of simple views?(Choose two.)

    • A.

      Hide data complexity

    • B.

      Improve data storage

    • C.

      Provide additional level of security

    • D.

      Speed up query and data manipulation language (DML) operations

    Correct Answer(s)
    A. Hide data complexity
    C. Provide additional level of security
  • 44. 

    Which two statements ore true regarding the-Database Configuration Assistant (DBCA)?(Choose two.)

    • A.

      It can be used to delete only the logical structure of a database.

    • B.

      It can be used to delete Uu1 logical structure and physical files of a database.

    • C.

      It can be used to change the configuration of a database only if it has been created using DBCA.

    • D.

      It can be used to change the configurations of o database that has been created either manually or using DBCA.

    Correct Answer(s)
    B. It can be used to delete Uu1 logical structure and physical files of a database.
    D. It can be used to change the configurations of o database that has been created either manually or using DBCA.
  • 45. 

    Your database is down. You log in as the user SYS and issue the following command:SQL>STARTUPWhich stops occur and in what order as a result of executing this command?

    • A.

      Only the instance is started.

    • B.

      Instance is started and then database is mounted but not opened.

    • C.

      Instance is started, then the database is mounted and finally opened.

    • D.

      Instance is started, then the database is opened and finally mounted.

    Correct Answer
    C. Instance is started, then the database is mounted and finally opened.
  • 46. 

    Which three options correctly match environment variables with their specific functionalities?(Choose three.)

    • A.

      ORACLE_SID: specifies the instance name

    • B.

      ORACLE_SID: specifies the global database name

    • C.

      ORACLE_BASE: specifies the toot of the Oracle Database directory tree in all platforms

    • D.

      ORACLE_BASE: specifies the directory containing the Oracle software executables and network file

    • E.

      ORACLE_HOME: specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms

    • F.

      ORACLE_HOME: specifies the directory containing only the Oracle software executables but not the network files

    Correct Answer(s)
    A. ORACLE_SID: specifies the instance name
    D. ORACLE_BASE: specifies the directory containing the Oracle software executables and network file
    E. ORACLE_HOME: specifies the root of the Oracle Database directory tree only in UNIX and Linux platforms
  • 47. 

    Choose three areas for which Oracle Database 11g Release 2 and Enterprise Manager offer tools that canrecommended solutions on optimal implementation.

    • A.

      Indexes

    • B.

      Compression

    • C.

      Data recovery

    • D.

      Data block size

    • E.

      CPU usage

    • F.

      Availability

    Correct Answer(s)
    A. Indexes
    B. Compression
    E. CPU usage
  • 48. 

    You started up your database In the NOARCHIVELOG mode. Which are the two implicationsof this setting? (Choose two.)

    • A.

      The database can be backed up only while it is closed.

    • B.

      The database can be completely recovered from Instance failure.

    • C.

      The database can be backed up when the database instance is running.

    • D.

      The database can be completely recovered from disk failure even after a log switch has happened and online redo logs are overwritten.

    Correct Answer(s)
    B. The database can be completely recovered from Instance failure.
    C. The database can be backed up when the database instance is running.
  • 49. 

    You have to create a table, STUDENTS, with the columns: STUENT_ID, STUDENT_NAME,DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced on thistable:Each student must be uniquely identifiable by the STUDENT_ID.The STUDENT_ID columns should not be left blank.The student should not be less than15 years of age.The student can only take a course that is specified in the COURSE table in the database.Which three constraints must be explicitly enforced on the table?(Choose three)

    • A.

      Check constraint on the COURSE_ID column

    • B.

      Foreign key constraint on the COURSE_ID column

    • C.

      Check constraint on the DATE_OF_BIRTH column

    • D.

      Unique key constraint on the STUDENT_ID column

    • E.

      Primary key constraint on the STUDENT_ID columns

    Correct Answer(s)
    B. Foreign key constraint on the COURSE_ID column
    C. Check constraint on the DATE_OF_BIRTH column
    E. Primary key constraint on the STUDENT_ID columns
  • 50. 

    Which method can you use to receive a notification when the free disk space in the recovery area fallsbelow 10%?

    • A.

      Submit a job that queries the Automatic Workload Repository (AWK).

    • B.

      Create an alert that sends a notification when the threshold value is reached.

    • C.

      Invoke the Database Configuration Assistant (DBCA. to configure notifications and set threshold values.

    • D.

      Specify the users who should receive notifications in the Preferred Credential of the Enterprise Manager.

    • E.

      Run the Automatic Database Diagnostic Monitor (ADDM) to analyze disk space and display a warning message.

    Correct Answer
    B. Create an alert that sends a notification when the threshold value is reached.

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Apr 14, 2015
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 14, 2015
    Quiz Created by
    Ivan.7.novak
Back to Top Back to top
Advertisement