Latest Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion, Page 9

Question #89

Which two are true about space management in tablespaces? (Choose two.)

A. Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other

B. Locally managed tablespaces track adjacent free space automatically by using bitmaps

C. Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces

D. Free lists are used for managing free space for segments in locally managed tablespaces

E. ASSM tablespaces prevent row chaining

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #90

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A. When there are more than one undo tablespace available in the database

B. When the undo tablespace is autoextensible and retention guarantee is not enabled

C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

D. When the data file of the undo tablespace is autoextensible

Discussion 0

Correct Answer: C Vote an answer

Question #91

User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans;
While the drop table operation is in progress; user B executes the following command on the same table; SQL> DELETE FROM trans WHERE tr_type='SL'; Which statement is true regarding the DELETE command?

A. It fails to delete the records because the table is locked in EXCLUSIVE mode

B. It deletes the rows successfully because the table is locked in the SHARE mod

C. It fails to delete the records because the records are locked in the SHARE mode

D. It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode

Discussion 0

Correct Answer: A Vote an answer

Question #92

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

A. The table created by HR remains and HR still has the CREATE TABLE system privilege

B. The table created by SKD is not accessible and SKD cannot create new tables

C. The tables created by SKD and HR remain, but both cannot create new tables

D. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

Discussion 0

Correct Answer: A Vote an answer

Question #93

For which requirement should you configure shared servers?

A. accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory

B. using Recovery Manager (RMAN) to recover a database

C. submitting backup jobs at regular, 24-hour intervals in an OLTP environment with limited memory

D. performing bulk-load operations in a DSS environment with limited memory

E. accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory

Discussion 0

Correct Answer: B Vote an answer

Question #94

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
* ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem. (Choose two.)

A. Add data files to the USERS tablespace.

B. Grant the CREATE ANY TABLE privilege to SCOTT.

C. Grant the RESOURCE role to SCOTT.

D. Increase the size of the data file associated with the USERS tablespace.

E. Increase the space for SCOTT on the USERS tablespace.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #95

Which of these is true about undo tablespace?

A. Undo tablespace has only one datafile

B. Undotablespace has a datafile which is reused in cyclic manner

C. Undo tablespace is a temporary tablespace

Discussion 0

Correct Answer: C Vote an answer

Question #96

Your database is down. You log in as the user SYS and issue the following command:
SQL>STARTUP
Which steps occur and in what order as a result of executing this command?

A. Instance is started, then the database is mounted and finally opened.

B. Only the instance is started.

C. Instance is started, then the database is opened and finally mounted.

D. Instance is started and then database is mounted but not opened.

Discussion 0

Correct Answer: A Vote an answer

Question #97

The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace.
Which three action would allow the user to insert data? (Choose three.)

A. Change the segment space management for the SMD tablespace to automatic.

B. Add a data file to the SMD tablespace.

C. Add a data file to the temporary tablespace associated with the user HR.

D. Resize the data file associated with the SMD tablespace to make it larger.

E. Alter the data file associated with the SMD tablespace to grow automatically.

Discussion 0

Correct Answer: B,D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #98

You are working on a database that must be functioning 24 hours a day, 7 days a week.
The database is configured in ARCHIVELOG mode.
Which two options do you have for performing user-managed backups? (Choose two.)

A. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.

B. You can back up data files only when all data files have the same SCN recorded in the control file.

C. You can perform a complete database backup without shutting down the database instance.

D. You can perform consistent backups only.

Discussion 0

Correct Answer: A,C Vote an answer

Question #99

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
After 30 minutes, you executed the following command:

What could be the reason for the elimination of the other rows in the output?
Exhibit:

A. The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

B. An Automatic Workload Repository snapshot has been taken recently.

C. The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

D. The threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z0-052 Demo