Download Oracle Database 11g-Administration I.PracticeTest.1z0-052.2019-02-05.1e.166q.vcex

Download Dump

File Info

Exam Oracle Database 11g: Administration I
Number 1z0-052
File Name Oracle Database 11g-Administration I.PracticeTest.1z0-052.2019-02-05.1e.166q.vcex
Size 4.92 Mb
Posted February 05, 2019
Downloads 61



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
SQL> CREATE BIGFILE TABLESPACE MRKT 
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 
Tablespace created. 
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; 
Database altered. 
Which two statements are true regarding the MRKT tablespace? (Choose two.)

  • A: No more data files can be added to the tablespace.
  • B: Segment space is managed by free lists in the tablespace.
  • C: A user created without being assigned a default tablespace uses this tablespace. 
  • D: The tablespace can be dropped with the current setting with segments present in it.



Question 2
View the Exhibit and examine the privileges granted to the MGR_ROLE role. 
The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:
SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION; 
Which statement is true about the user SKD after he/she is granted this role? 
Exhibit:

  

  • A: The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it
  • B: The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor
  • C: The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION
  • D: The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them



Question 3
After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:
SQL> ALTER DATABASE OPEN; 
Which two statements are true? (Choose two.)

  • A: The online redo log files and online data files are opened.
  • B: All the online data files headers are checked for consistency.
  • C: Instance recovery is performed before opening the database.
  • D: The path and existence of all the log file members are checked.



Question 4
Examine the 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 tablespace and a unique index is created on the OID column in the SYSTEM tablespace.



Question 5
Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

  • A: Shared SQL Area will be allocated in the shared pool.
  • B: Shared SQL Area will be allocated when a session starts.
  • C: Shared SQL Area will be allocated in the large pool always.
  • D: The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always.
  • E: Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
  • F: The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.



Question 6
Which three statements are correct about temporary tables? (Choose three.)

  • A: Indexes and views can be created on temporary tables
  • B: Both the data and structure of temporary tables can be exported
  • C: Temporary tables are always created in a user's temporary tablespace
  • D: The data inserted into a temporary table in a session is available to other sessions
  • E: Data Manipulation Language (DML) locks are never acquired on the data of temporary tables



Question 7
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  • A: Failure when no standby database is configured
  • B: Failure because a data file is renamed accidentally
  • C: Failure that requires no archive logs to be applied for recovery
  • D: Failure due to loss of connectivity-for example, an unplugged disk cable



Question 8
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

  • A: An extent cannot spread across data files.
  • B: A segment cannot spread across data files.
  • C: A data file can belong to only one tablespace.
  • D: A data file can have only one segment created in it.
  • E: A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.



Question 9
Which two statements are true regarding a tablespace? (Choose two.)

  • A: It can span multiple databases.
  • B: It can consist of multiple data files.
  • C: It can contain blocks of different files.
  • D: It can contain segments of different sizes.
  • E: It can contain a part of nonpartitioned segment.



Question 10
Which two statements are true regarding Oracle Data Pump? (Choose two.) 

  • A: EXPDP and IMPDP are the client components of Oracle Data Pump.
  • B: DBMS_DATAPUMP PL/SQL packages can be used independently of the DATA Pump clients.
  • C: Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
  • D: Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x.
  • E: EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.









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