Exam Code: 1z0-050 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: New Features for Administrators
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-050 Exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-050 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q91. View the Exhibits exhibit1 and exhibit2.
Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.
What is the reason for this?
A. It creates less metadata for the jobs.
B. It creates jobs temporarily in memory only.
C. It writes the job metadata to disk in compressed format.
D. It updates several tables in the SYSTEM tablespace instead of creating new tables.
Q92. Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A. Undo retention guarantee must be enabled.
B. Database must be running in archivelog mode.
C. Automatic undo management must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
Q93. Evaluate the following block of code:
acl => 'mycompany-com-permissions.xml',
principal => 'ACCT_MGR',
is_grant => TRUE,
privilege => 'connect');
acl => 'mycompany-com-permissions.xml',
host => '*.mycompany.com');
What is the outcome of the above code?
A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
Q94. You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
A. The command produces an error because the retention time cannot be reduced.
B. All historical data older than three years is purged from the flashback archive FLA1.
C. All historical data is purged and the new flashback data archives are maintained for three years.
D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
Q95. You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following commands:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)
A. They import all metadata from the RCAT10 catalog.
B. They unregistered the database from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They register all databases registered in the RCAT10 catalog.
Q96. Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;
What would be the outcome of this command?
A. It produces an error because data already exists in the table.
B. It produces an error because compression can be enabled at table creation only.
C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
Q97. You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users' passwords?
A. All passwords automatically become case-sensitive.
B. All passwords remain non-case-sensitive till they are changed.
C. All passwords remain non-case-sensitive and cannot be changed.
D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.
Q98. In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
where DB01 is the net service name.
Which authentication method would be used first?
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
Q99. Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other than SYS
Q100. You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.
What information is captured as part of this process? (Choose all that apply.)
A. the SQL text
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)