Online Access Free 1z0-497 Exam Questions

Which two statements are true about shared server sessions?

• A.User Global Area is stored in System Global Area (SGA).
• B.Private SQL Area is allocated from Library Cache.
• C.Large Pool is used for SQL work areas.
• D.Shared SQL Area is allocated from Program Global Area (PGA).
• E.No Program Global Area (PGA) is allocated for shared server processes.

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

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

You want to drop a pluggable database from a multitenant container database that is used for development, which two statements are true?

• A.You can drop the PDB only if it is closed.
• B.When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.
• C.You can drop the PDB and keep the data files to be reused by another PDB.
• D.You can drop the seed PDB, but you cannot create any other PDB within the CD

Which tablespace contains the data dictionary, being automatically created at database creation?

• A.USERS
• B.SYSAUX
• C.SYSTEM
• D.EXAMPLE
• E.TEMP

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

• A.Invoking users can control who can access their privileges when they run an invoker's rights 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.The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.