Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-052.html
Oracle Database 11g: Administration I
Question No: 61 – (Topic 1)
The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?
-
Inactive and current redo log files are required to accomplish recovery
-
Online and archived redo files are required to accomplish instance recovery
-
All redo log entries after the last checkpoint are applied from redo log files to data files
-
All redo log entries recorded in the current log file until the checkpoint position are applied to data files
Answer: C
Question No: 62 – (Topic 1)
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
-
An extent cannot spread across data files.
-
A segment cannot spread across data files.
-
A data file can belong to only one tablespace.
-
A data file can have only one segment created in it.
-
A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.
Answer: A,C
Question No: 63 – (Topic 1)
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old What could be the reason for this error? Exhibit:
-
The query is unable to get a read-consistent image.
-
There is not enough space in Flash Recovery Area.
-
There is not enough free space in the flashback archive.
-
The query is unable to place data blocks in undo tablespace.
Answer: A
Question No: 64 – (Topic 1)
Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)
-
You can load data into multiple tables during the same load session
-
You can load data from multiple files to a table during the same load session
-
You cannot perform selective data loading based on the values available in the records
-
You can use an export file generated by the EXPDP utility as an input data file to load the data
-
You can load data only if the input file is available on the disk and tape but not a named pipes
Answer: A,B
Question No: 65 – (Topic 1)
SQLgt; AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
-
One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
-
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
-
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
-
One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
-
One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
Answer: C
Question No: 66 – (Topic 1)
Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)
-
Data Files
-
Control Files
-
Parameter Files
-
Online Redo Log Files
-
Server Parameter File
Answer: B,E
Question No: 67 – (Topic 1)
Which two operations can be performed on an external table? (Choose two.)
-
Create a view on the table
-
Create an index on the table
-
Create a synonym on the table
-
Add a virtual column to the table
-
Update the table using the UPDATE statement
-
Delete rows in the table using the DELETE command
Answer: A,C
Question No: 68 – (Topic 1)
View the Exhibit to examine the details for an incident.
Which statement is true regarding the status of the incident?
-
The DBA is working on the incident and prefers that the incident be kept in the ADR
-
The incident is now in the Done state and the ADR can select the incident to be purged
-
The incident has been newly created and is in the process of collecting diagnostic information
-
The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support
Answer: D
Question No: 69 – (Topic 1)
You have an ORDERS table with the following structure:
The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future.
Which method would serve the purpose?
-
Modify the column using the ALTER TABLE … MODIFY command.
-
Add a UNIQUE constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.
-
Add a NOT NULL constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.
-
Add a PRIMARY KEY constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.
Answer: A
Question No: 70 – (Topic 1)
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQLgt; UPDATE B.trans SET tr_amt=tr_amt 500 WHERE c_code=#39;C005#39;;
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQLgt; ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario? Exhibit:
-
The ALTER TABLE command modifies the column successfully
-
The DDL operation gets higher priority and transaction for user A is rolled back
-
The ALETER TABLE command waits indefinitely until user A ends the transaction
-
The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
Answer: D
Topic 2, Volume B
100% Ensurepass Free Download!
–Download Free Demo:1z0-052 Demo PDF
100% Ensurepass Free Guaranteed!
–1z0-052 Dumps
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 |
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF