1z1-497 무료 덤프문제 온라인 액세스

Which option represents the steps to add a multiplexed copy of the current control file or to rename a control file in Oracle Database 12c?
a - Shut down the database.
b - Restart the database.
c - Copy an existing control file to a new location by using operating system commands.
d - Edit the CONTROL_FILESparameter in the database initialization parameter file to add the new control file name, or to change the existingcontrol file name.

• A.b, c, d
• B.a, d, b, c
• C.c, d, b
• D.a, c, d, b

Which three statements are true about database storage structures?

• A.Segments can span across data files within a tablespace.
• B.Tablespaces contain one or more data files.
• C.Data objects are stored as segments in tablespaces.
• D.A data file can span across tablespaces.
• E.An extent contains one or more segments.

Which two statements are true when you execute an invoker's rights procedure?

• A.The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
• B.The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.
• C.The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.
• D.Invoking users can control who can access their privileges when they run an invoker's rights procedure.

An Oracle instance is a combination of______.

• A.System Global Area (SGA) and background processes
• B.database files and parameter file (initialization parameter file or server parameter file)
• C.a listener process, server processes, and background processes
• D.database files, System Global Area (SGA), and background processes
• E.System Global Area (SGA), server processes, and background processes

Why does performance degrade when many UPDATE, INSERT, or DELETEstatements are issued on a table that has an associated bitmap index?

• A.Additional time is taken to remove NULL values from the bitmap index alter a DML operation.
• B.The DML operations re-create the bitmap index blocks.
• C.The smallest amount of a bitmap that can be locked is a bitmap segment.
• D.The bitmap index is rebuilt automatically after a DML operation.