1Z0-042章節(jié)練習(xí)(2019.05.05)

A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual

A.Transactions are rolled back using redo log files.
B.Transactions are rolled forward using redo log files.
C.Transactions are rolled back using redo log files and archived log files.
D.Transactions are rolled forward using redo log files and rolled back using redo log files.

A.Use a flashback query to retrieve the rows that were deleted
B.Useconventialincremental export and then import the affected object
C.Shutdown the database inNORMALmode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
F.Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

A.Modify the profile assigned to the user.
B.Modify the roles assigned to the users.
C.Modify the object privileges assigned to the user.
D.Modify the system privileges assigned to the users.
E.Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

A.Modify the value for the UTL_FILE_DIR parameter in the parameter file
B.Grant read and write privilege on the operating system path to the database users
C.Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
D.Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
E.Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users

A.by using the SQL access advisor
B.by using the Automatic Workload Repository report
C.by running the Automatic Database Diagnostic Monitor （ADDM）
D.by using the Automatic Workload Repository Compare Period report
E.by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

A.Displays only the list of default values
B.Displays only the list of all basic parameters
C.Displays the currently in effect parameter values
D.Displays only the list of all advanced parameters
E.Displays the list of all the parameter files of a database
F.Displays the current contents of the server parameter file.

A.Group 2 is the active group.
B.Group 2 is the current group.
C.Database is in the MOUNT state.
D.Group 2 has been already archived.

A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates

A.grant CONNECT role to all of the three users
B.grant RESOURCE role to all of the three users
C.grant both CONNECT and RESOURCE role to all of the three users
D.execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
E.create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users