Online Access Free C_SASEAA_15 Practice Test

Which of the following can be used to identify frequently executed queries?

• A.Monitor and Data Analysis Tables
• B.sp_sysmon
• C.Monitor Server
• D.Query Processing Metrics

Which of the following are TRUE about lock promotion? (Choose three.)

• A.Row locks can be promoted to page locks.
• B.If other tasks hold locks conflicting with the type of table lock needed, lock escalation occurs.
• C.Page locks can be promoted to intent locks.
• D.Page locks can be promoted to table locks.
• E.If other tasks hold locks conflicting with the type of table lock needed, lock escalation does not occur.
• F.Row locks can be promoted to table locks.

What must occur following a non-logged transaction before normal dump transactions may resume?

• A.A transaction log dump with the truncate_only option
• B.A transaction log dump with the no_log option
• C.A database dump
• D.A truncate table on the table in question

What will be the result if the 'disk init' command is run to create a database device and no "vdevno" is specified?

• A.The command will create the device with a vdevno assigned by the server
• B.The command will fail without any adverse affects to the server
• C.The command will fail but the operating system file will be created
• D.The command will function properly because the server no longer uses 'vdevno'

For a full-merge join which of the following are TRUE? (Choose two.)

• A.Tables do not need to be sorted but can be merged using indexes
• B.Sort outer table in join order, then merge with the right inner table
• C.Sort inner table in join order, then merge with left outer table
• D.Tables being joined have useful indexes on join columns
• E.Sort both tables, then merge