Online Access Free C_SASEAA_15 Practice Test

Which of the following can NOT be used to automatically enable the configuration option 'allow updates to system tables' at boot time?

• A.sqlsrvr -m
• B.startserver -m
• C.dataserver -M
• D.dataserver -m

If a transaction places an update lock on a data page, what type of lock will a second
transaction get if it attempts to read the data using a SELECT statement?

• A.EXCLUSIVE lock
• B.No lock is placed as process will be blocked
• C.Another UPDATE lock
• D.SHARED lock

When sizing additional network memory, how many packets does each connection require?

• A.5
• B.4
• C.3
• D.2

Which of the following are TRUE about using the load database command? (Choose three.)

• A.the database must be exactly the same size as the database dump
• B.the database must be at least as large as the size of the database dump
• C.the database must not be marked as suspect
• D.the database must not be in use
• E.the database need not exist because load database will create the database
• F.the database must have been created with the for load option

During the installation, which of the following databases are created on the master device? (Choose two.)

• A.tempdb
• B.sybsecurity
• C.sybsystemprocs
• D.dbccdb
• E.model