The diverse nature of Alzheimer's disease (AD) has prompted researchers to develop multi-functional agents. Herein, we have designed and synthesized molecular hybrids of 2-pyridylpiperazine and 5-phenyl-1,3,4-oxadiazoles. Biological activities of synthesized compounds suggested significant and balanced inhibitory potential against target enzymes. In particular, compound 49 containing 2,4-difluoro substitution at terminal phenyl ring considered as most potential lead with inhibition of acetylcholinesterase (hAChE, IC50=0.054muM), butyrylcholinesterase (hBChE, IC50=0.787muM) and beta-secretase-1 (hBACE-1, IC50=0.098muM). The enzyme kinetics study of 49 against hAChE suggested a mixed type of inhibition (Ki=0.030muM). Also, 48 and 49 showed significant displacement of propidium iodide from the peripheral anionic site (PAS) of hAChE, excellent blood-brain barrier (BBB) permeability in parallel artificial membrane permeation assay (PAMPA), and neuroprotective ability against SH-SY5Y neuroblastoma cell lines. Further, 49 also exhibited anti-Abeta aggregation activity in self- and AChE-induced thioflavin T assay, which was ascertained by morphological characterization by atomic force microscopy (AFM). Moreover, in vivo behavioral studies signified learning and memory improvement by compound 49 in scopolamine- and Abeta-induced cognitive dysfunctions performed on Y-maze and Morris water maze. The ex vivo studies suggested decreased AChE activity and antioxidant potential of compound 49, with good oral absorption characteristics ascertained by pharmacokinetic studies.