Promise in order to provide the high-quality Oracle exam dumps, Testking offers the top quality Oracle Oracle certification products with best questions and answers. You will obtain the most fresh and precise 1Z0-052 preparation supplies which promise your success at initial attempt. Take activities now and download your Oracle 1Z0-052 exam dumps today!
2021 Dec 1Z0-052 exam topics
Q71. You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
A. It must be made up of a database name and a domain name.
B. It must be made up of the value in ORACLE_SID and HOSTNAME.
C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
Answer: A
Q72. View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:
A. init.ora
B. spfile.ora
C. initorcl.ora
D. spfile+ASM.ora
Answer: B
Q73. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A. All AWR tables belong to the SYSTEM schema
B. The AWR contains systemwide tracing and logging information
C. The snapshots collected by the AWR are accessible through data dictionary views
D. The snapshots collected by the AWR are used by self-tuning components in the database
Answer: CD
Q74. The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:
Which statement is true after HR issues the REVOKE command?
A. The command fails because SCOTT still has privileges.
B. The command succeeds and privileges are revoked from JIM.
C. The command fails because HR cannot revoke the privileges from JIM.
D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
Answer: C
Q75. In a new installation of Oracle Database 11g, you perform these activities:
1. Organize software and data on different subdirectories to avoid poor performance.
2. Use consistent naming conventions for database files.
3. Separate administrative information pertaining to the database in different directories.
Which option corresponds to the type of activities you performed?
A. Oracle Managed Files
B. Oracle Grid Architecture
C. Optimal Flexible Architecture
D. Oracle database architecture
E. Automatic Storage Management
Answer: C
Avant-garde 1Z0-052 exam fees:
Q76. database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:
$ impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"
The command fails displaying the following error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable to obtain file status
What would you do to overcome the error?
A. Add the user, SYSTEM, to the schemas option.
B. Add the network_link = devdb.us.oracle.com option.
C. Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D. Replace the schemas option with the network_link = devdb.us.oracle.com
E. Replace the dumpfile option with the network_link = devdb.us.oracle.com
Answer: E
Q77. Which two statements are true about alerts? (Choose two.)
A. Clearing an alert sends the alert to the alert history
B. Response actions cannot be specified with server-generated alerts
C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view
D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified
Answer: AD
Q78. View the Exhibit and examine the setting for a table.
Which statement is true about the PCTFREE setting for the table?
A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
C. It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
D. It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
Answer: B
Q79. You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two)
A. The database automatically determines the extent-sizing policy for the tablespace.
B. The segments are automatically shrunk when the contents are removed from them.
C. The allocation of extents within the tablespace is managed through the dictionary tables.
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E. The space utilization description of the data blocks in segments is managed through free lists.
Answer: AD
Q80. View the Exhibit and examine the output of the query.
What do you infer from this?
A. The SGA_TARGET is a static parameter.
B. The instance is started, but the database is not yet open.
C. The server parameter file (SPFILE) was used to start the instance.
D. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.
Answer: C