Download Oracle Database 11g-Administration I.PracticeTest.1z0-052.2018-04-24.1e.153q.vcex

Download Dump

File Info

Exam Oracle Database 11g: Administration I
Number 1z0-052
File Name Oracle Database 11g-Administration I.PracticeTest.1z0-052.2018-04-24.1e.153q.vcex
Size 4.83 Mb
Posted April 24, 2018
Downloads 114



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%





Demo Questions

Question 1
Examine the following steps performed on a database instance:
The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION 
The SKD user creates a table 
The SKD user grants the CREATE TABLE system privilege to the HR user 
The HR user creates a table 
The DBA revokes the CREATE TABLE system privilege from SKD 
Which statement is true after step 5 is performed?

  • A: The table created by SKD is not accessible and SKD cannot create new tables
  • B: The tables created by SKD and HR remain, but both cannot create new tables
  • C: The table created by HR remains and HR still has the CREATE TABLE system privilege
  • D: The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users



Question 2
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; 
Which two statements are true about the effect of the command? (Choose two.)

  • A: No flashback is possible to bring back the ITEM table.
  • B: The ORDERS table is dropped along with the ITEM table.
  • C: The dependent referential integrity constraints in the ORDERS table are disabled.
  • D: The dependent referential integrity constraints in the ORDERS table are removed.
  • E: The table definition of the ITEM table and associated indexes are placed in the recycle bin.



Question 3
View the Exhibit and examine the privileges granted to the SL_REP user. 

 
   

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: 
SQL> GRANT SELECT ON scott.emp TO hr; 
Which statement describes the outcome of the command?

  • A: The command executes successfully.
  • B: The command produces an error because the EMP table is owned by SCOTT.
  • C: The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION.
  • D: The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table.



Question 4
You executed this command to create a temporary table:

 
 
  
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

  • A: The rows stay in the table only until session termination
  • B: The rows stay in the table only until the next transaction starts on the table
  • C: The rows are visible to all current sessions after the transaction in committed
  • D: The rows stay available for subsequent sessions after the transaction is committed



Question 5
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. 
Which data types would you use for the new column?

  • A: CLOB
  • B: BLOB
  • C: BFILE
  • D: LONG RAW



Question 6
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:

  
 
The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully. 
What would you suggest to the PL/SQL developers to achieve this?

  • A: Create the procedure with definer's right.
  • B: Create the procedure with invoker's right.
  • C: Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
  • D: Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.



Question 7
Examine the following command that is used to create a table:

 
  
 
Which two statements are true about the effect of the above command? (Choose two.)

  • A: A CHECK constraint is created on the OID column
  • B: A NOT NULL constraint is created on the OID column
  • C: The ORDERS table is the only object created in the USERS tablespace
  • D: The ORDERS table and a unique index are created in the USERS tablespace
  • E: The ORDERS table is created in the USERS tablepsace and a unique index is created on the OID column in the SYSTEM tablespace



Question 8
View the Exhibit to examine the details for an incident. 

 
 
  
Which statement is true regarding the status of the incident?

  • A: The DBA is working on the incident and prefers that the incident be kept in the ADR
  • B: The incident is now in the Done state and the ADR can select the incident to be purged
  • C: The incident has been newly created and is in the process of collecting diagnostic information
  • D: The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support



Question 9
What can you achieve by implementing reverse key index?

  • A: Reverse the bytes of each column indexed including the row ID
  • B: Store a bitmap for each key value instead of a list of row IDs in the leaf node
  • C: Prevent contention on the highest leaf block when using sequences to generate keys
  • D: Remove repeated key values from the index to fit more index entries in a given amount of disk space



Question 10
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; 
What is the effect of this command?

  • A: One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
  • B: One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
  • C: One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
  • D: One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
  • E: One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset