Log point in time restore : If no transaction log backup is selected in a restore job , this option is ignored.

Apply all selected transaction log records --  Roll backup all transaction log records to database and restore database to latest state in selected backups .
Only transaction log records written before the specified date and time are applied to the database -- Restore database to a point in time .If the transaction log backup does not contain the requested time (for example, if the time specified is beyond the end of the time covered by the transaction log), the database remains unrecovered . In this case , to bring up database , please make a new job with following setting:
  1 . Do not select any backups .
  2 . Keep "Disable auto-select" checked .
  3 . Set the "Recovery Completion State" to "Database is brought up and ready for use" selection.
  4 . Run this job.

Recovery completion state : Specify what MS SQL Server should do after the database is restored.

Database is brought up and ready for use -- Database is ready for use (online) after restore job is done.
Database is NOT brought up , but able to restore additional transaction log or differential backup -- This option allows you can restore database step by step in several jobs.
Database is brought up for read-only access , and able to restore additional transaction log or differential backup -- Database is in read-only state after restore , this option is useful if you restore to a standby server .