Oracle Database 11g Essentials v6.1 (1z0-514)

Page:    1 / 5   
Total 71 questions

There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You issue the following command:
$lsnrctl start listener2
What 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.


Answer : A

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 event
2. Procedure b. stand alone program that must return a value
3. Functionc. structure that contains program definitions and PL/SQL code
4. Trigged. stand-alone program that may or may not return a value
Which option specifies 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


Answer : A

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

  • A. Enabling Retention 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.


Answer : B,C

You have to create a table, STUDENTS, with the columns: STUDENT_ID,
STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
-> 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 than 15 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. not null constraint on the DATE_OF_BIRTH column
  • F. primary key constraint on the STUDENT_ID columns


Answer : B,C,F

Which statement is true regarding the OracleUniversal Installer (OUI)?

  • A. OUI supports the installation 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 usedto uninstall only the complete Oracle software and not specific products.
  • D. OUIenables configuring of listener as part of the installation process but not the creation of Net


Answer : A

Which two statements ate true regarding the sever parameter file? (Choose two)

  • A. It can be edited manually.
  • B. It can be modified only by the server.
  • C. Its settings are persistent across shutdown and startup.
  • D. It must be maintained on the server and client machines.


Answer : B,C

Your database instance is running. You are not able to access Oracle Enterprise Manager
Database Control because the listener is not started.
Which tool or utility would you use to start the listener?

  • A. Oracle Not Manager
  • B. listener Control utility
  • C. Database Configuration Assistant
  • D. Oracle Net configuration Assistant


Answer : B

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. Itidentifies 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.


Answer : C

View the exhibit above.
Which two statements ore true regarding the status of data file backups after31 days?
(Choose two)

  • A. In Rash recovery area, they are deleted immediately.
  • B. In non lash recovery area, they .ire marked as obsolete and have to be deleted manually.
  • C. In flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.
  • D. In non flash recovery area, they are marked as obsolete but retained and deleted automatically when space is required.


Answer : C

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

  • A. Advanced Security Option
  • B. Audit Vault
  • C. Database Vault
  • D. Data Masking Pack tor Enterprise Manager
  • E. Label Security


Answer : C

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 changes 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.


Answer : B,E,F

Which two statements we true regarding the index creation recommendations given by
SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)

  • A. SQLTuning Advisor considers the impact of the indexes only queries.
  • B. SQLTuning Advisor considers the impact of new indexes on both queries and DML operations.
  • C. SQLTuning Advisor considers the impact of the newindexeson both queries and DML operations.
  • D. SQLTuning Advisor considers the impact of the indexes on only data manipulation language(DML) operations.


Answer : B,C

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


Answer : A,C

The RECYCLEBIN parameter is set to onfor your database. You drop a table,
PRODUCTS, from the SCOTTschema.
Which two statements are true regarding the outcome of this action? (Choose two.)

  • A. All the related indexes and views are automatically dropped.
  • B. The Flashback Drop feature can recover only the table structure.
  • C. Only the related indexes are dropped whereas views are invalidated.
  • D. TheFlashback Drop feature can recover both the table structure and its data


Answer : C,D

Evaluate the following command:
$sqlplus / noblog
In which scenario would the above command execute successfully?

  • A. Only from the server if the database instance is not up.
  • B. Eitherfrom 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 connectsthe 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.


Answer : B

Page:    1 / 5   
Total 71 questions