Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-514
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-514.html

Oracle Database 11g Essentials

Question No: 31

Which two statements are true regarding the usage of integrity constraints? (Choose two.)

  1. l EM h column can have only one constraint.

  2. Primary key constrain) can consist of multiple columns from the same table.

  3. Foreign key column can reference e a primary key column in the same of or different

    tables.

  4. More than one row in a table cannot contain null value In a column with unique constraint.

  5. A chock constraint can enforce conditions that refer to the values in other columns in the table.

Answer: B,C

Question No: 32

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

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

  2. It can beaccessed only it thedefault preset port number1158 is available.

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

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

Answer: C

Question No: 33

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

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

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

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

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

Answer: B,D

Question No: 34

Which two statements arc true regarding object privileges? (Choose two.)

  1. Objectprivileges can begranted only by the owner of the object.

  2. The DBA can revoke object privileges from the owner of the object.

  3. Object privileges can be granted by both owner of the object and the DBA

  4. A user automatically has all the object privileges on all the objects contained in his or her schema.

Answer: C,D

Question No: 35

Which two statements are true regarding consistent backups? (Chooser two)

  1. Database can be opened immediately after the restore operation.

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

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

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

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

Answer: A,D

Question No: 36

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

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

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

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

  4. Specify the users who should receive notifications In the Preferred Credentials of the Enterprise Manager.

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

Answer: B

Question No: 37

Which three statements are true regarding the Database Configuration Assistant (DBCA. templates? (Choose three)

  1. Templates are stored as XML files.

  2. Templates are stored as HTML files.

  3. A new template can be created using only an existing database.

  4. Seed templates contain only the logical strut tuna of .in existing database.

  5. A new template can be created using either an existing database or template.

  6. Seed templates contain both the logical structure and physical files of an existing database.

Answer: A,E,F

Question No: 38

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

  1. Each group must have a minimum of two members.

  2. Each group must have the same number of members.

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

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

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

Answer: C,D

Question No: 39

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

  1. It compacts data within the segment.

  2. It decreases I he size of the tablespace.

  3. It can be performed only on an offline tablespace.

  4. It reclaims unused space and retains it within the tablespace.

Answer: A,D

Question No: 40

Which two statements are true regarding the usage of tools in administering an Oracle database? (Choose two.)

  1. Oracle Net Manager: configure a new or existing listener

  2. Data Pump: transfer of data from one database to another

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

  4. Database Upgrade Assistant: upgradeonly single-instance databases

  5. Database configuration Assistant (DBCA): create new database userin an existing database

Answer: A,B

100% Ensurepass Free Download!
Download Free Demo:1z0-514 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 1z0-514 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No